Viewing 15 posts - 2,011 through 2,025 (of 4,087 total)
January 12, 2017 at 10:03 am
Is there a way to get the Like/Share/Report buttons on the same line as the Reply/Multiquote buttons?
I do like the preview down at the bottom.
Drew
January 12, 2017 at 9:09 am
vpolasa (1/11/2017)
January 11, 2017 at 3:55 pm
It's because you're converting your XML to VARCHAR(MAX), just leave it as XML and you shouldn't have these problems. The FOR XML directive treats text that looks like XML...
January 11, 2017 at 10:09 am
JJMEIJER (1/10/2017)
WITH cteSports AS (
SELECT * ,sn = ROW_NUMBER() OVER (PARTITION BY name ORDER BY sport)
FROM #example
)
SELECT name,...
January 10, 2017 at 2:54 pm
It helps if you specify what the error is when you get an error. I ran your code and did not receive an error. My best guess is...
January 10, 2017 at 1:14 pm
MMartin1 (1/10/2017)
drew.allen (1/10/2017)
MMartin1 (1/9/2017)
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL...
January 10, 2017 at 1:06 pm
MMartin1 (1/9/2017)
You forgot the NOT.
SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;
How about
SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL END
?
same...
January 10, 2017 at 10:22 am
The problem is that the definition of "duplicate" here is not well defined. Specifically, you want to count times as duplicates if they fall within a specific threshold of...
January 9, 2017 at 4:49 pm
CELKO (1/7/2017)
I see absolutely no benefit to having this as a check constraint rather than as a foreign key constraint.
The check constraint can be used by the optimizer immediately; it...
January 9, 2017 at 8:51 am
You do have a partial CROSS JOIN somewhere. Looking at the query plan, the hash match join has inputs with 297K and 907K rows, but the output is 129,682K...
January 9, 2017 at 8:28 am
I'm about to leave on vacation, so I don't have time to do a thorough write-up, but the general approach is to use a tally table to get a row...
January 5, 2017 at 3:53 pm
CELKO (1/5/2017)
Having a new sport shouldn't require a DDL change. Getting a list of available sports shouldn't need to remove duplicates.
I would make the argument that the list of...
January 5, 2017 at 3:42 pm
Viewing 15 posts - 2,011 through 2,025 (of 4,087 total)