passing XML data as parameters

• jed-1049165

  Newbie

  Points: 3

  More actions

  March 24, 2009 at 11:30 pm

  #219417

  I have a stored procedure that requires XML data as a parameter for it to run. When I run a SQL trace on this proc, it looks like this:

  EXEC import_rates_xml_sp

  0,N'

  '

  In the example above, 2 records are being passed from an existing SQL table to the stored procedure. I know this table very well. My problem is how do I create this XML structure and pass it to the procedure?

  Many thanks.

  Jim

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 24, 2009 at 11:40 pm

  #965795

  Two things:

  1) Attach your XML as a zip or txt file.

  2) What are you calling you proc from?

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]