NP... already done that error, and when left unnoticed it can cause some serious problems .

The missing values (aka holes) in the list do NOT get re-used automatically unless you take care of re-sequencing by using a script.

Also this is something that is...

You'd have to code something to make that happen. Why do you need to have it in a single statement?

I think you bring valid points... If you are unable to solve the other problems then this would be a viable alternative.

But since this post is very old, I'd suggest...

On another side note... Is there any other job or proc that is ran at the same time that this job is run? If any script is ran that...

Well you can always scroll to see the rest of the data (if there's any). Also I'd strongly suggest you use Query analyser to make changes as they are...

Min or Max could be used here. This is all depending on the business rules in this case. You might have to actually delete all the duplicates to...

Because that's not the way it works. All that'll do is return the string 'ProcessWhatever'

You want it to return the actual translation for EACH line. So you need...

dbo.MyFunction (@RequestedLangage)

Also you need to pass the other 3 columns. That way the FUNCTION will pick the right column to present and return it to the caller. That...

Precisely... just have a look at BOLS for the exact syntax or if you need more help.

CASE @RequestedLangage WHEN 'Eng' THEN Processes

WHEN 'Chi' THEN ProcessesChina

WHEN 'Ger' THEN ProcessesGerman

END AS Processes

You could also put that code into a function so that you could reuse it in all...

Not that I can think off ATM, but that should be plenty since you have a lot of nvarchar columns in that table.

You can use the syscolumns table to see...

Just a little pointer. When you write a count(distinct(whatever)), the distinct operation will be done by running another query. You can look at that query using the plan from...

If you're lucky and a programmer has made a opy of the db somewhere else on the server then yes some data can be retrieved. Otherwise you're screwed.

Check in the books online for the fetch command. If you didn't use it, then you're still on that record. I can't help you more than that without...