No, that's probably not a great way to go about it. Instead have a many-to-many join table between the two other tables. So you'll have a ChangeRequest table and a...

I see a loop and I want to eliminate it, if possible. But you're right, of course.

I still think partitioning the data would be a better approach rather than having...

Will they still compile? Leave 'em there. If not, clean 'em out.

Jeff Moden (2/26/2009)

---

Absolutely spot on. And, I'm also amazed that companies don't do a full background check on their DBA's. At the very least, I'd prefer to have...

What? You don't know about Type II? You been living in a cave?

There's a heck of lot here to chew on, but the first thing that jumped out at me was the this little bit of RBAR (row-by-agonizing-row) processing:

while @RevStateyr < '1991'

Begin

...

I'd have to do some experimentation with it to be sure, but according to BOL you can get the DMV sys.dm_exec_query_requests has the sql_handle and statement_start_offset combined with statement_end_offset that...

I just got directly to the page by googling '"Are the posted questions getting worse" karate'.

Apparently I was quoting Captain Queeg. It must have been right after a Cub...

Since I'm using SQLPrompt Pro, I can force the formatting however I want. I just saw that Apress has a formatting tool that's free. It might be worth a look-see.

I can't say I'm crazy about it, but all the cool kids are doing it, so I do to.

Since there are so many hard core SF readers on here, I thought I'd pass on what I just heard. Phlip Jose Farmer has died. http://reason.com/blog/show/131886.html

I read tons and tons...

You can set a database to be read_only and you can set a file group to be read_only. I don't think you do that with a table. If it's the...

Oh, you mean something that captures the execution context, that'll show the methods used to call the proc like EXEC blah, blah and include the parameter names & values?

In 2008...

Heck. I thought LISP was stacks of comma's. What am I thinking of then. I worked with some damned language back in '92 or '93 where the code looked like:

exec...

I'm sorry, I don't understand the question.

When you create a procedure, you define parameters with a certain name and a certain data type, nullability and default values. Within the procedure...