Viewing 15 posts - 1,591 through 1,605 (of 2,643 total)
Change the MERGE to be an UPDATE followed by an INSERT. This will probably give you a 40% performance improvement.
Check if the merge is updating any indexes, as this could...
April 24, 2019 at 3:52 pm
Declare @TheTable table (ID int, V1 varchar(1), V2 varchar(2), V3 varchar(1), V4 varchar(1))
Insert into @TheTable values (1, 'A', NULL, NULL, NULL)
Insert into @TheTable values (2, 'B', NULL,...
April 23, 2019 at 9:04 am
March 26, 2019 at 10:42 am
March 25, 2019 at 10:43 am
March 25, 2019 at 9:15 am
March 25, 2019 at 7:36 am
It will exist with a count of zero.
You need to replace 'COUNT(*)' with '*'
March 25, 2019 at 4:55 am
March 22, 2019 at 11:58 am
March 22, 2019 at 10:21 am
I am looking for an output like this