Viewing 15 posts - 1,156 through 1,170 (of 1,469 total)
I believe that this will meet your requirements
WITH T(N) AS (SELECT N FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS X(N))
, NUMS(N) AS (SELECT ROW_NUMBER() OVER (ORDER BY...
April 20, 2017 at 1:29 pm
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
Viewing 15 posts - 1,156 through 1,170 (of 1,469 total)