Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.57 KB | None | 0 0
  1. SET @tsqlCommand = N'USE ' + CAST(@DB AS NVARCHAR) + N';
  2. SELECT TOP 100
  3.     s.N_Code
  4. FROM SD_Subscr s
  5. WHERE
  6.     s.F_Division = @LINKINT AND
  7.     s.N_Code <> ''0'' AND
  8.     (s.D_Date_End<@D_EndINT OR s.D_Date_End IS NULL)
  9.     AND CAST(s.N_Code AS VARCHAR) NOT IN (SELECT p.s_account
  10. FROM tgk.dbo.prerender p
  11.     WHERE
  12.         p.N_Period < @N_PERIODINT AND
  13.         p.f_division = @F_DIVISIONINT)'
  14. 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