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 question is when do...

Andre 425568 (12/23/2014)

---

I also get this error on SQL 2012, I am using OLEDB Destinations. I am trying to run 5 inserts at the same time, is the issue just...

Quick question, can you script out the table including all indexes and post it, curious on how that looks?

😎

While you are at it, pour 45 ml of good Gin over a ripe slice of lime and 3-4 chunky ice cubes,...

LutzM (12/23/2014)

---

Based on Eirikurs solution here's a slightly modified version.

Differences: The code below does only one SELECT against the Process table and the result of the SELECT ist stored in...

Jeff Moden (12/22/2014)

---

Stefan Krzywicki (12/22/2014)

---

jasona.work (12/22/2014)

---

Stefan Krzywicki (12/22/2014)

---

Steve Thompson-454462 (12/22/2014)

---

Stefan Krzywicki (12/22/2014)

---

Steve Thompson-454462 (12/22/2014)

---

---

Brandie Tarvin (12/16/2014)

---

But still... To my mind, since I'm already fixing one part of the package, why...

nancy.lytle (12/22/2014)

---

This is the whole code:

Set NoCount On

Declare @LastRun varchar (50)

Declare @CreateFail varchar(50)

Declare @FailureCount int

Declare @Fail int

Set @LastRun =

(SELECT Process_ID, Process_Name, Last_Message_Time ...

Quick simple suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE(TSTR VARCHAR(100) NOT NULL);

INSERT INTO @SAMPLE_DATA(TSTR)

VALUES ('<key>Children</key><integer>2</integer>')

,('<key>Children</key><integer>123</integer>')

,('<key>Children</key><integer></integer>')

;

DECLARE @children INT = 4;

SELECT

...

Nice "first coffee" question, thanks.

😎

BTW: another good read on the subject (MSDN) Caching Mechanisms

DonlSimpson (12/16/2014)

---

MMartin1 (12/16/2014)

---

It would not, but that is what the user wanted. That is to...

Replace "Select *...

The code demonstrates how to use sp_describe_first_result_set to get...

A quick example of sp_describe_first_result_set

😎

DECLARE @RES TABLE

(

is_hidden ...

Stefan Krzywicki (12/16/2014)

---

Eirikur Eiriksson (12/16/2014)

---

Jeff Moden (12/16/2014)

---

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

---

Jeff Moden (12/14/2014)

---

In the category of learning something new, I just did some testing on the differences between ONLINE...

Quick thought and if I remember correctly, use ODATaskParams.Fill to populate the object type variable

😎