Dave Ballantyne

I'm looking for this

You can describe or post how i can do this?

The external softwuare is a scada Software so between his funcitions is save historical date for industrial plant. But the number of dates can be add for user.

In the first...

CREATE TABLE #First (Id INT, [DateTime] numeric(18,0), LogType int, TAGA INT, _TAGA_Q INT, TAGB INT, _TagB_Q INT)

INSERT INTO #First (Id, [DateTime], TAGA, TagA_Qualyty, TAGB, TagB_Qualyty)

SELECT 37,634145506545000000,1,0,192,0,192

The struct of TagA and...

sorry

In the first post I put a simplified example

This table described in XML is First table

The second table is like the first post. I found some difficult to...

<?xml version="1.0" standalone="yes"?>

<_x002E_tHistorian xmlns="TatsoftDB">

<xs:schema id="_x002E_tHistorian" targetNamespace="TatsoftDB" xmlns:mstns="TatsoftDB" xmlns="TatsoftDB" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">

<xs:element name="_x002E_tHistorian" msdata:IsDataSet="true" msdata:Locale="en-US" msprop:sensitivity="False" msprop:specification="10">

<xs:complexType>

...

Thanks for the replies.

Chris Morris-439714

your answer is exactly what I want, but if possible I would like to know if you make it so dynamic? because the first table may...