Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advice on writing queries

Status
Not open for further replies.
ZAMBER25

ZAMBER25

Technical User
Jun 23, 2005
7
NL
Hi experts. could an expert tell me what it the best practice in starting writing a queries? should i first write it in paper then run it in sql server ? Furthermore, could an expert tell me a quide line on how to takle a query ?Thanks
 
Sort by date Sort by votes

Paper???? Are you mad??? Why murder some inocent trees???

For guidance, check out this and this and this link.
[noevil]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Upvote 0 Downvote
no paper...

start writing simple queries on test tables on live database...

see and analyze the results for each query you try...

and practice a lot..

-DNG
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
206
szeiss
szeiss
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
149
mikrom
mikrom
kdbenson
  • Locked
  • Question
Match unlinked data based on datetimes
Replies
1
Views
126
JarlH
JarlH
faimuj
  • Locked
  • Question
Help on Update Statement
Replies
2
Views
142
faimuj
faimuj
JustATheory
  • Locked
  • Question
max value based on two columns
Replies
1
Views
124
carp
carp

Part and Inventory Search

Sponsor

Back
Top