Jeff Moden (1/19/2015)

---

Eirikur Eiriksson (1/19/2015)

---

Quick thought, if the table's content is only being maintained with the MERGE statement, it would be better to move the trigger's logic into that implementation,...

ashokputta9 (1/19/2015)

---

Hi everyone i want split the data this below format..

1.Split the RR ("PL:TW RR:1.8%,PL:TX RR:0.9%") into LowendRR ("PL:TW RR:1.8%") and HighendRR ("PL:TX RR:0.9%")

2.Split the LowendRR ("PL:TW RR:1.8%") into LowendPL...

Quick thought, if the table's content is only being maintained with the MERGE statement, it would be better to move the trigger's logic into that implementation, that's straight forward with...

ryanabr (1/19/2015)

---

First, thanks everyone for your help on this, it is really appreciated!

I am using SQL Azure and I it looks like the LEAD and LAG keywords are not supported....

Jeff Moden (1/19/2015)

---

Jack Corbett (1/19/2015)

---

Jeff Moden (1/18/2015)

---

Grant Fritchey (1/18/2015)

---

WayneS (1/18/2015)

---

I'm curious...

How many folks have a home lab set up with servers?

How many folks just use virtual machines...

Grant Fritchey (1/19/2015)

---

Eirikur Eiriksson (1/19/2015)

---

Grant Fritchey (1/18/2015)

---

WayneS (1/18/2015)

---

I'm curious...

How many folks have a home lab set up with servers?

How many folks just use virtual machines on a computer (be...

Grant Fritchey (1/18/2015)

---

WayneS (1/18/2015)

---

I'm curious...

How many folks have a home lab set up with servers?

How many folks just use virtual machines on a computer (be it laptop, etc)?

Other?

If you...

For completion, here is a SQL Server 2012 and later version using the window functions, roughly 3x faster than the 2005/2008 method

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @temp as table

(

ID int identity,

TS...

Maybe it's the absense of the industrial strength espresso in the morning but I'm not certain what the question is, can you please elaborate?

😎

Further on twin.devil's reply, the cardinality (#) of the two tables indicates the action, if #inserted > 0 and #deleted =0 then "insert", if #inserted > 0 and #deleted >...

This is relatively easy to do on SQL Server 2012 and later, can you let us know which version you are on? Meanwhile here is a quick set based solution...

Jeff Moden (1/17/2015)

---

To help wet my appetite for reading that stairway further, would someone please just tell me how to load the previously identified packages so that I might have...

Jeff Moden (1/16/2015)

---

Samuel Vella (1/16/2015)

---

Jeff Moden (1/15/2015)

---

No problem. Thank you very much for your efforts.

I have to admit that when it comes to SSIS, I get totally lost because...

smitty-1088185 (1/16/2015)

---

I was reading this blog below about Indexed Views and needed some clarification.

When the author choose to create the unique clustered index he excluded the PER.BusinessEntityID

columns and...

Quick thoughts, this trigger is supposed to copy the data being inserted into the dbo.Employee table into the dbo.EmployeeAudit table, catch error in the insert and roll back the transaction...