Viewing 15 posts - 331 through 345 (of 10,144 total)
May 15, 2018 at 7:05 am
A recursive CTE works for this, and could provide you with a template for a quirky update:
;WITH CalculatedData AS (
SELECT
c.cust_id,...
May 4, 2018 at 9:53 am
Sergiy - Friday, May 4, 2018 7:45 AMJust remove the record from the distribution list.Keep all the contact details intact.
Sergiy - when...
May 4, 2018 at 8:24 am
May 4, 2018 at 4:39 am
May 4, 2018 at 4:37 am
jonathan.crawford - Wednesday, May 2, 2018 6:16 AMJeebus Chris, I mean, if it works, it works, but yowza https://www.sqlservercentral.com/Forums/1934310/Upper-Case-Lower-Case?Update=1#bm1934444
If it works,...
May 2, 2018 at 6:42 am
April 30, 2018 at 10:05 am
April 26, 2018 at 1:24 am
Since it was suggested that loading all the data by quarter is not the...
April 25, 2018 at 8:38 am
I am very new to SQL and am in the process of building my first...
April 25, 2018 at 7:52 am
April 25, 2018 at 3:42 am
April 25, 2018 at 2:11 am
From BOL: "Both the source table or partition, and the target table or partition, must reside in the same filegroup. The corresponding indexes, or index partitions, must also reside in...
April 25, 2018 at 2:08 am
One publisher server, 27 publications, One distribution database.
I think you could be right , because...
April 23, 2018 at 7:58 am
As always any help to...
April 23, 2018 at 6:03 am
Viewing 15 posts - 331 through 345 (of 10,144 total)