Got an iPhone or iPad? We have a brand new Pastebin App for both devices, and it's totally free! Click here to download the new Pastebin App for iOS.
Public Pastes
Guest

Untitled

By: a guest on Mar 19th, 2010  |  syntax: T-SQL  |  size: 0.23 KB  |  hits: 54  |  expires: Never
download  |  raw  |  embed  |  report abuse
Copied
  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 a new version of this paste RAW Paste Data