Sorry

Thanks but

sorry dude i was after an xsl stuff

finally got it:

So the tab.col were just aliases

select tab.col.value('@id[1]','varchar(30)') as name

from myXML cross apply xml_data.nodes('books/book') tab (col)

sorry for this

select myXML.xml_data.value('name[1]','varchar(30)')

from myXML cross apply xml_data.nodes('books/book/name') myXML (xml_data)

I tried this and still...

Thanks Adi

I'm quite confused.

I have a table called myXML.with a column name called xml_data

and in this column i have:

abc

...

Its

abc

pqr

Thanks

Goo to know that

Lynn..

I don't know what else to write.

I have a query that has 3 tables joined that result in a resultset.

I can't use this query because it won't work with this...

Thanks kshitij

But i can't see any difference in the code i posted with the one you posted?

Am i blind 🙂

Yeah i know you can query sql data via excel etc..

But the people who need the data are not in our network.

The data needs to be send in interval across...

Gosta i know and i feel u.

I would def could have done this easier using SSIS.

Thanks

Need more info.

Can BCP export to excel.

About xp_cmdshell

thanks in advance

Thx Guys..

Hi,

the SQL Agent Service is running under NETWORK SERVICE.

Is Local System the way to go?

Please elaborate

Thanks

----------------------------------------------------------------------------

Hello,

Under which Account does the SQL Agent Service run? Perhaps...

Create a job and schedule it.

tfifield ,

I know and it was my fault.I didn't think right when i posted it.It was just a quick code sample

.Its all fixed and all was fine as i posted...