Viewing 15 posts - 1,891 through 1,905 (of 4,087 total)
NineIron - Tuesday, February 7, 2017 10:01 AMI'm not sure that the img tags are working.
You shouldn't be posting expected results as...
February 7, 2017 at 10:10 am
Use a conditional split and only add an output for the rows you actually want to process.
Drew
February 7, 2017 at 9:31 am
Try the following
, COALESCE(gl.YEAR1, MAX(gl.YEAR1) OVER(PARTITION BY Accts.ACTINDX ORDER BY Period.PeriodNo ROWS UNBOUNDED PRECEDING) as [Year]
Because you have a GROUP BY, you may need...
February 7, 2017 at 9:19 am
Here is my solution using a modified version of Lowell's sample data. (I treated numbers as numbers rather than strings.)
/* SET UP THE SAMPLE DATA...
February 7, 2017 at 9:09 am
February 6, 2017 at 3:10 pm
February 6, 2017 at 2:53 pm
February 6, 2017 at 1:23 pm
I'm no longer getting unread posts in a bold font. I also used to be able to hover over a link and get an arrow that would take me to...
February 6, 2017 at 1:17 pm
ParallelPeriod might be more appropriate.
February 6, 2017 at 10:14 am
February 6, 2017 at 9:48 am
You really should be using a reporting tool (like SSRS) to do complicated reporting like this. Most reporting tools can easily handle complex reports such as this.
If you...
February 6, 2017 at 9:27 am
SELECT 60
February 2, 2017 at 3:43 pm
Viewing 15 posts - 1,891 through 1,905 (of 4,087 total)