I don't know where my head is .... lol ...

here is the query i am using to do this

declare @data xml

SELECT @data = BulkColumn

/* select * */

from openrowset

(

bulk 'c:\testout\stream.xml',SINGLE_BLOB

)T

insert into [MiddletownData].[dbo].[RectifierData]

select T.Circuit.value('../@Name', 'nvarchar(10)') as CircuitName,

T.Circuit.value('../@ProcID', 'nchar(10)') as ProcID,

T.Circuit.value('../@PrgStp', 'int') as PrgStp,

T.Circuit.value('../@Mode', 'int') as Mode,

T.Circuit.value('../@A', 'float') as Amps,

T.Circuit.value('../@StpAH', 'float') as StpAH,

T.Circuit.value('../@V', 'float') as Volts,

T.Circuit.value('../@StpT', 'float') as StpT,

T.Circuit.value('../@RunTime', 'int') as RunTime,

T.Circuit.value('../@Tick', 'nchar(4)') as Tick,

T.Circuit.value('../@Pwr', 'char(5)') as Pwr,

T.Circuit.value('../@TLeft', 'float') as TLeft,

T.Circuit.value('../@AccumAH', 'float') as AccumAH,

T.Circuit.value('../@Alarm', 'nchar(2)') as Alarm,

T.Circuit.value('../@ProcStart', 'Datetime') as ProcStart,

T.Circuit.value('../@ProcEnd', 'Datetime') as ProcEnd,

T.Circuit.value('../@ProcFree', 'Datetime') as ProcFree,

T.Circuit.value('@Name', 'nvarchar(15)') as PrgName

from @data.nodes('Circuits/Circuit/Prg') as T(Circuit);

using the same xml file I posted with my first msg ...