View Single Post
  #4 (permalink)  
Old May 15th, 2009, 08:22 AM
123Rani 123Rani is offline
Registered User
 
Join Date: May 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi, instead of
Order by Amount1 DESC FOR XML AUTO, Elements" QueryOut "' + @fNameTemp + '" -c -t, -T -S'


Try using "Order by Amount1 DESC FOR XML AUTO, Elements" QueryOut "' + @fNameTemp + '"-S<servername> -c -r -t
"
Reply With Quote