Viewing 15 posts - 1,156 through 1,170 (of 1,468 total)
I am currently unable to test this solution,
But I believe the syntax to be correct.
WITH XMLNAMESPACES('http://schemas.microsoft.com/sqlserver/2006/03/15/reporting/reportingservices' AS rs)
, getxml AS (
...
April 20, 2017 at 1:02 pm
Is this table possibly used as a staging area for processing data.
If it is, are many deletes, and no truncate? That would be one scenario where the IDENTITY gets...
April 20, 2017 at 9:08 am
April 19, 2017 at 10:02 pm
April 19, 2017 at 2:29 pm
April 19, 2017 at 1:45 pm
Without proper test data, this is untested code.
However, I believe that this will give you what you need
WITH cteData AS (
SELECT
m.[Member...
April 19, 2017 at 1:28 pm
April 19, 2017 at 1:11 pm
April 19, 2017 at 9:35 am
Brandie Tarvin - Wednesday, April 19, 2017 7:40 AMSo what hotels have you been staying at lately?
Luckily I can't afford to...
April 19, 2017 at 7:45 am
April 19, 2017 at 7:03 am
Another thing to consider is the fact that you are joining 3 views to get very limited data.
You will most likely get much better perf by getting the data...
April 19, 2017 at 3:55 am
Viewing 15 posts - 1,156 through 1,170 (of 1,468 total)