Viewing 5 posts - 1 through 6 (of 6 total)
Thank you so much, I've been able to amend that to my needs. Very much appreciated!
February 25, 2015 at 1:59 pm
I'm sorry, I'm trying to follow all the instructions but lost on how to create the test data for you. All that I'm trying to create are two columns,...
February 25, 2015 at 1:06 pm
The query produces this:
ID Year
1012011
2002012
1842011
1842013
1332014
1362011
1892012
1522013
1292011
1842013
1362011
but I want to change the queried results to look like this (with a count of Years):
Year
ID2011201220132014
1011
2001
18411
1331
1362
1891
1521
1291
1841
February 25, 2015 at 11:53 am
I'm just trying to get something to work so I can test it. Not sure what to put between the THEN and ELSE statement:
select
W_SUMMARYDETAILS.FACILITY_ID,
SUM...
February 25, 2015 at 10:53 am
I am tying to work on a small piece of the pie here with this code but it doesn't work as desired -- are there any glaring errors here? ...
February 25, 2015 at 10:06 am
Viewing 5 posts - 1 through 6 (of 6 total)