Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 15th, 2012  |  syntax: None  |  size: 0.46 KB  |  hits: 7  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Trouble translating a SQL statement
  2. ,SUM(CASE WHEN [Gads].[GadsEventTypeCode] IN ('D1', 'D2', 'D3', 'DP', 'PD', 'DM', 'D4')
  3.     THEN [Allocation].[AllocatedEnergyMwh] ELSE 0 END /
  4.     CAST([Unit].[NetDependableCapacity] AS FLOAT)) AS Hrs_Derate
  5.        
  6. var types = new [] { "D1", "D2", "D3", "DP", "PD", "DM", "D4" };
  7.  
  8. Hrs_Derate =
  9.     ((types.Contains(gads.GadsEventTypeCode) ? allocation.AllocatedEnergyMwh : 0)
  10.     / (Convert.ToFloat(unit.NetDependableCapacity))).Sum()
create a new version of this paste RAW Paste Data