How to create an Excel file using SQL 2005

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 1

Use the following example.

select (@maxno/50000) + 1 SheetsCount

while @maxno >= 0

begin

select @TempSno = isnull(@TempSno,0) + 1

select * from yourtable where Slno between (50000 * (isnull(@TempSno,0)-1))+1 and 50000 * @TempSno order by Slno

select @maxno =@maxno - 50000

Dhiren Shah-425130 SSC Rookie Points: 32 More actions · Answer 2

Thanks for your reply....but I want script to generate Excel file.