Great It works for me thanks

i need to display output in the crystal report.

For the above select into statement executes with 15 seconds but while i gave like select * from #temp its again taking more than 35 minutes.

Hi,

My Query is Pretty simple. A aduit table is having day to day transactions of the Student Table manipulation information. In that i need to display the...