How to create a temp table from xml data

• Naveen Kumar-807681

  Ten Centuries

  Points: 1284

  More actions

  January 29, 2009 at 1:50 am

  #200535

  Hi Everybody,

  I need help from any of u guys. I get 2 parameters to a stored procedure . The first parameter is a xml datatype and the second parameter is a string. I need a stored procedure which creates a temp table or a table variable with the same name of the second parameter and witht he same structrue of the xml datatype. The xml datatype which i get i nothing but a datatable in .net converted into xml and then passed as a parameter to stored procedure.

  Thanks & Regards,

  Naveen kumar

  Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  January 30, 2009 at 5:29 am

  #935426

  could you show a sample xml document and the output you are looking for? why do you need a table or table variable with a specific name?

  .

• octavio.hdez

  SSC Journeyman

  Points: 77

  More actions

  June 10, 2009 at 2:57 pm

  #1007676

  Hi,

  I also would like to be able to do that. Having a SP:

  CREATE PROCEDURE CreateTable(

  @Name VARCHAR(20), -- the name of the table

  @data XML) -- defines structure of the table and the data to add (includes schema)

  AS BEGIN

  -- ...

  Regards,

  OH