Viewing 15 posts - 316 through 330 (of 4,820 total)
February 13, 2019 at 11:13 am
You can simplify this by using a different default value for the lag function.
[code...
February 13, 2019 at 10:54 am
February 13, 2019 at 10:39 am
First, using a character based column for any kind of sequential identifier is problematic and costly of its own accord. So you probably need to get away from that idea...
February 13, 2019 at 10:31 am
February 13, 2019 at 10:19 am
Try the following:IF OBJECT_ID(N'tempdb..#TEMP_TABLE', N'U') IS NOT NULL
BEGIN
DROP TABLE #TEMP_TABLE;
END;
SELECT '01' AS 'rn', '2017-07-01' AS 'dt', '1' AS 'status'
INTO #TEMP_TABLE
UNION ALL
February 13, 2019 at 10:11 am
My variables were declared, @Column wasn't supposed to be a variable though, that's a...
February 13, 2019 at 9:36 am
Okay folks. Recursion is not necessarily a problem, although it certainly can be. For smaller data sets, it can be quite helpful. I took a look at this and my...
February 13, 2019 at 7:14 am
February 13, 2019 at 6:44 am
February 12, 2019 at 10:55 am
February 12, 2019 at 10:30 am
One change I made yesterday...
February 12, 2019 at 8:59 am
Insufficient detail. Please be a lot more detailed in your description of EXACTLY what you are trying to do. You can't just assume that everyone here knows what you are...
February 12, 2019 at 8:48 am
February 8, 2019 at 9:26 am
Viewing 15 posts - 316 through 330 (of 4,820 total)