Heh... best way to prevent recompiles in 2k5... is to... use 2k :hehe:

This kind of "trick" is to make forming GUI code (inherently dynamic) easier. It's a trick to try to make the GUI table driven so someone doesn't have to...

If you want to stay out of trouble even longer, don't declare...

I think I see a dual triangular join between Deleted and Inserted and that might give you a funky rowcount... but I don't see anything in that code that would...

Heh... that's what happens when you store dates or times as formatted data. These should be stored just as a DateTime data type and formatted for display only. ...

Nah... Don't feel dense... Like I said above, Barry simply forgot to...

suhas.kanade (6/26/2008)

---

We have to write a stored procedure in SQL 2000 in which we need to create dynamically 3-5 tables depending on parameters. But in that we are facing a...

Karthik,

Try to select from the temp table the code just made...

What did you find out when you Googled or Yahoo'd the word?

No... was meant to...

You don't need to do that... that problem was solved way back in 6.5.

Two way street here... how did you resolve it?

Along with what Gail said...

... find and rewrite all RBAR to be good set based code. Learn how to use tricks of the trade like a Tally table. ...

Why on Earth are you still using the TEXT datatype on 2k5? Convert the text to VARCHAR(MAX) and you're done.

So... why did you post in the 2005 forum or at least let us know in the beginning that you were using 2000?

About the only way to do this in...