It's traditional, when people have gone to the trouble to help you, to post the solution you ended up with. This will also...

branovuk (10/5/2011)

---

I must ask one more question:

How to use CASE statement (or similar, maybe if?),

because it is not just Update, it is based on data from table2 another values in...

Marin

A self join is the way to go - on r1.ID = r2.ID-1. Show us what you've tried, and we'll show you where you're going wrong.

John

Raymond

When I've needed to do stuff like this, I've used SSIS. The control flow allows you to handle the restore and all the associated tasks such as getting the...

Yes.

John

A good overview of the INFORMATION_SCHEMA views, Tom, and I, like Eric, also use them where possible. For the situation you mentioned with the routine definition spanning two rows,...

This is something that's best done in the presentation layer. I don't know any way of doing it in the database layer without using some horrible dynamic SQL.

John

And is it working now? If not, you say you can open it in BIDS and run it. Have you tried saving it and running the newly saved...

Taggs

The command you posted earlier doesn't include the full path to the executable. That was my point. If you don't specify the path, then it'll use the first...

What may be happening is that the job system is running the wrong version of DTExec.exe. I take it your job step uses the SQL Server Integration Services Package...

I would start with this. Sounds like you're inadvertently trying to run a...

Please will you show expected results for your sample data. It's not clear whether you're looking for the highest high or the highest high for each individual index code.

Thanks

John

Steve

Please will you be a bit more specific. Error messages? Unexpected results?

Thanks

John

Try what I suggested and UNION it with the rows with NULL in ColC. Still waiting for the DDL and sample data so that we can visualise and test...

It's difficult to work out what you require from your description, but it sounds like you just need to add WHERE particular_column IS NOT NULL to the end of your...