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.

😎

[font="Courier New"]Wish you all a happy new year![/font]

😎

TomThomson (12/30/2014)

---

Eirikur Eiriksson (12/30/2014)

---

I find both human and computer languages a very fascinating subject, must admit that I've been taken aback by the general ignorance here in the UK when...

Jeff Moden (12/31/2014)

---

Eirikur Eiriksson (12/31/2014)

---

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

vamsye (12/31/2014)

---

I'm not calling via script task, this is a regular dtsx package and it does not even have any script components in it.

This pop up comes after the validations...

vamsye (12/31/2014)

---

I'm getting the following pop up message whenever I'm trying to open a SSDT solution.

Note: I have already registered the Dts.dll, but it did not make any change, also...

Steve Jones - SSC Editor (12/31/2014)

---

I think DAS was coined when expansion boxes attached to servers using external SCSI connections. This distinguishes it from storage across a network using HBAs,...

Jeff Moden (12/31/2014)

---

@jesse.owen,

I'm totally confused as to what the purpose of the YearMonth column in the #tab_MonthlyData table is. If you have columnar month data, why is each row...