Stop trying to copy and paste millions of rows out of management studio.

WITH MainAddr AS (

SELECT Eid, Addresscode, Address, ROW_NUMBER() OVER(PARTITION BY Eid ORDER BY AddressCode ASC) AS ROW_NUM FROM EmpAddress WHERE AddressType = 'Main'),

SecAddr AS(

SELECT Eid, Addresscode, Address, ROW_NUMBER() OVER(PARTITION BY...

arnipetursson (11/24/2014)

---

Brandie Tarvin (11/21/2014)

---

Yikes! What kind of application spawns its own databases? And...

It sounds like you're asking for something involving a date dimension, maybe start looking at that.

g.britton (11/21/2014)

---

good point, though the...

g.britton (11/21/2014)

---

ZZartin (11/21/2014)

---

Sean Lange (11/21/2014)

---

Under the hood a cursor is a just a while...

Sean Lange (11/21/2014)

---

Under the hood a cursor is a just a while loop on...

Just out of curiousity but how do you use a cursor without using a while loop?

Markus (11/21/2014)

---

The query tool that our developers use do not allow for the use of Windows accounts to query, only SQL Server authenticated IDs.

I guess I fail to see...

There's a difference between a service account login used by an application to connect, which a dba should know as the dba is likely the one who will need to...

SELECT CONVERT(datetime, CASE WHEN LEFT('1100323', 1) = '1' THEN '20' ELSE '19' END + RIGHT('1100323', 6), 112)

http://msdn.microsoft.com/en-us/library/ms187928.aspx

I imagine potentially you could get race condition issues, that code chunk looks pretty small but you could potentially have someone disable xp_cmdshell right after someone else enables it but...

Well do you expect the database to grow in size again?

You're fighting about 15MB of space?

Assuming size and performance allow you can just grab all the records in table B pull them into a temp table on server A, do your comparison insert there then...