thanks Laurie! 🙂

Works Great!!!:cool: Thanks much MickyT!!!

now one more step. :w00t:

i need the converted date to be in the format: yyyy-mm-ddThh:mm:ss.mmm

i found this using google:

SELECT convert(varchar, getdate(), 126)

but still trying to...

aslo i forgot to say that i am using SQL2005 so the VALUES heyword seem to be a problem in that version. WHat would be the equivalent code for SQL2005?

thanks...

Sorry i meant Micky 🙂

thanks in advance

Sean: dont know my friend. I was still trying to find more infos about the Timestamp_ID.

Thanks for the hints Lowell!

Chris, i think thats what i needed my friend!. Now...

Very interesting. After diggin a litle more into that SQL database i found that the 2 user defined function i attached on my first post are being called by a...

That column is the tIME STAMP (date and time) that a sample of a reading have been taken. I just genertaed insert statement for the first few rows because that...

Sorry for the delay. I had to figure out how to generate insert statements for existing database here what i got:

USE [SMS_AR_Report];

SET NOCOUNT ON;

SET XACT_ABORT ON;

GO

BEGIN TRANSACTION;

INSERT INTO [dbo].[HST_Currents]([Timestamp_ID], [Device_ID],...

Hi

thanks for the reply. I checkd the link in your signature and, am sorry to say that i dont understand how to do that.

I am working on an existing SQL...