Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. DECLARE @SQL NVARCHAR(1000)
  2. SELECT @SQL = N'SELECT * FROM tfn_ArticleHistory (''2019-05-07'',''2019-05-07'',77,929)'
  3. EXEC sp_executesql @SQL
  4.  
  5. SELECT * FROM SELECT * FROM tfn_ArticleHistory ('2019-05-07','2019-05-07',77,929)
  6.  
  7. DECLARE @StartDate DATETIME ='2017-05-07',@EndDate DATETIME ='2019-05-07',@CompanyINT =77,@ArticledINT = 929
  8. SELECT * FROM report.SELECT * FROM tfn_ArticleHistory (@StartDate,@EndDate,@Company,@Articled)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement