It's a pretty standard lookup table design:

LookupTable

LookupID Year Desc

1 1999 'Some important value'

2 ...

Oh no!

Mr. Bill!

jcrawf02 (12/12/2008)

---

lol y'all are nuts. I haven't checked in on this thread for a while, last time it was actually related (more or less) to the title, now I come...

Thinking about it some more... how do you write a procedure...

Well, I assume that you know what you want to get, what data set you're looking for, first. Armed with...

If I understand the question, I guess it's something I do every day (all day sometimes). First, I need to have a set of working parameters. Preferably, I have some...

You have a single transaction where you are mixing INSERT/UPDATE and SELECT? Be very careful that you're performing these actions in the same order or you'll be getting deadlocks all...

Don't use transactions on the read statement. There's no need for them anyway.

The statement you have there is an extended property. It doesn't create functions. Instead it is used to document and describe objects already created within the database. You can lookup...

You can check the @@rowcount to verify how many, if any, records were deleted. Or you can use the OUTPUT clause to capture specifically which records were deleted.

As Jack explained to you, without some specifics, there's almost no way to address your issue.

Speaking in general terms, using a cursor to select records is almost always a mistake....

I'm actually not entirely sure what you're asking. Do you mean something like: Always join on the key, the whole key. Or are you looking for tricks with XML execution...

jeffrey_bryant (12/11/2008)

---

Great thanks for the info. This really confirms what I had thought. Just wanted to make sure there wasn't a major gotcha someplace on this issue.

Unfortunately the Dev...

Got me beat. I've only been driving for 31 years. I've got the scars from the one major accident on the bike.

And even as you hit the limitations on a single table inside a single database on a single server, you can start to look at partitioning and parallel processing using...

It depends.

Is there going to be a lookup value:

08 A

As well as the value:

07 A

If so, then the year should probably be part of the PK of the lookup table...