FOR XML AUTO, ELEMENTS result into a varchar or nText

• George Thomas-241216

  SSC Enthusiast

  Points: 121

  More actions

  June 27, 2005 at 10:31 pm

  #66666

  Dear All

  I have a query something like this in a SP

  SELECT

  @p_USER_ID AS USER_ID,

  PROCESS_LINK_ID,

  @p_PROJECT_NAME AS PROJECT_NAME,

  REFER_ITEM,

  OCCURRED_TIME,

  PROCESSED_FLAG

  FROM

  TBL_ALERTS AS ALERT

  WHERE

  ALERT_ID =1

  FOR XML AUTO, ELEMENTS

  I am using SQL Server 2000

  Is there anyway by which I could get the result of it in a varchar or nText variable....

  Any help is welcome.I am really in a perplexed situation. Pls HELP !!!!

  I am looking for something equal to :

  Declare @XML XML

  SET @XML = ( Select * from pubs..authors Authors FOR XML AUTO,ELEMENTS )

  Select @XML

  which is said to be available in SQL SERVER 2005

  Thanking in advance

  George

• philcart

  SSC-Forever

  Points: 47795

  More actions

  June 27, 2005 at 11:42 pm

  #568814

  Please don't cross post.

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=194572

   

  --------------------
  Colt 45 - the original point and click interface

• George Thomas-241216

  SSC Enthusiast

  Points: 121

  More actions

  June 28, 2005 at 12:38 am

  #568822

  Sorry that I cross posted the doubt