Forum Replies Created
Viewing 5 posts - 1 through 5 (of 5 total)
-
RE: Moving Annual Total cross tab by month with Difference in one column
I have cut all the table joins down to help with making this ledgible. As mentioned this then goes into SSRS and is grouped up
-
RE: Moving Annual Total cross tab by month with Difference in one column
Thanks. I managed to solve this linking to a time table and using Lag Over (partition AccountNo, [Timetable].Month Order by [Year]. The data was then returned to SSRS and grouped appropriately.
-
RE: Split out a field of comma separated values based on a unique code in the same row.
Trawler - Thursday, April 20, 2017 2:19 AM