niyinks (8/17/2010)
HiI have read the new link and still am slightly out of my depth, please could you just give pointers on how to get the table into the desired structure so I camn make that available
Sure - Right click on the table in SQL Server Management Studio and then select "Script Table as Create to" and select your output location.
You will have to work on the insert statements but the example provided by Jeff in that article should help you see the format / construct for an insert statement.
Hope this helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot