Viewing 15 posts - 5,221 through 5,235 (of 13,872 total)
If your source and destination tables are both on the same machine (which your initial post suggests), it would probably be a better idea to write a stored proc to...
August 28, 2017 at 11:10 am
August 28, 2017 at 8:08 am
If quantities get to 100 or more, you are likely to blow your max recursion limit & will need to use a different technique.
August 25, 2017 at 2:12 pm
August 25, 2017 at 12:49 pm
Some additional advice.
Add SET NOCOUNT ON.
I suggest you use DATE datatypes rather than DATETIME.
Use a temp table rather than a table variable – they usually perform better.
August 25, 2017 at 11:40 am
August 25, 2017 at 7:59 am
WITH summed
AS
(
SELECT
td.Chunk
, NewChunk = SUM(IIF(td.LineNum = 1, 1, 0)) OVER (ORDER BY td.recid
ROWS UNBOUNDED PRECEDING
)
FROM #tempData td
August 25, 2017 at 7:21 am
August 24, 2017 at 2:12 pm
August 24, 2017 at 2:10 pm
August 24, 2017 at 1:41 pm
August 24, 2017 at 12:13 pm
Secondly, Phil is wrong that you need a join. What you should be doing is updating the table through the CTE.
Damn it, why do I always forget this...
August 24, 2017 at 11:51 am
August 24, 2017 at 11:08 am
Can you get the required data using [msdb].[dbo].[sysssispackages] .
Please help to get the required o/p
SELECT...
August 24, 2017 at 7:13 am
Viewing 15 posts - 5,221 through 5,235 (of 13,872 total)