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

Well IMO writing queries on paper wont inform you about errors such as syntax errors, i personally prefer to write queries in Query Analyzer. In query analyzer you will be informed abouy any kind of error exist in the query and once its tested i move it to it's destination such as stored proc..

Charul Shukla