Viewing 7 posts - 1 through 7 (of 7 total)
drew.allen (10/31/2016)
david.jack (10/31/2016)
drew.allen (10/28/2016)
david.jack (10/28/2016)
ScottPletcher (10/27/2016)
Seems more confusing than the natural CASE statement to me:SUM(CASE WHEN VAL1 <> 0 THEN VAL1 ELSE VAL2 END)
VAL1 can return NULL unfortunately so using...
October 31, 2016 at 9:55 am
ScottPletcher (10/28/2016)
david.jack (10/28/2016)
ScottPletcher (10/27/2016)
Seems more confusing than the natural CASE statement to me:SUM(CASE WHEN VAL1 <> 0 THEN VAL1 ELSE VAL2 END)
VAL1 can return NULL unfortunately so using a comparison...
October 31, 2016 at 3:26 am
drew.allen (10/28/2016)
david.jack (10/28/2016)
ScottPletcher (10/27/2016)
Seems more confusing than the natural CASE statement to me:SUM(CASE WHEN VAL1 <> 0 THEN VAL1 ELSE VAL2 END)
VAL1 can return NULL unfortunately so using a comparison...
October 31, 2016 at 3:11 am
ScottPletcher (10/27/2016)
Seems more confusing than the natural CASE statement to me:SUM(CASE WHEN VAL1 <> 0 THEN VAL1 ELSE VAL2 END)
VAL1 can return NULL unfortunately so using a comparison operator won't...
October 28, 2016 at 4:02 am
Hmmmm... it doesn't work in my scenario but, as per your assessment, the formula does seem to be correct, so my results must be the product of joins/grouping I guess....
October 27, 2016 at 5:10 am
coool_sweet (10/20/2016)
i have table from where data is coming like this
price
12.345
345.6789
23.56
now i am taking this into tem table nd what i need is remove decimal and round the number...
October 27, 2016 at 4:57 am
Hi Grasshopper,
I'm having this issue having moved a report from SSRS 2005 to SSRS2012. I have 2 options to edit this report. One being the Report Builder 3.0 - running...
December 2, 2014 at 5:48 am
Viewing 7 posts - 1 through 7 (of 7 total)