Viewing 15 posts - 931 through 945 (of 1,469 total)
Using LEAD will allow you to check the value of the next occurrence
WITH cteLead AS (
SELECT [ID], [SnapshotDate], [ProjectName], [ProjectValue]
, [NextVal]...
January 9, 2018 at 10:54 pm
ZZartin - Tuesday, January 9, 2018 3:01 PMPrey
Hunt
January 9, 2018 at 9:14 pm
Thank you Drew.
I will start testing and changing my list of RegEx expressions that I use.
January 2, 2018 at 12:14 pm
Take a look at the PIVOT operator
January 2, 2018 at 4:09 am
December 15, 2017 at 1:18 am
Alan.B - Wednesday, December 13, 2017 4:01 PMHack
Workaround
December 13, 2017 at 10:36 pm
December 13, 2017 at 8:17 am
I think this might be complicated. New to this forum, but okay at SQL....
December 12, 2017 at 11:16 pm
December 12, 2017 at 11:09 pm
My research appears to indicate that the old style joins were only partially discontinued.
The old ANSI style LEFT OUTER (*=) and RIGHT OUTER (=*) were Depricated...
December 12, 2017 at 10:36 am
December 10, 2017 at 1:40 am
Viewing 15 posts - 931 through 945 (of 1,469 total)