Actually, this looks right and makes sense as TVF are used like tables and views. Not something I had really considered.

Duplicate post, I'm just not looking for the other one...

GilaMonster (3/31/2010)

---

WayneS (3/31/2010)

---

Makes me wonder what he thinks the...

vidya_pande (3/31/2010)

---

thanks Lynn.

no, its not any implementation requirement. its just learning point of view. I always come acorss this question when talking to oracle DBA's regading migration to SQL Server.

Oracle...

Awesome, but unfortunately we don't have access to 2008 R2.

Definately good to know this.

That could be taken several ways ... 😛

Scared him off I think we did...

I have to concur. If you are using any SQL Server 2005 specific features, like CTE's or the windowing funtions (ROW_NUMBER(), RANK(), etc), DDL triggers, and there are other...

Not up on peer to peer replication, so can't provide you anything more than you could learn by starting with Books Online. There may be others here that could...

Okay, I think this one is getting way off topic, if we aren't careful we could have the grandson of the thread soon.

CirquedeSQLeil (3/31/2010)

---

Lynn Pettis (3/31/2010)

---

CirquedeSQLeil (3/31/2010)

---

Jeff Moden (3/31/2010)

---

Grant Fritchey (3/31/2010)

---

dma-669038 (3/31/2010)

---

Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know...

Alvin Ramard (3/31/2010)

---

Lynn Pettis (3/31/2010)

---

Grant Fritchey (3/31/2010)

---

dma-669038 (3/31/2010)

---

Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference...

CirquedeSQLeil (3/31/2010)

---

Jeff Moden (3/31/2010)

---

Grant Fritchey (3/31/2010)

---

dma-669038 (3/31/2010)

---

Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between...

Grant Fritchey (3/31/2010)

---

dma-669038 (3/31/2010)

---

Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between table scan and...

Not going to come right out and say this can't be done, even though that was my original thought, but I will say that it most likely isn't something many...