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

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 ever correctly used for...

Thanks for the feedback and you are most welcome.

😎

ErikMN (8/14/2015)

---

I'm trying to find a specific string (a name) and replace it with another inside of a VARCHAR(7000) field. Unfortunately, there are names like Ted and Ken that I'm...

ManiDBLover (8/15/2015)

---

Hi Guys,

I have a requirement to Insert Column 1 and Column 2 based on below condition only. Looking for a Store procedure or query

Condition : Allow Insert when...

Quick suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

;WITH SampleData (PERSON, STARTDATE, ENDDATE, INPUNCH, OUTPUNCH, HOURS,PAYCODE) AS

(

SELECT 1125,'08/11/2015','08/11/2015','08:00', '12:00',4.0, 'REGULAR'

UNION ALL SELECT 1125,'08/11/2015','08/11/2015','13:00', '17:00',4.0, 'SICK'

...

Do you have a schema...

Here is one way of doing this, maybe not the most efficient but it works.

The method is almost identical to what Chris posted before and works with the sample...

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:, so...