Indeed it does... I just saw the post and posted what I thought would be a possible solution. I like your solution too...

I mixed up the statusess... you'll just have to change them accordingly, but I think you get the rough idea what Iw as trying to do...

Hi.

I think this may help....

select id,

time_stamp,

cast(cast(datepart(yyyy,time_stamp) as nvarchar(4))

+'-'+

cast(datepart(month,time_stamp) as nvarchar(2))

+'-'+

cast(datepart(day,time_stamp) as nvarchar(2))

+' '+

cast(datepart(Hour,time_stamp) as nvarchar(2))

+':'+

cast(datepart(minute,time_stamp) as nvarchar(2))

+':00' as datetime) [normalised_TS],

machine_state

into #temp

from export_table

----

-- Running Times Assuming 2 = start and 1...

Hi.

I am going to take a stab at your question...

I love having stuff happen on the fly (dynamically). I would suggest creating either a view linking all the required tables...

The SQL Server is SQL 2005 Standard Edition.

There is and HTTPS web service on the Provider's side that I need to connect to. Unfortunately our dear Mobile Service providers in the good old South Africa do NOT...