Click here to Skip to main content
15,912,932 members

Comments by Member 8128040 (Top 17 by date)

Member 8128040 11-Jan-14 12:03pm View    
then wat is the use of finally block.
Member 8128040 3-Dec-13 14:09pm View    
may be there's some problem at ur sql engine...
its a simple wat's wrong in this...
Member 8128040 3-Dec-13 14:06pm View    
actaully ryan this is the sample its a subquery which is used inside a big query which i have to improve for performance.
Member 8128040 3-Dec-13 13:58pm View    
Deleted
i got d answer without any join
finally what i want data which comes as per d order of "query" before union clause
so i just use order by and when

Select type from supportContacts
order by
case when code_id=1033 then 1 end

please suggest is i m wrong....
Member 8128040 28-Aug-13 4:55am View    
this is the code now tell me wat else u want..

[edit]Code moved to OP's question[/edit]