patrickmcginnis59 10839 (4/23/2013)

---

what you could do is see if the employee table ALSO has some other column you could use to further select down which row from table division you...

This will probably get you what you want.

select EmpID,

LName,

FName,

StationID,

Region

from

(

SELECT

a.EmpID,

a.LName,

a.FName,

a.StationID,

b.Region,

ROW_NUMBER() over(partition by a.EmpID order by a.EmpID) as RowNum

FROM emp.employees a

JOIN emp.division b

ON a.StationID=b.StationID

) x

where x.RowNum = 1

I think you are asking where do you run the MERGE???

EXEC('Your Entire MERGE Statement goes here') at LinkServer

You're welcome. Glad I was able to get you close enough to figure out the last couple steps.

autoexcrement (4/23/2013)

---

Thanks for the continued replies!

This database is hosted at a web hosting company on SQL 2K5. Maybe their box doesn't have all the necessary hotfixes installed or something,...

autoexcrement (4/23/2013)

---

Thanks for the continued replies!

This database is hosted at a web hosting company on SQL 2K5. Maybe their box doesn't have all the necessary hotfixes installed or something,...

prakashr.r7 (4/23/2013)

---

Sean Lange (4/23/2013)

---

prakashr.r7 (4/23/2013)

---

Sean Lange (4/23/2013)

---

What is the point of NamePhone? Your table PhoneName is properly normalized and the second table is not. I would drop NamePhone and use...

Can it be as simple as MAX(WhateverTheNewColumnIS)?

The problem is that is nearly impossible to provide much assistance because we can't see what you see and we don't know your data...

prakashr.r7 (4/23/2013)

---

Sean, I just...

maxlezious (4/23/2013)

---

Thank you sean that fixed my problem and this is just a report I am making for a client which will be viewed in a word document so I...

Here are a couple others.

http://www.sqlservercentral.com/articles/Stairway+Series/The+Relational+model+and+Normalization./74134/%5B/url%5D

http://www.sqlservercentral.com/articles/Normalization/74241/%5B/url%5D

http://www.sqlservercentral.com/articles/74381/%5B/url%5D

http://www.sqlservercentral.com/articles/Normalization/74437/%5B/url%5D

You really should leave formatting to the front end. All formatting does on the sql side of things is slow it down and make it more difficult to work with....

What is the point of NamePhone? Your table PhoneName is properly normalized and the second table is not. I would drop NamePhone and use PhoneName.

duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1445358-1550-1.aspx

Interview question?