Stored Procedure / OpenXML Failure - Can Anyone Help..???

• David.Poole

  SSC Guru

  Points: 75656

  More actions

  January 11, 2006 at 12:01 pm

  #614153

  Just for the sake of testing change your INSERT INTO query to SELECT INTO TestTable

  That way

  INSERT INTO MarketRiskdev.dbo.Import_Argentina

  SELECT * FROM TestTable

  should work. If it doesn't you will be closer to finding out why.

  LinkedIn Profile

• Sergiy

  SSC Guru

  Points: 110192

  More actions

  January 11, 2006 at 2:40 pm

  #614194

  WITH (un_cid varchar(50), tnum nvarchar(50), snum nvarchar(50), cid varchar(50), entityid varchar(50), ctype varchar(50),

    why  varchar(50),

    comp  varchar(50),

    oc  varchar(50),

    bs  varchar(50),

    ae  varchar(50),

    cp  varchar(50),

    trd_date datetime,

    set_date datetime,

    mat_date datetime,

    val_date   datetime,

    trader  varchar(50),

    famt  float(8),

    price  float(8),

    coupon  float(8),

    next_coupon datetime,

    last_coupon datetime,

    cpnfreq  int,

    cpnrate  float,

    cpntype  int,

    daycounttype smallint,

    exch_notion smallint,

    contract_spot float(8),

    base_cur varchar(50),

    year_basis int,

    buy_currency varchar(50),

    buy_currency varchar(50),

    buy_amount float(8),

    sell_currency varchar(50),

    sell_amount float(8),

    [timestamp] varchar(50))

    

  _____________
  Code for TallyGenerator