Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Recht
  • Content: Threads
  • Order by date
  1. Recht

    Parsing BINARY Data to VCHAR

    I need to parse the following data which is stored in a BINARY format as VARCHAR...
  2. Recht

    SQL Copy 1000 rows per table to new table

    Is there an easy way to copy 1000 rows from every table in the database to a new database. I was thinking about: set rowcount=1000 INSERT INTO [1435530ODR2]..AAPROCQT SELECT * FROM [1435530-R]..AAPROCQT But then I would have to detail all 1700 tables, uggg Thanks in advance. Recht
  3. Recht

    Duplicate records

    My brain is mush today, looking for some help deleting duplicate records from a SQL 2000 database. Basically the database name is ODR The table name is pro123 The column name that should contain the unique data is idnumber. I had to merge some data into this database from a recovery, so I...

Part and Inventory Search

Back
Top