Thanking you for time and input it has been most helpfull.

i will now examine closely & work out how this all fits together.

Your contribution is appreciated and valued.

It appears there...

there is the rare occasion a service person or an auditor needs to recall a previously run test as a verification or quality measure and review the results through...

I have been trying to comphrend the syntax, the concept of variables i understand

i have created the two simplified tables defined by the below sql statement.

the unque test id...

we have normalised some xml files from our automated fluke testing system by separating the sections into two tables with fields set to store as xml. one table holding results...

Anyone got any sugestions?

these two provided files are xml table field data. i am unable to successfully merge the xml results returned data into the end of the proceedure...

Thankyou for your input that was a Big help and very much appreciated....probably a few more questions a little later:-)

Eureka - ok got information being sent back. Thankyou for your input the knowledge has fallen into place somewhat.

my next question is that fluke ansur system manager in the xml...

The calling program (LABVIEW) is linked through OLEDB. we are only wanting the return of the ascii values and, if possible, not through the creation of a second table?

just tried your suggestion and has returned the error message

"Must declare the scalar variable @val"

i have been doing lots of reading on the MS forum and google searches and ether...