There are a few methods - none of which is that straightforward, but do the job. I've used one method as an example below

Once you've got your 1 column table to SQL, you can try a variation of this kind of thing (just try running it and you should get the idea

Hi all,

I started playing with the PARSENAME way of doing this (for fun, and taking into consideration what's been mentioned), and got a bit carried away.

I'm not certain it...

This kind of thing has been discussed many times before on here. Here's one simple way (as an example)...

CREATE TABLE #T1 (name SYSNAME, par INT IDENTITY(1, 1))

INSERT INTO #T1...

Unless there's more to the problem than you've described, I'd solve it using VBA, rather than T-SQL (in which case this is the wrong forum, so apologies).

Something along the lines...

Just working on that now...

This does the trick:

--This code is safe to run

DECLARE @animals TABLE (ListOfAnimals VARCHAR(100))

INSERT INTO @animals

 SELECT 'cat, dog, mouse'        UNION ALL

 SELECT ' mouse,dog,...

Galahad,

Ray's right that you need to post more information about your problem. How do you know, for example, that rows 1, 3 and 5 (or 2, 4 and 6) in your...

I see paramind - that's what you're thinking. In that case, I guess changing...

INNER JOIN (SELECT s1.Orderref, SUM(ISNULL(s2.Quantity,0)) AS [Summ]

...to...

INNER JOIN (SELECT s1.Orderref, SUM(ISNULL(s2.Quantity,0)-ISNULL(s2.[Scheduled Amount],0)) AS [Summ]

...might do...

Well, I prefer David's method. A little tweak to seems (to me) to meet all the requirements (including the priority one)...

SET @Material = 'MATERIAL1'

SET @Qty = 350

UPDATE a

SET a.[Scheduled Amount] =...

I think the '<=' should be a '>=', but Sergiy's solution is a good one.