Just a quick note I found on Books Online :

https://msdn.microsoft.com/en-us/library/ms177570.aspx

Have a look at the bottom section named restrictions. I see a mention of replication, might this apply to your...

Part of the answer to this question is how many tables and /or columns to existing tables you think could be added? You multiply the size per one row times...

Eirikur Eiriksson (4/6/2015)

---

koti.raavi (4/5/2015)

---

Hi Everyone,

Please see below query

Select ID, ID1,Name, Cname from Customer where ID =(@IDSearch) or ID1 =(@Idsearch)

When i run above query took around 3...

I have also heard the terms 'ansi' and 'ascii' used interchangeably. If that is what you mean then the simple answer is that unicode text starts with a "N" in...

I hope I am understanding your question. Combine the results of the sql provided above with the information presented here :

https://msdn.microsoft.com/en-us/library/bb177899%28v=office.12%29.aspx

I would recommend to use the registry to store a password though the configuration manager. It's a good practice so that the text is not exposed in a file or...

Enjoy_SQL (3/20/2015)

---

If a trigger fires, it works assuming people enter the data each week in order ... if they go back and edit a previous week, it breaks the integrity...

Enjoy_SQL (3/16/2015)

---

Below is the source table, the view, and the trigger on the source table.

What I am finding out now (and someone mentioned before with caution :)) is that any...

Thanks for posting back. Glad to know this worked out and we were able to help.

The link posted by Sean explains the conditions under which a view is update-able. If the latest DDL you posted is any indication, you are working with one base table....

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...