It has been that way as long as I can remember (version 2.0, late 80's). I created a code snippet to rename tables by stripping the first few characters off...

So you just shut down the service and restarted it and everything went back to being fine? Do you have any idea what caused it to start with? Has it...

Goodness, nested loops eleven deep, possibly three or four unioned tables with conditional computed scalars and distinct three column sorts in the middle, conditional elimination of nulls, throw in a...

That is actually quite cool. I have a couple uses for it myself....

I'm still interested in knowing if it can be done with a table variable though....I'll look into it...

Input. Need more Input.....

And of course, Have you looked into permissions?

I've only ever used two methods to perform this, and as far as I know (look out), they are the only ways without using an identity field. The first is...

Just as important, Have you determined what corrupted your database like that so that you can prevent it from happening again?

After all, According to the instructors I've attended class with...

Your absolutly correct, Antares686, MSDTC must be running to work with Linked server tables.

I would also check for a unique identifier on the table involved, and verify there are no...

Cool.

Create your table with the SortOrder field as an Identity field, and just leave it out of your insert statement altogether.

And of course, the Temp table suggestion works if you...

Here's the character mapping chart, and of course, I'll send it to the E-mail as well.

Here's the process:

Step 1. Convert the Comp-3 (packed decimal) to a decimal integer zoned format...

I was under the impression you needed translation for data types, not conversion routines. That's a whole different animal altogether. Converting values is no problem. Mapping field definitions was what...

That will do it....

Rather than using a trigger on the work table, could you simply have a scheduled job, running every minute or whatever, check for a record in the work table and...

What is it your wanting to find out about? Things like that are simply checks against defined "abnormal Behavior" or exceptions to defined "normal behavior".

As an example, Were it to...