Viewing 15 posts - 5,236 through 5,250 (of 13,877 total)
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
I have 3000 rows of address data in a single field called Address.
The actual...
August 24, 2017 at 6:00 am
The UPDATE statement is this bit:WITH Ordered
AS
(
SELECT
t.Id
, rn = ROW_NUMBER() OVER (ORDER BY t.Dsc)
FROM...
August 24, 2017 at 5:57 am
You need to join back to your subquery on the table's PK or unique key. Here is an example:
CREATE TABLE #test1
(
Id INT...
August 24, 2017 at 5:43 am
August 24, 2017 at 5:23 am
If your packages are deployed to SSISDB, this is not possible because the packages are stored in an encrypted format.
August 24, 2017 at 5:03 am
Lynn Pettis - Wednesday, August 23, 2017 5:40 PMReally sick of JC and his comments.
Take comfort in not being alone.
August 23, 2017 at 5:43 pm
August 23, 2017 at 5:42 pm
August 23, 2017 at 12:03 pm
August 23, 2017 at 10:16 am
Viewing 15 posts - 5,236 through 5,250 (of 13,877 total)