Edit: not working.

An alternative window function based solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @CHANGE_TYPE VARCHAR(50) = 'Change1';

;WITH SAMPLE_DATA(CustomerID,ChangeType,OldValue,NewValue,TimeStamp) AS

( SELECT CustomerID,ChangeType,OldValue,NewValue,CONVERT(SMALLDATETIME,TimeStamp,0) FROM

(VALUES

...

Post the full and complete code you are running, including source definition, source query, insert statement and the destination table definition. Don't leave anything out!

😎

The change is simple, the sequence needs to be shifted so it starts counting at zero instead of one as otherwise it counts the night when it ends not when...

Thank you for the question Iulian. Fortunately we have come a long way from default sa accounts with no password, rpc wide open, early WebDav and other such horrors, still...

Straigt from the source;-)

😎

Quick though, use the object_definition function, that is the same as the system views use. Don't recall that I changed any settings on the system I'm using, brings back everything...

My 2 Cents: The SQL Server database platform is probably the most mature product Microsoft offers, some of the other components of the sQL Server Stack are less so. It...

That is straight...

aashish.khn (9/25/2014)

---

Hi all, I am very new to SSIS. I am trying to create package with following problem.

A folder has following files:

A1.xlsx

A2.xlsx

A3.xlsx...

SQLRNNR (9/25/2014)

---

Sean Lange (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every...

New Born DBA (9/25/2014)

---

We usually have a job...

Sean Lange (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single...

Quick questions, have you any checks on long running transactions? Any changes or new implementations? Why is autogrowth set to 10%?

😎

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Alvin Ramard (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

SQLRNNR (9/25/2014)

---

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single QOTD from the last...

Lynn Pettis (9/25/2014)

---

Gary Varga (9/25/2014)

---

Eirikur Eiriksson (9/25/2014)

---

Too much...