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...

TomThomson (12/28/2014)

---

Eirikur Eiriksson (12/26/2014)

---

Gleðileg jól og farsælt nýtt ár!

Merry Christmas and a happy new year!

Buon Natale e felice anno nuovo!

Frohe weihnachten und ein gutes neues jahr!

Glædelig jul og godt nytår

God...

Are you experiencing locking or any other problems and that is why you are using NOLOCK? Or are you using it...

Quick suggestion, use the sp_describe_first_result_set (or the equal tvfn) to bring back the details of a result set, see the demo code below, should be enough to get you passed...

Jeff Moden (12/28/2014)

---

Hugo Kornelis (12/24/2014)

---

DrKiller (12/23/2014)

---

wow what a complex way of doing it.

I'm usually just doing this 🙂

DECLARE @tmpString VARCHAR(MAX)

SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM...

Just brilliant as always Jeff, Chapeau!

Quick modification, mainly dropping the ISNULL as the set will not contain any nulls

😎

Run results

OPERATION ...

Quick(er) suggestion, simplifying the query and loosing the sort required by the parallel execution plan

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @INT_BUCKET INT = 0;

DECLARE...

SQLalchemy (12/26/2014)

---

I need to take a temporary table that has various times stored in a text field (4:30 pm, 11:00 am, 5:30 pm, etc.), convert it to miltary time then...

Jeff Moden (12/26/2014)

---

Luis Cazares (12/26/2014)

---

Happy Holidays to everyone!

I wish that you can enjoy quality time with your families and beloved ones and may the new year bring you happiness and...