Viewing 15 posts - 136 through 150 (of 183 total)
Guess I should be a little more clear.
I am looking to count the # of requests for the current month and last 3 months(Static).
But don't know how COALesce will be...
January 11, 2014 at 8:41 am
Thank you. Got it working...
SELECTCAST(
CASE WHEN someCondition THEN someValue
ELSE otherValue
END
as CHAR(11)
)
FROMtableExpression
January 8, 2014 at 10:33 am
No worried .. I figured it out:)
Its
Sum (case .... then 1 else 0)
December 24, 2013 at 9:12 am
I get this error : 'SUM' is not a recognized built-in function name.
December 18, 2013 at 1:34 pm
Thaks you for the reply.
My query shows the sequence in correct order in management studio. However , its in report builder that it messes up.
P.S : I am trying to...
December 16, 2013 at 3:45 pm
No worries, I figured out. I was seeting up actions on text box . Setting up actions on the text made the difference...
December 11, 2013 at 1:48 pm
On the Chart look for Series Properties ( You can see when you right click on a bar /Column), select Axes and Chart Area and you will be able to...
December 10, 2013 at 10:59 am
Say if you are displaying Production for each month select Months in Category groups and production as values for bars.
You will be able to see seperate months......
December 9, 2013 at 2:07 pm
Viewing 15 posts - 136 through 150 (of 183 total)