I think Merge is really close to what I want, i'm doing some reading on it myself. The only thing I see is that I could have multiple alternates...

In the example if the updates and inserts were done then i pulled the query

Select PartNumber, Location, Quantity from InventoryThatNeedsReorders Where ((Quantity-ReorderPoint)>=1)

I would not expect it to show:

Widget 123, GrandRapids,...

I would expect for it to find in current inventory 2 alternates and then find a qty in stock of those 2 alternates. Then it will update the reorder...

Ok here is I believe what your asking for, this a simple version of the data.

Create Table InventoryThatNeedsReorders

(PartNumber nvarchar(50),

Location nvarchar(50),

Quantity int,

ReorderPoint int)

INSERT INTO InventoryThatNeedsReorders

...

Setting the reorder point can either be to 0 or to 1 it depends on the results. I'm not quite sure I understand if i can pull this off...

here is an example of what i need to be able to do:

Select partnumber, qty, reorder, location from inventorytable

I need to pull the partnumber out of this table then look...

Sorry i'm not trying to have you guys do everything for me. I have never really don't a procedure before and i'm not sure if i can accomplish what...

Also I have other insert statements that use the information from the first sql statement, how would i pull that data to put it into an insert?

Ya i'm actually an asp programmer. What i'm trying to do is go from using an asp page to run this set to try to do it in SQL...

SELECT PartLocation, PartNumber, CurrentReorderAmount, AmounttoReorder, CurrentInventory, AmountInDistributionCenter

FROM InventoryTable

where (COALESCE (AmountInDistributionCenter, 0)>0)

If Not SQL End of File then

If AmountInDistributionCenter>0 Then

...

oops thanks

currently we are using SQL 2000, where would i find sys.dm_exec_query_stats.

Thanks that is very helpful, I am actually composing a list right now of somethings, like how to restore from transaction logs and how to automatically start sql server agent...

Thanks for the help, I do have some experience with T-SQL, currently I design pages for my companies intranet and we use SQL 2000 and ASP to do it. ...

Wow thank you that is exactly what I am looking for. Thanks to everyone for there help, this website is a valuable asset to a rookie like me. ...