oooo. Nothing like a little sabotage to escalate the wars.

I hope this thread sees some action, because this is interesting. I'm one of those half wit developers who is really...

Thanks

Thanks. I guess making it easy isn't on the hit list! (e.g. why would it not just say, SP3? Duh.)

It's true that it's not necessary to relink the tables each time, but it in practice, it might be a good idea because there's only 10 of them and that's...

Point taken. And clearly, I didn't know the answer.

I thought the question was:

What T-SQL construct will help you with this?

So I went to the forum and asked why my idea...

Ouch. Sorry, if I offended.

I guess, but that ain't what they asked...

Musta misunderstood something... why wouldn't you do this:

BEGIN TRANSACTION

---T-SQL TO UPDATE PRICES

--IF statement to goto rollback if errors

COMMIT TRANSACTION

GOTO Statement to skip rollback

ERRORHANDLER:

ROLLBACK code

--Now the transaction is finished, update the...

The CreateObject function reads the registry of the machine on which it is running to find the classid and file location of the dll of the specified class name.

So you...

It's amazing how rude and demanding people can be, even on a free web site.

We all have moments. If you must spout venom, and once in a while we all...

Lots of things are energy hogs, given the way we use them (instant on TVs and other appliances).

If it produces heat, and you're not using it for cooking or warmth,...

I'm fairly new to this, so forgive me, but if the whole idea is to stay set-based rather than iterative-based, isn't it obvious that there are only marginal improvments to...

Thanks, all. Trying out the suggestions and checking for index use. Funny how you can do something a hundred times then forget because you don't do it for months. Someone...

1. Unions bad, joins good
2. Keep the logic out of the programming. That lets the SQL server operate on a set basis. So I would never define a multi-purpose table (say where...

I'd suggest using different tables:

• There are more things making the data different than similar
• The number of tables, that is the kinds of insurance, is static. Once it is set up,...