SQLRNNR (12/26/2014)

---

Lynn Pettis (12/26/2014)

---

SQLRNNR (12/26/2014)

---

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS...

It's a habit which comes from the strange over clause defaults,...

Hugo Kornelis (12/26/2014)

---

I picked the least incorrect answer and got my points. But the answer is still wrong. The more correct answer would be that it finds all stored procedures...

jgdil01 (12/24/2014)

---

In a nutshell, I'm trying to copy a DB from a 2005 version of SQL to the 2014 version (on different servers) using the Copy DB wizard. I'm...

First of all, good job with the data and the DDL, made this easy;-)

Here is a quick window function solution, self explanatory and should get you passed this hurdle

😎

USE tempdb;

GO

SET...

Luis Cazares (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS...

Lynn Pettis (12/23/2014)

---

Eirikur Eiriksson (12/23/2014)

---

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

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

...