Will this work for you? It does not rely on a lag() which are not available before SQL SERVER 2012.

SELECT

T2.[WEEK] , T2.CAMPUS, T2.BUILDING, T1.[OCCUPIED SUITES] AS OCCUPIED_SUITES_WEEK_START, T2.[OCCUPIED...

One thing I can say for the BIT type .... I can see the issues arising from not knowing the yes/no answer at time t1. So these were allowed...

Just to cover, there are no triggers firing on the destination table correct?

Also from this page https://msdn.microsoft.com/en-us/library/ms141237(v=sql.105).aspx

I can see where it reads "Performance can be improved if you...

I did like the article basically promoting thinking things out at design time to see if the state you want to represent with a BIT data type is truly a...

SSIS has a deployment utility to help with these sort of things. Right click your project name at the top in BIDS > properties > deployment utility.... set CreateDeploymentUtility =...

This works with TRUE or FALSE >

DECLARE @mybit bit;

SET @mybit = 'true';

SELECT @mybit

Though yes/no , on/off do not. Just want to add to this post.

Borrowing the table and data creation

CREATE TABLE SampleData(

FIRST_NAME varchar(20),

MIDDLE_INITIAL varchar(20),

...

As the main question asked is if there is a way to automatically blow off into oblivion queries running over n minutes:

I have to agree that is not the way...

You could add a identity column to the table, IDENTITY(1,1). This can be your guide for doing the updates in the table one batch at a time.

Borrowing on Jeff's...

The first principle of ISO-11179 and all data element names is that you name a thing for what it is by its nature, not how or where it is used...

Eric M Russell (2/9/2015)

---

Jeff Moden (2/9/2015)

---

Eric M Russell (2/9/2015)

---

axc_67 (2/9/2015)

---

No I am not joining any tables in the remote server.

I am just pulling a simple data extraction from remote server...

I for one like the yyyy-mm-dd notation. In other countries a '20140711' could be interpreted as Nov 07, 2014. If you changed the default language setting on your machine then...

CELKO (2/12/2015)

---

...

Luis Cazares (2/12/2015)

---

sonchoix (2/12/2015)

---

dwain.c (2/11/2015)

---

In the TOP 2 or 3 or 4 you are listing (outside of the Others group), what do you want to do if there are ties?

This...

Running the command

EXEC DBCC FreeProcCache

and witnessing the expected performance makes your case for parameter sniffing.