Nice one. Never seen CTE's before so will have a read up.

Thanks.

Yes that fixed it. Many thanks.

Where can I read up on the effects of taking the -R off.

How do I change the regional settings in my SQL Server i.e. remove...

I don't want to sound ungrateful for your help but if you look at my post you will see that I am using @@ERROR. My problem is that when I...

This indeed would be a solution if I was using 2005!

Ooops I'm so used to posting into this forum I forgot that I was having a problem with 2000 :blush:

The issue is that I am updating a table and if...

OK now I've worked it out.

CREATE TABLE [dbo].[FHInvoiceDetail](

[delivery_note_number] [char](10) NOT NULL,

[line_number] [char](4) NOT NULL,

[suppliers_product] [char](20) NOT NULL,

[product_description] [char](40) NULL,

[pack_size] [char](10) NULL,

[quantity_invoiced] [float] NULL,

[unit_value_ex_vat] [float] NULL,

[line_value_ex_vat] [float] NULL,

[vat_code] [varchar](1) NULL,

[vat_rate] [float] NULL)

If I change

[unit_value_ex_vat] [float]...

Resolved by following Method 3 in article http://support.microsoft.com/kb/918760

Still don't know why my first Package works and the second doesn't. They were both created by the same userid!

I want to write to a log file or the SQL Agent history from within my stored procedure. If I had a simple SSIS package that executes an SQL task...

Took about 1 minute to run. On SQL 2k 12gig memory 8gig assigned to SQL, 8 processors. ProductID was index on SalesProducts. I had 944 unique products.

Now that I have...

Guys, many many thanks for your help and guidance. I had realised I had only used one product ... I was showing you what I needed to do individually for...

I've done this and got the right answer. It basically takes the last record from each query. So the max of price ascending is my min price and the min...

I've run Chris' code and yes it runs real fast. Problem is that I have 944 unique product codes in the 1.5m records at the start but when I run...

I put 1.5m rows into a table and then ran your query. I then stopped the query before it crashed the server.

I then took a different tac. I deleted from...

I think this example is returning the min and max price across all products from the Products table. I want the min max for each product but I also want...