SQL Server Performance Forum – Threads Archive
How to use inner sub queryHai
In my procedure from one table,say for example I am maintaining transaction dates, from that I have to get latest two dates. And that two dates are the parameters for the another query. First date is the from date and second date is the to date. I used cursor to get the result, but it is time consuming one, also I used sub-query in the where condition, it is also take more time…How to I resolve this one
S.Jeya Prabhu "A ship in Harbour is safe,
But that is not what ships are built for."
Can you post some sample data and the result you want? Madhivanan Failing to plan is Planning to fail
We need more information on order to help you.
If you’re unsure how to get the information Madhivanan asked for, here’s a good link that should help you:http://www.aspfaq.com/etiquette.asp?id=5006 —
Microsoft SQL Server MVP
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)