Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET @tsqlCommand = N'USE ' + CAST(@DB AS NVARCHAR) + N';
- SELECT TOP 100
- s.N_Code
- FROM SD_Subscr s
- WHERE
- s.F_Division = @LINKINT AND
- s.N_Code <> ''0'' AND
- (s.D_Date_End<@D_EndINT OR s.D_Date_End IS NULL)
- AND CAST(s.N_Code AS VARCHAR) NOT IN (SELECT p.s_account
- FROM tgk.dbo.prerender p
- WHERE
- p.N_Period < @N_PERIODINT AND
- p.f_division = @F_DIVISIONINT)'
- EXECUTE sys.sp_executesql @tsqlCommand, N'@F_DIVISIONINT INT, @N_PERIODINT INT, @LINKINT INT, @D_EndINT SMALLDATETIME', @F_DIVISIONINT=@F_DIVISION, @N_PERIODINT=@N_PERIOD, @LINKINT=@LINK, @D_EndINT=@D_End;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement