You're welcome! And thanks for the accolades.

kajalchatterjee (4/9/2010)

---

Comparing Table Variables with Temporary Tables

I ran the following piece of code in SQL-Server 2005 and i can not see any entry of table variable in tempdb database. I...

matt32 (4/9/2010)

---

Thx Wayne for the link to Paul Randall.

@paul-2

I had this issue some month ago with a customers 2005 db.

heavy data load using a SP with select .. into #temp....

Matthias, I've never seen this before. Very interesting.

If you're interested, I just found a way to work around this.

select top 1

CONVERT(int, 1) as nr,

name as colname into #tmptable

from sys.all_columns

Has anyone ever heard of this before?

I tried to duplicate it...

No changes at all....

Luke L (4/9/2010)

---

jcrawf02 (4/9/2010)

---

I need some inspiration, what do you guys do when you start to lose focus and don't have the time to go get the crap kicked out...

matt32 (4/9/2010)

---

Hi Wayne ,

great article and here some problems i encountered while working with

#temp for further articles with the same focus.

1. Creating a #temptable within a SP as select...

Thanks

:blush: Thanks again!

Gianluca Sartori (4/9/2010)

---

Thanks for clarifying Wayne. So, it works the same as permanent tables: I was fearing that a different behaviour could apply.

I wrote that because I use indexes on...

I agree. Good job.

Keep in mind the difference between RANK() and DENSE_RANK() if it is possible to have a tie.

Nuts, do...

sku370870 (4/9/2010)

---

In the first situation my Where clause would be ...

Where Postcode1ID = @Postcode1ID and Postcode2ID = @Postcode2ID

In the second situation my Where clause would be ..

Where (Postcode1ID = @Postcode1ID...

Gianluca Sartori (4/9/2010)

---

Outstanding article, Wayne. I must have missed it when it was first published. Nice job.

Your article raised a doubt in my mind. You write

Temporary tables can have named...

http://www.lmgtfy.com/?q=charindex+sql+server+2005

I think I have a good idea of what you want, and I think that the RANK() function will do what you want, but there are several questions remaining. If...