Yes Jeff, and so are we;-)

😎

That would be much louder and butted with "il culo rosso":-D

😎

jghali (7/31/2015)

---

Was looking into how to implement a secure way to use XP_CMDSHELL... I've read many of the posts... Very interesting...

Now! I'm more confused then when I started...

Since the db is already Tared and feathered, I guess the only approach is to pluck the feathers off one by one before hosing down the global settings. Each module/object...

Ray K (7/31/2015)

---

Rhyming attempts fail

Wagon Queen

Thanks Ed for this fine piece, certain that it will be a very handy reference.

😎

Quick example of how this can be done, you should be able to work it from there.

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'tempdb..#tmp_CustInfo') IS NOT NULL DROP TABLE #tmp_CustInfo;

CREATE TABLE #tmp_CustInfo

(patID varchar(20),

enc_date...

24 times more Steve:-D

😎

He he, C350 (50.000 in 0x), my favorite engine ever since the '67 Camaro:-D

😎

Lynn Pettis (7/29/2015)

---

Oh Silver Spoon, how do you manage to keep a job when you keep asking such basic questions. At least you found the answer to one of...

SQLRNNR (7/29/2015)

---

WayneS (7/29/2015)

---

Table...

Demanding

Quick thought, you aren't giving the optimizer much to go on here, using a table value function to populate a table variable which by the way doesn't have any statistics...

Quick fix adding the "@" to the attribute names;-)

😎

set@cropXML.modify('

delete (/Crop/Varieties/Variety[@Id=sql:variable("@varietyid")]/SoilTypes/SoilType/YieldGoals/YieldGoal[@Id=sql:variable("@yieldid")]/Stages/Stage[@Id=sql:variable("@StageId")])[1]

');