LAG is available on SQL 2012.

what have you tried that isnt working?

good to hear it all worked out ok for you.

-- CAVEAT.....

--I think that you need to clearly understand the structure of your data

--from your posts so far your sample tables and data keep changing

--if you find that the following...

b.grove (5/13/2016)

---

I'm confused. I already have a document table with the exact same data in it called Dcoument Signed

So why create another document table duplicating the existing Document Signed...

b.grove (5/13/2016)

---

I understand but I don't have create table access only readonly. So I don't have the insert code you are looking for. I did just post a...

😉

so you have now changed table "emp" structure....

is table "emp1" still the same as you have previously posted,...

In another thread I asked you about the table structure

http://www.sqlservercentral.com/Forums/FindPost1785784.aspx

and you replied to say that it was correct........!!

It apppears that you are going around in circles here and in your...

can you...

possibly ???

note i altered your sample data to get relevant results

Create table emp(emp_code int,Enddate DATETIME,shift INT,shifttype INT)

INSERT INTO emp VALUES(635,'20160503',2,1)

INSERT INTO emp VALUES(635,'20160508',2,1)

INSERT INTO emp VALUES(635,'20160514',1,1)

Create table emp1 (empid INT,shift...

Sean Lange (5/12/2016)

---

sestell1 (5/12/2016)

---

Yea, very strange. I'm curious as to why it's an issue suddenly now?

Automatic suppression of posts reported as spam by a certain threshold number of users...

ok...so other than the "data"...which can be easily migrated to v2014 (I assume?)...what else do you need.....logins/jobs/dts packages etc etc

spose what I am really asking.....why do...

alex.sqldba (5/12/2016)

---

Good Evening JL;

Small in this instance is 7GB.

Downtime wise, as long as I want really as it is to be (eventually) merged into our existing data. But wanted to...

in your other post you said "In the process of migrating a small DB to SQL Server 2014"

maybe if we know what your definition of small is....and what the db...

yb751 (5/12/2016)

---

Caz68 (5/12/2016)

---

I dont know what IFCode is sorry.

I am using SQL server 2008 so assume that is MS SQL and not MYSQL as per my title apologies as I...