Hi Steve ,
Thanks very much for detailed and clear explanation 🙂
To check the subqueries, you'd need to replace the a.xx in the subquery with a particular value to see how the subquery returns data.
So Just to be sure that i understood properly, I need to write like below right ?
SELECT MIN(b.CREATEdate)
FROM schedule b
WHERE b.customerid=1
)
Am i right Steve ?
And also for the below quote
Also, the query you have is badly formed. This part
FROM #tmpAbstract AS A,CodeChangesdata AS c1
Could you please tell me why you are saying it is badly formed, I mean will it cause any performance issues
or query itself is wrong because this query is running in my application for a long time .
Thanks in Advance !!!