Jeff Moden (12/30/2014)

---

Eirikur Eiriksson (12/30/2014)

---

I do agree here and this is where things get really interesting, although metaphorically speaking one is indeed entering the forest of great misconceptions. Heavier iron...

Michael Meierruth (12/30/2014)

---

Jeff, so what was the trick?

I guess when you need to execute something only once and it takes 900 miliseconds you give it no further thought.

Still, getting anything...

Quick and slightly hurried example of how to achieve this, mind you it's not a complete solution but should be enough to get you passed this hurdle. (Some) Comments in...

Quick suggestion, should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.myTable') IS NOT NULL DROP TABLE dbo.myTable;

GO

CREATE TABLE dbo.myTable

(

MT_ID INT...

TomThomson (12/29/2014)

---

Eirikur Eiriksson (12/29/2014)

---

TomThomson (12/28/2014)

---

Here are some more languages people can guess at:-

Nollaig chrìdheil agus bliadhna mhath ùr

Nollaig faoi shéan agus ath-bhliain faoi shonas

Nollick ghennal as blein vie noa

Bonan Kristnaskon...

Jeff Moden (12/28/2014)

---

Eirikur Eiriksson (12/27/2014)

---

Run results

OPERATION ...

That's because of...

Quite few ways of doing this, here are two quick solutions

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_A') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_A;

CREATE TABLE dbo.TBL_SAMPLE_A

(

COL_A INT...

Quick thought, passing NULL to the @AgentUserID parameter will set the dynamic pivot statement concatenation to NULL, consider this example

😎

DECLARE @PARAM_NULL VARCHAR(8) = NULL;

/* NULL concatenation */

SELECT 'A STRING CONCAT...

Quick thought, the property_id values are the same in both sets and therefore it will never hit the NOT MATCHED clause. To fix this, add another column to the criteria.

😎

MERGE...

Quick question, which edition of SQL Server are you using? Reason for asking is that if you are using the Enterprise edition,...

dwain.c (12/28/2014)

---

I wanted to take a moment to wish all the forum members a (late) Merry Christmas and a Happy New Year.

I've been extremely busy of late so have been...

david.gugg (12/29/2014)

---

I'm getting to this one a day late, but as written it now returns NULL:

DECLARE @OUTPUT VARCHAR(max);

SELECT @Output = @Output + SPECIFIC_SCHEMA + '.' + SPECIFIC_NAME + Char(13) +...

d.carpenter (12/29/2014)

---

I'm looking for a script that identifies max values used in a table for all smallints, ints and bigints to determine if they are being used correctly.

I know...

Jeff Moden (12/28/2014)

---

Thanks, Eirikur. You're the consummate Gentleman and...