I want to record the time it takes between button presses in asp.net.I need the answer in total secs and how do i do this?I know Now() gets current time.
View Complete Post
We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..
We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.
strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"
'get the new transaction_id out for just inserted alarm
strSqual = "select max(transaction_id) as transaction_id from trans"
set rst = getStaticRecordSet(strSqual)
Hello everyone, I would like to salute you before I beggin, being this my first post. The forum is great and it has been a big help during some work. Thanks a lot to every guru that takes the time to answer.
Ok, the situation is this:
A machine counts materials as they are being processed and store those records into a SQL Server like this:
DATETIME P_ID ARRAY_COUNT
2010-09-03 13:10:21.070 6
2010-09-03 13:15:02.013 6
2010-09-03 14:07:46.300 6
2010-09-03 14:09:47.053 6
2010-09-03 14:38:36.107 6
Everytime a material has been processed, a line is inserted into that table.
Now, lets say I would like to know when the machine has been idle for 5 minutes or more and store the resulting data into a new temporary table and show it to the user. That would also tell
I have a table that uses a trigger to save changes (old values) to a history table. This process is working fine, and I have reports that detail the history of a record for the end user.
My problem is that the end user now wants a report that will retrieve how the record looked at a specific date/time.
Id First Last Active Date
1 John Doe 1 10/25/2010
2 Jane Smith 1 10/25/2010
Id SourceId First Last Active Date
1 1 Jonathon NULL NULL 5/1/2000
2 2 NULL Gray NULL 10/1/2000
3 2 NULL Smith NULL 6/15/2003
4 2 NULL Doe NULL 11/23/2008
If the user queries for SourceId 2 on 1/1/2009, they need to get:
Id First Last Active
2 Jane Smith 1
I've used COALESCE searching multiple fields, but I need to figure out how to
Hi to all,
i dont think so its a big task but due to some reason i could not get a proper return value its returning me null which seems to be some thing is wrong in query entries that was not executing in proper way me just writing my query here could you please check
where i am wrong.
dbo.ProjectA.Datestamp as Datetime1,
DateDiff(second, dbo.ProjectA.Datestamp, (select top 1 dbo.ProjectA.Datestamp from dbo.ProjectA where datepart(minute,dbo.ProjectA.Datestamp) > Dateadd(Minute,1, datepart(minute,dbo.ProjectA.Datestamp) ))) as time_difference
Where (dbo.ProjectA.Datestamp between CONVERT(Datetime, '2010-09-09 06:00:00', 102)and CONVERT(Datetime, '2010-09-09 18:00:00', 102))
Group by LineID,dbo.ProjectA.Datestamp, dbo.ProjectA.ProductCod
Having (dbo.ProjectA.LineID = '1' )
order by dbo.ProjectA.Datestamp
LineID ProductCod Datestamp time_difference
1 prdAitmq4673 2010-09-09 06:05:57.090 NULL
i have one issue access the record for SQL Server. i have 10 record in one table more the one user access the particular table records. one record access for one user how control other user access same record
please help me on this