Lynn Pettis (8/12/2015)

---

I try very hard to be respectful and professional and help people even if it seems like they don't want the help; but I am not going to...

Agree, given the shortage of Silver Spoons since the last shipment hasn't arrived end yet.

😎

Edit: speech to text bug.

spree

Close to identical to the CTE version in performance and funny enough the QUERYTRACEON 8607 output tree differs only in...

Orwell

Quick solution, similar to Kutang Pan's but slightly more flexible

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

Campaign CHAR(2) ...

thbaig (8/12/2015)

---

Hi,

A strange issue is reported in production where one of stored proc is executing in variable time. Sometime with the same input it takes 5 sec and sometime more...

naïve

For giggles here is yet another slightly modified version. The difference doesn't look much but it is an improvement over the first one of roughly 20% and 5-10% over Luis's...

mar.ko (8/11/2015)

---

WHILE @@FETCH_STATUS = 0

BEGIN

FETCH NEXT FROM C_tables INTO

@ColName

,@ColOrdPosit

,@TabSchema

,@TabName

,@ColDataType

,@ColDefaultVal

;

PRINT @ColName + ' ' +STR(@ColOrdPosit) + ' ' +@TabSchema + ' ' +@TabName + ' ' + @ColDataType +...

Michelle-138172 (8/11/2015)

---

I have a job that runs an SSIS package. The job seems to be able to run through the package successfully, but at the end it errors out saying...

Didn't think I was geeky or nerdy but 30min after "just looking at few things", this was the MRU list

😎

In simple terms, blacklisting

😎

Sean Lange (8/11/2015)

---

I don't think that Eirikur...

mar.ko (8/11/2015)

---

@pvColumnName??VARCHAR(100) = Default,??

However, I am unable to determine what is the value for Default.

Is it '' ?

Default is not permitted as a constant - below fails to parse:

WHERE t2.TABLE_TYPE...