SQL Server Performance Forum – Threads Archive
Poor in writing complex queries
Hi all,I am Poor in writing complex queries. can you please suggest me some link from wher I can learn writing complex queries? I am not good at writing them.
Ashish Johri
Look up an author called "Dan Tow" (SQL Tuning). He had som pretty interesting approaches to writing complex queries. Alternatively, just take it easy, queries never become that complex. If they are, it is probably because you datamodel is FUBAR. It that case, re-model you data, and the query part will be easy. regs, Eventloop "Follow the join tree" – Dan Tow
What do you mean by complex query? Why do you want to write them if they are complex queries? You should always think easy way first. [<img src=’/community/emoticons/emotion-5.gif’ alt=’
‘ />]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ashish.johri2007</i><br /><br />Hi all,<br />I am Poor in writing complex queries. can you please suggest me some link from wher I can learn writing complex queries? I am not good at writing them.<br /><br /><br />Ashish Johri<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><pre id="code"><font face="courier" size="2" id="code"><br />Thanks,<br /><br />Name<br />——— <br />Dilli Grg <br /><br />(1 row(s) affected)<br /></font id="code"></pre id="code">
Hey Thanks Dilli for comments. I shall always remember KISS principle ‘Keep it small and simple’. Ashish Johri
]]>