update question 1

[jcisco2]

I'm creating a temp table to hold various data from multiple tables. and I'm having a problem with one statement (see code section) in the v_PlannedProduction table it can hold the same item number twice with more than one start date. All i need to do is get the first instance of the start date for my temp table.

update temp_Cuts set ProductRunDate = (SELECT  StartDate, ItemNumber
FROM         v_PlannedProduction
where temp_Cuts.ItemNumber = v_PlannedProduction.ItemNumber
GROUP BY  ItemNumber, StartDate
)

cheers

 

[bborissov]

When you update field from derived table you must return ONLY one field in it:

update temp_Cuts set ProductRunDate = 
                     (SELECT  MIN(StartDate)
                              FROM v_PlannedProduction
                              where v_PlannedProduction.ItemNumber = temp_Cuts.ItemNumber)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP