hi,

thanks for your quick reply, there is no data tag in that xml, kindly ignore that, start and end tags are page

excel is mixture

sql server 2008 is 64 bit

i tried even using excel 12.0 in the query but ending up with the same issue 🙁

i run on sql 2008 and excel 2007

but my requirement is to push the data into excel. Kindly help me on this.

thanks a lot dude 🙂 it worked like a charm 2 me 🙂

Hi,

Please do find the DDl of my table below :

ID ClientVersion UserName

12.5.0.1 ram

22.6.0.2 ...

Hai Jared,

Could you please write me a query which could get the exact maximum versions though there might be many versions in the future.

Thanks,

ram

Hi Sean,

Thanks for your spontaneous reply. That worked liked a charm for me, and iam having one doubt in this. Suppose if want to have the telephone country code as...

Thanks a lot 🙂

It worked for me exactly

No Luck still

Hi,

Thanks a lot for your reply.I got the answer what i was looking. I did it with the help of my buddy.

Thanks dude:)

Depending on how much data you have, I would try the import export wizard as it is the easiest way. So in SSMS, right click on the database, go to...

Hi Chris,

The query which u gave returns me two rows.Now i want to do Union for these row values. Could you let me know how to do aggregation.

Thanks,

Ram