1 October 2012

Cursor In Sql


declare @dist_code varchar(500)
declare @email varchar(500)

declare crtopic cursor For
SELECT    distinct distributor_master.dist_code, distributor_master.email
FROM  distributor_master INNER JOIN Life_Cycle_Maintain
ON distributor_master.dist_code = Life_Cycle_Maintain.Dist_Code

Open crtopic
Fetch Next From crtopic Into
@dist_code,@email
If @@FETCH_STATUS =0
Begin
while @@FETCH_STATUS = 0
Begin
declare @outputfile varchar(max)
set @outputfile ='E:\Satish\'+ @dist_code +'_'+ REPLACE(getdate(), ':', '_') +'.xls'
declare @query varchar(max)
set @query ='select * from [DTDC_DB].[relapp].[dbo].VW_Dist_sendmail_Data where [Distributor Code]='''+ @dist_code +''' order by [Uniq ID No]'
--print @query
EXEC master.dbo.sp_makewebtask
@outputfile,
@query,
@colheaders =1,
@FixedFont=0,@lastupdated=0,@resultstitle='Caf status details'

Fetch Next From crtopic Into @dist_code,@email
End
End
close crtopic
deallocate crtopic