Ugh, I am missing so much and not catching on! Sorry about the homework question, I should have originally read your whole post. I'm a bit busy today :-)...

I'm confused... Why didn't your original query work? I just tested your original query in AdventureWorks and got the required results....

Put foot in mouth here... Next time I'll read your whole post before asking about homework... Sorry Amy.

Lynn Pettis (8/15/2012)

---

SQLKnowItAll (8/15/2012)

---

Not...

Not to beat a...

Matt Miller (#4) (8/15/2012)

---

Lynn Pettis (8/14/2012)

---

rVadim (8/14/2012)

---

I think Jared is right. The whole thing boils down to incorrect formation of @Subnet parameter. That is why asked what is in it....

Are you sure? How are you checking this?

Jeff Moden (8/14/2012)

---

SQLKnowItAll (8/14/2012)

---

The actual execution plans are exactly the same for each and IO is the same. Interestingly enough... Every time I run this, the third one performs...

Is the database on ServerA trusted?

Sapen (8/14/2012)

---

Hi All,

I am trying to set identity off over a linked server on a table. Both the servers are SQL Servers. The login is a domain admin account and...

Lynn Pettis (8/14/2012)

---

mhambleton (8/14/2012)

---

Hi,

I'm working a project where I need to be able to create a text file from a SQL Query. I use the BCP function but continue to...

Carlaabanes (8/13/2012)

---

i would suggest using Redgate's SQL Compare, its a great tool especially for this scenario where you need to run a batch of alter scripts. If you dont have...

sqlharmony (8/14/2012)

---

Log shipping is the real thing here that is killing your idea as others have mentioned you will not be able to report against the databases while the transactions...

I think we are missing a key aspect of what the OP is asking. This is closer to an SSRS question, I believe. There are 2 datasets in...

Ness (8/14/2012)

---

Hi,

I am in the need for an alternative to cdc as I am using SQL 2008 Standard Edition. I know that I can use triggers (the seemly universally...