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

SQLRNNR (12/26/2014)

---

Lynn Pettis (12/26/2014)

---

SQLRNNR (12/26/2014)

---

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS...

It's a habit which comes from the strange over clause defaults,...

Hugo Kornelis (12/26/2014)

---

I picked the least incorrect answer and got my points. But the answer is still wrong. The more correct answer would be that it finds all stored procedures...

jgdil01 (12/24/2014)

---

In a nutshell, I'm trying to copy a DB from a 2005 version of SQL to the 2014 version (on different servers) using the Copy DB wizard. I'm...

First of all, good job with the data and the DDL, made this easy;-)

Here is a quick window function solution, self explanatory and should get you passed this hurdle

😎

USE tempdb;

GO

SET...

Luis Cazares (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS...

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now. My...