If they send the CSV data in a file, then the data could be imported using BULK INSERT.  This would be...

thanks The sqltoexec are passed in sql statements like:

INSERT INTO cstDetails (CompPartNbr,PartNbr,PlantCd,CostKey,usgQty,scrQty,totQty,UnitCost,usgCost,scrCost,totCost,StrJCost,StrMCost,SetUpQty,SetUpCost,CurrentOPRSetup) VALUES('967120411','864A90D40','CORP','Standard',0.2697,0.0043152,0.2740152,6.5,1.75305,0.0280488,1.7810988,0,0,0,0,0)

The CrtInsert table has a PK field called ID(int)

In the example how do I loop thru thousands...

I take your point though I  think you are mistaking refactoring...

As a bit of a sidebar, it's always fascinating to me to watch how people do...

Heh... sounds like you already...

Overall, what are you actually trying to do?  Bulk insert from files to the database or???

I can't speak for  the cloud but I'm backing up a 4.7 TB database over NAS on-prem in 1 hour and 13 minutes.  It's a single file backup but the...

Take a look at Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets & Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations from...

Yes. It's known as "Linear Regression Analysis".  I'm giving...

Heh... now that's interesting.  And, I just noticed... this is for...

I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple...

• This reply was modified 1 year, 6 months ago by Jeff Moden.

I implemented a similar solution at work, logging the disk free space (along with database free space) to a table along with when it was recorded. Simple SSRS report...

This is very likely a case where the use of a statement level OPTION (RECOMPILE) will work perfectly and very quickly.

Heh... you, of all people, should know about "double posting".

Folks, no answers here, please.  Instead, go to the duplicate post and post there.  Thanks.

https://www.sqlservercentral.com/forums/topic/do-i-need-a-recursive-query-for-this-bill-of-materials-sort-of

I'd have to see more but I'd start with the idea that the "Starter" is actually a "Product" and that product becomes an "Ingredient" as if you bought it from...