Viewing 15 posts - 4,666 through 4,680 (of 13,876 total)
February 20, 2018 at 12:36 pm
February 20, 2018 at 11:55 am
February 20, 2018 at 11:02 am
February 20, 2018 at 10:52 am
craig.jenkins - Tuesday, February 20, 2018 5:50 AMI'm an idiot, sorry guys
Don't be so hard on yourself, we've all done it 🙂
February 20, 2018 at 5:57 am
Thank Guys, i've attached some dummy data below. As you can see the regdates are not older than 5 years
And that is why you are selecting them.
February 20, 2018 at 5:46 am
February 20, 2018 at 5:13 am
February 19, 2018 at 9:56 am
February 19, 2018 at 8:23 am
February 19, 2018 at 6:43 am
February 19, 2018 at 5:56 am
Please describe why the solution i provided is unsatisfatory. It worked ok for me.
February 17, 2018 at 3:18 pm
Here is one way:
WITH AllVals
AS
(
SELECT
*
, PrevColB = LAG(t.ColB, 1) OVER (ORDER BY t.ColA)
, PrevColC = LAG(t.ColC, 1)...
February 16, 2018 at 2:12 pm
February 16, 2018 at 12:35 pm
If anyone has completed their daily cryptic crossword, only to find themselves pining for more puzzlement, take a look at this.
February 16, 2018 at 10:33 am
Viewing 15 posts - 4,666 through 4,680 (of 13,876 total)