Hi Brian

Thanks for your reply. I figured this out as follows:

I changed the connection string to the following:

private string defaultConnectionString = "server=METRODEMO\\SQLEXPRESS,1433;Database=Logger;Trusted_Connection=True;";

All I need to do is to put the...

Fantastic. thank you so much for that Steve

I had an inital workaround on this...but it was much more complicated and longer.

Thanks Steve

Thats looks good

OK if I wanted to run that code through a select statement (where my download tables are)

Then how I would i run it?

My source Select Statement is

select...

Thanks Brian...that worked perfectly for me

Thanks Guys

Some very useful stuff there

I elected to use this as I need to generate a 2nd column of random values

SELECT TOP 10

SomeSerialNo = CHOOSE(ca.N,'111111','222222', '333333','444444','555555','666666')

,SomeOtherRandomCols = CHOOSE(ca2.N,'Open','Closed', 'Polling','Listening','Error','Transmitting')

-- INTO...

Hi Brian

Ok what closing tags do I need at the end of my XML?