Jeff,

How would data being in csv be handled differently?

Thanks.

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 of records

Thanks Brian for all of your replies. and suggestions can you look at this code and tell me if this would handle processing the table with a batchsize of 50,000...

The table will be cleared out before this new process runs, but I do need to process by ID..

Could it multi process the table?

Thanks

Thanks for replies and alarms of this type of approach -- defiantly something that has been discussed.

With the approach above how it will scale when removing the where ID =1...

DECLARE @Counter INT = 1;
DECLARE @MaxCount INT = 1; -- Set this to the number of times you want to run the insert
DECLARE @SQLString NVARCHAR(MAX);
DECLARE @ParmDefinition NVARCHAR(MAX);

WHILE...

I must have something wrong as it's error'ing

This is what a single sqlToExec where ID=1  looks like

delete from cstSums WHERE PartNbr='81K000000' AND PlantCd='CORP' AND CostKey='Standard'

Thanks for reply.

I tried this but it didn't delete record

DECLARE @Counter INT = 1;
DECLARE @MaxCount INT = 1; -- Set this to the number of times you want to...

The query that feeds this table is very specific (Only Insert) in what gets added to the sqltoexec can it be done without using a cursor?

Thanks for your reply.

Perfect.. Thanks.

I came up with this, but not sure how to get 1 hour time frames from the data. I want to see how many times in an hour for a...

Looks like if I add this in my query logic I'm getting the datetime desired

DATEADD(s,t_stamp/1000,'1969-12-31 20:00:00')

2024-02-01 01:00:00.000

2024-02-01 01:00:01.000

Struggle with doing the count of records per TagID within the hour that...

I would like just a query.

Yes -- Is it Unix epoch milliseconds?    Convert-DATETIME

A report that shows timespan of the analysis and then total for the TagID then Unique and Nonunique(differnt value)

There where 800 captures and 750 all had same value and, in...