The real users will show up at your desk in a panic... have the porkchops ready... 😀

Folks, just to be clear, you might be able to create a permanent view on the fly and drop it at the end of the proc, but there is no...

John Mitchell (3/13/2008)

---

Jeff Moden (3/13/2008)

---

No... no way to create a temp view. Creating a TempTable to hold what the TempView would have contained is the next best thing and...

That would also make it easier to find... dummy that did it would scream out loud 😀

... or, you can just use the power of UNION...

SELECT customer1

from yourtable

where customer1 like 'sm%' UNION

SELECT customer2

from yourtable

where customer2 like 'sm%' UNION

SELECT customer3

from yourtable

where customer3 like 'sm%'

Real key...

I've found...

Matt Miller (3/12/2008)

---

Jeff Moden (3/10/2008)

---

Giving away a fine "secret" here, but no one's ever heard of temporary stored procedures? Build it using dynamic SQL... execute it... it's all in...

Yes... same problem as with Global Temp Tables... if same job runs more than once, BOOM on table creation or YECH on what happens to the data because more than...

Do a Google search for sp_MSForEachTable...

Agreed... and test data...

I have sp2 installed and I noticed the same thing an a good number of queries that end up using a loop join...

I've never trusted % if batch, anyway......

Wouldn't OUTPUT return the same data type as whatever column or variable appeared in the stored procedure?

While it's true that there is some trickery you can perform to "Tune the hardware" and "Tune the database" and you can throw indexes at tables to make some queries...

No... no way to create a temp view. Creating a TempTable to hold what the TempView would have contained is the next best thing and pretty darned fast to...

Heh... LOL. I guess using TOP to overcome a double triangular join will do. 😀 I'll add it to my list of paging methods to test for...