KaoSDlanor

Get incorrect trading days

May 3rd, 2013
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.39 KB | None | 0 0
  1. DECLARE @futureDate VARCHAR(14)
  2. SET @futureDate=CAST(datepart(yyyy,getdate()) AS VARCHAR) + '/' + CAST(datepart(mm,getdate()) AS VARCHAR) + '/' + CAST(datepart(dd,getdate())+1 AS VARCHAR)
  3. SELECT DISTINCT
  4. CAST(datepart(yyyy,DATE) AS VARCHAR) + '/' + CAST(datepart(mm,DATE) AS VARCHAR) + '/' + CAST(datepart(dd,DATE) AS VARCHAR)
  5. AS [DAYS OF INCORRECT TRADING]
  6. FROM invoices WHERE date>@futureDate
Advertisement
Add Comment
Please, Sign In to add comment