Hi Guys,

I got the Answer from this thread.

http://www.sqlservercentral.com/Forums/Topic1442095-1292-1.aspx

Thanks to Gila Monster

I just removed some unwanted indexes from my table and found that the Eager Spool has been removed...

DECLARE @date [datetime]

SELECT @date = MAX([datecolumn]) FROM [your_table]

SELECT [required column | * ]

FROM [your_table]

WHERE [datecolumn]=@date

Thanks,

Prabhu

Yeah,

I agree with you, sorry, I was unable to reply you in time.

when I went on working out that, I found the issue,

then i wrote this one, which...

Thanks Guys,

for reading my post,

finaly i got it,

yes,it is possible in the single query, it is..

select max(item) over()item from my_table where id = 5

Thanks,

Prabhu

Thanks for your effort dwain,

I think I have missed out something while populating the #loanheader, you my try the script with #loandetail instead of loandetail in the script directly....

Hi Steven,

I am really glad to see your post, My Hearty thanks for all your time & effort to help, really your Idea have helped me to get out this...

I really worried that there is nobody to help me regarding this issue, I was so confident that I could get a solution from this forum, but so far I...

Hi all,

thanks for your spending your finest time, I am sorry about "not giving my question clearly", but I have got some valuable tips from your replies that to avoid...

Hi Lowell,

yes, I tested the Idea which you suggested and found it is working, thanks for your valued time,

Thanks,

Prabhu...(siva)

Hi Gila,

Thanks for your effort to read my post, but the issue which I thought to overcome, has been suggested by lowell.

Thanks again,

Prabhu...

@Gila-Monster

Hi,

I would like to give you a small correction in your code which is the right one, it is a small thing but needed.

in your query you have given the...