Sean Lange (8/19/2015)

---

I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT...

Ed Wagner (8/19/2015)

---

djj (8/19/2015)

---

Eirikur Eiriksson (8/18/2015)

---

DonlSimpson (8/18/2015)

---

Revenant (8/18/2015)

---

whereisSQL? (8/18/2015)

---

TomThomson (8/18/2015)

---

Ed Wagner (8/18/2015)

---

SQLRNNR (8/18/2015)

---

Ed Wagner (8/18/2015)

---

ChrisM@Work (8/18/2015)

---

djj (8/18/2015)

---

Ed Wagner (8/17/2015)

---

Luis Cazares (8/17/2015)

---

whereisSQL? (8/17/2015)

---

Eirikur Eiriksson (8/17/2015)

---

Ed Wagner (8/17/2015)

---

eccentricDBA (8/17/2015)

---

low-cost provider...

Bearing

Simple solution but not...

You are right,...

ShuaibV (8/18/2015)

---

Hello

Can you please let me know how we can replace the multiple values in a single select statement? I have to build the output based on values stored...

TomThomson (8/18/2015)

---

Jeff Moden (8/14/2015)

---

Eirikur Eiriksson (8/14/2015)

---

Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:,...

No it initially creates a data file...

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @Process table(ProcessId int identity(1,1) primary key,ProcessName varchar(100),ParentStep int, ChildStep int);

Insert into @Process(ProcessName,ParentStep,ChildStep)

select 'Process1',1,2 union all

select 'Process2',1,3 union all

select 'Process3',1,6 union all

select 'Process4',4,2 union all

select 'Process5',4,5;...

krypto69 (8/17/2015)

---

Hi,

Never had a need to use snapshots before.

I have a dev SQL2014 server. My devs would like to take a DB snapshot then run there code, then use that...

Someone should then run sp_addserver

😎

WYPIWYG

cory.bullard76 (8/17/2015)

---

When I insert the following into my query...I get an error

,max(case when patins.rank = 1.0 then CLAIMS.[TOTALPAID] else '' end)

TotalPaid is a field that contains, for example, 445.45

The...

ilovedata (8/16/2015)

---

I have a source from which I select the AccountID, StatusID, and value. I am using an aggregation Transform to find the SUM(Value) GROUP BY AccountID, StatusID.

I will have...

Jeff Moden (8/16/2015)

---

Eirikur Eiriksson (8/16/2015)

---

Jeff Moden (8/16/2015)

---

Gosh, I'd be real careful here, Eirikur. While your good code certainly does what was asked, it will fail if table SampleData2 is...