This sounds...

drew.allen (10/17/2016)

---

hegdesuchi (10/15/2016)

---

Hi ,

Thank you!yes I agree with you! My client wants to check if columns are same .update only if they are not same. I could think only of...

The only index in your sample table was on the identity field, which is not an appropriate index for this approach. You need to create an index like below.

CREATE INDEX...

I did say that it required that the appropriate index be in...

hegdesuchi (10/15/2016)

---

Hi ,

Thank you!yes I agree with you! My client wants to check if columns are same .update only if they are not same. I could think only of this...

There are two issues with all of the solutions provided so far. They all read the exchangerates table twice: once to get the exchange rate and once to get...

It's because you didn't...

Why did you abandon the XML approach? It performs better than manipulating the strings.

I did notice that the sample XML data you provided does not match the case of...

Y.B. (10/13/2016)

---

I believe this gets you what you are looking for...

SELECT

s1.LocID,

s1.Name1 as s1Name1,

s1.Name2 as s1Name2,

s2.Name1 as s2Name1,

s2.Name2 as s2Name2

FROM #Server1 s1

JOIN #Server2 s2 ON s2.LocID =...

Again, your WHERE clause is converting your OUTER JOIN to an INNER JOIN. You want to find record where the value is MISSING. Use the following.

SELECT DISTINCT

CourseInfo.CourseStateCode ,

CourseInfo.CourseTeacherID...

Since English is a left-to-right language, you will almost exclusively see people using LEFT outer joins.

A RIGHT outer join says include all records from the RIGHT table (Responsibilities) regardless of...

The standard workaround is to create a view that uses RAND() and/or NEWID() and then select from the view in the UDF.

And the reason they can't be used is that...

dianerstein 8713 (10/12/2016)

---

I am trying to load the valid lockID values into the cust table with the following sql:

DECLARE @Startlockid INT=0

DECLARE @MyTableVar table( lockID int);

insert...

river1 (10/12/2016)

---

Dear All, for quite some time I have a performance degradation in my DB server.

I have a total of 128 GB of memory on it and SQL Server configured...

Also, if you just disable and reenable the foreign key constraint, that constraint will no longer be trusted, which, again, defeats the purpose of having the constraint in the first...