Viewing 15 posts - 1,036 through 1,050 (of 4,087 total)
I've updated the staging table definition. I used a temp table here, but you should use your regular table.
CREATE TABLE #table(
id INT IDENTITY,
...
August 10, 2018 at 8:59 am
August 10, 2018 at 7:57 am
There is a third option if you can add an identity column to your staging table. Is that possible?
Drew
August 10, 2018 at 7:27 am
August 10, 2018 at 7:22 am
Please don't post in multiple forums. It fragments the discussion.
Please post all responses here.
August 9, 2018 at 2:23 pm
August 9, 2018 at 10:22 am
It's hard to tell on such a small sample, but using GROUPING SETS might actually perform better.
WITH payments AS
(SELECT 100.00 AS Ex_VAT,
20.00 AS...
August 9, 2018 at 10:01 am
August 9, 2018 at 7:29 am
August 8, 2018 at 2:44 pm
August 8, 2018 at 2:38 pm
Use a case sensitive collation in your test. It's simple enough that you really don't need a stored procedure.
August 8, 2018 at 8:57 am
I think that a cross tab might perform better here, especially since you're already doing aggregates on the data. I used a CROSS APPLY instead of writing essentially the same...
August 8, 2018 at 8:47 am
Eric M Russell - Wednesday, August 8, 2018 8:07 AMI'm talking about code reviews by the DBA.
It doesn't matter. It's still...
August 8, 2018 at 8:25 am
Also, we asked for sample data and expected results. You've only provided the first half of that.
Drew
August 8, 2018 at 7:53 am
August 8, 2018 at 7:52 am
Viewing 15 posts - 1,036 through 1,050 (of 4,087 total)