Viewing 15 posts - 1 through 15 (of 618 total)
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...
April 23, 2024 at 11:52 pm
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
April 22, 2024 at 7:04 pm
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...
April 22, 2024 at 3:00 pm
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...
April 20, 2024 at 11:32 pm
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.
April 20, 2024 at 9:40 pm
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...
April 19, 2024 at 6:06 pm
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.
April 17, 2024 at 10:44 pm
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...
March 6, 2024 at 2:40 pm
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...
March 5, 2024 at 2:39 pm
Yes -- Is it Unix epoch milliseconds? Convert-DATETIME
March 4, 2024 at 7:28 pm
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...
March 4, 2024 at 3:20 pm
Viewing 15 posts - 1 through 15 (of 618 total)