XP

• Nita Reddy

  SSCarpal Tunnel

  Points: 4171

  More actions

  January 24, 2005 at 2:25 pm

  #112942

  I have a query which is using cursor to load data from one database to another.

  When I execute this query in XP runs fine BUT when I run this query in 2000 it insert the same data. for example

  in XP

  id name source_ id

  1 aaa    11

  2 bbb    12

   

  IN 2000

  id  name  source_id

  1  aaa     11

  2  bbb     11

  Does XP and 2000 use any kinds of setting related to Cursur

• January 27, 2005 at 8:00 am

  This was removed by the editor as SPAM

• dclary

  Old Hand

  Points: 321

  More actions

  January 31, 2005 at 12:38 pm

  #539786

  Can you post the query you're using, or a reasonable facsimile? It's difficult to come up with suggestions just based on the results as listed.

  
  
  David W. Clary
  MCSD
  Data Miner 49er
  Sr. Database Administrator, Ceiva Logic