Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2008-08-12 : 06:40:00
|
| hello all,I am having a production server with sql server 2000(standard edition) and sp4 .I want to have output of the following querry in xml form :SELECT mis_date, ringtone_downloads, song_dedications FROM tbl_ams_download_summary WHERE convert(varchar,mis_date,101)=convert(varchar,getdate()-1,101) AND circle='abc'for xml auto, elements and the output which is giving is :<_x0074__x0062__x006C__a_x006D_s__x0064_o_x0077_n_x006C_oa_x0064__s_x0075__x006D__x006D_a_x0072__x0079_><_x006D__x0069_s__x0064_a_x0074__x0065_>2008-08-03T00:00:00</_x006D__x0069_s__x0064_a_x0074__x0065_><_x0072__x0069_ng_x0074_on_x0065___x0064_o_x0077_n_x but the output created on other server with same sql server is <tbl_ams_download_summary><mis_date>2008-08-03T00:00:00</mis_date><ringtone_downloads>15</ringtone_downloads><song_dedications>37</song_dedications></tbl_ams_download_summary>please help its urgent |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-12 : 16:50:06
|
"On other server with same sql server"?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-08-13 : 07:40:59
|
| yeah the servers are different but the version of sql server and the table architecture ,Service pack etc are every thing same.... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-13 : 07:50:11
|
It seems collation is different.First query is hexadecimal and second is not.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-08-14 : 07:34:29
|
| Hello all,Thank u for your reply .but i am still not able to solve the problem |
|
|
|
|
|
|
urgent sql xml output