KaoSDlanor

Correct date on invoices

May 3rd, 2013
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.75 KB | None | 0 0
  1. DECLARE @currentDate VARCHAR(14),@shiftn AS INT
  2. SET @currentDate=CAST(datepart(yyyy,getdate()) AS VARCHAR) + '/' + CAST(datepart(mm,getdate()) AS VARCHAR) + '/' + CAST(datepart(dd,getdate()) AS VARCHAR)
  3. SELECT top 1 @shiftn=shiftnum FROM tillpost WHERE date>@currentDate AND date<getdate()
  4.  
  5. IF NOT @shiftn IS NULL
  6. UPDATE invoices
  7. SET DATE=@currentDate + ' ' + CAST(datepart(hh,DATE) AS VARCHAR) + ':' + CAST(datepart(mi,DATE) AS VARCHAR) + ':' + CAST(datepart(ss,DATE) AS VARCHAR),
  8. shiftnum=@shiftn
  9. WHERE date>getdate()
  10. IF NOT @shiftn IS NULL
  11. SELECT top 1 'COMPLETED SUCCESSFULLY, INVOICES MOVED TO SHIFTNUM: ' + CAST(@shiftn AS VARCHAR) AS Outcome FROM invoices
  12. ELSE
  13. SELECT top 1 'NO TILLSHIFTS ON THE CURRENT DATE: ' + @currentDate AS Outcome FROM invoices
Advertisement
Add Comment
Please, Sign In to add comment