Jeff Moden (1/2/2015)

---

Eirikur Eiriksson (1/2/2015)

---

I must be the saddest (read nerdiest/most pathetic) in this bunch, got the day off...

I must be the saddest (read nerdiest/most pathetic) in this bunch, got the day off but still spent 10...

Jeffery Williams (1/2/2015)

---

Ok I think I will need to use a temp table for this and there is no code to share as of yet. Here is the intent.

I need...

Quick...

marcia.j.wilson (1/2/2015)

---

Thanks. I had come across that link, but it wasn't quite what I was looking for. I'm looking for something...

Only the second query which uses 'true' as a predicate has an implicit conversion

😎

<Object...

Quick thought, don't think that in this case it makes any difference, looked into this quite a while back and I couldn't find any implicit conversion in the execution plan.

😎

My bad, sp_describe_first_result_set is only available in 2012 and later, you will have to use the FMTONLY set statement. It will bring back an empty result set if the query...

Quick example on how to use the system procedure sp_describe_first_result_set to validate the dynamic SQL

😎

USE tempdb;

GO

/* Query to test */

DECLARE @SQL_STR NVARCHAR(MAX) = N'SELECT...

spaghettidba (1/1/2015)

---

Happy New Year everybody!

And there's a very special thank you message for every single one of you on my blog here! 🙂

Thank you for involving me in the most...

Quick suggestion: Integration Services Data Types

😎

Oops, didn't read the question properly:pinch:

😎

Quick suggestion, use a "country" table, otherwise it is not possible to do this, consider the example below.

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* Country table */

DECLARE @COUNTRY TABLE

(

COUNTRY_NAME...

Quick suggestion, check the self monitoring data (SMART) of the hard drive,a non-intrusive operation. Utility for this can be found here http://www.smartmontools.org

😎

Quick thought, think you are better off trying sp_describe_first_result_set or sys.dm_exec_describe_first_result_set for this.

😎