My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Mar 19th, 2010 | Syntax: T-SQL | Size: 0.23 KB | Hits: 54 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  1. USE NAVCronus
  2. GO
  3.  
  4. DECLARE @DATE AS DATE
  5. SET @DATE = '2006-05-05'  
  6.  
  7. SELECT TOP 1 *
  8. FROM dbo.[CRONUS Rt_$Currency Exchange Rate]
  9. WHERE [Currency Code] = 'USD' AND
  10.       [Starting DATE] <= @DATE
  11. ORDER BY [Starting DATE] DESC
create new paste | create new version of this paste RAW Paste Data