i have asked the question,assume both tables are a heap,how would you update the table in batches of 5000

can this script be re written for it to return the values as a bit datat type?

Thanks but i want the stored procedure to reture a single column 'GetExtractSiteExtractFileBatchPreviousSuccessInd' with the value, your script would only return the result as the return value

i tried it still returns no value

Thanks i will give it a try and let you know the results

thank you,i appreciate all your help

thank you, but i don't want to restrict the results to one business unit, i want to include all business units

that's a great example, thanks, i wanted to add that the the select statement is for just one business_unit and one parent_item_no, there are multiple business_units and parent_item_no's, so based...

yes, i have but i but i can't seem to write the anchor statement properly

worked like a charm,it was just some syntax errors, can you explain what is the severity message and no , thanks so much

i tried it and it didnt work, any more ideas

Thank you, i will try that and let you know if it works. thanks

i think this will work just fine thank you so much

thanks for all the input i really appreciate it

thank you so much your code really helped