extracting to a report for upload into staging tables
Posted on 2013-05-20
I am using the following query to extract id numbers for inserting data, there is over 2000.
I need to extract to a populate to an excel report or export to exel the sql results.
how do you do it? I have tried saving it file but it is a sql file or crystal reports.
DECLARE @i int = 0
WHILE @i < 2497 BEGIN
SET @i = @i + 1