Most certainly it is possible. Especially if you are basing your view directly on one physical table.

I'd stear clear of joining a local table with a remote table using 4 part naming convention. This type of cross-instance joining is not efficient for a number of reasons,...

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)

---

...