San

If the three columns in your sample data are all part of the primary key, then those rows aren't duplicates.  You're going to need to change the design of your...

San

Which four columns is your PK defined on?  There are only three in your sample data.

John

True, depending on the requirement.  Sometimes you are only interested in the size of a number, which, in the case of a scalar, means its distance from zero.  For example,...

San

How are you going to choose which row(s) to eliminate and which one to keep?  If you search this site for eliminating duplicates or something similar, you will find lots...

David

What are the exact commands you are using in your application and in Query Analyzer?

John

Craig

Yes, since all your values are negative, this will work:

UPDATE MyTable SET MyNum = MyNum * -1

WHERE <whatever>

But if you didn't know whether the values would be be positive...

John is right.  It's as simple as this:

SELECT

TABLE_SCHEMA + '.' + TABLE_NAME

Luk

Do all your tables have a clustered index?

John

UPDATE t1

SET idcreated = t2.ID

FROM Table2 t2 INNER JOIN Table1 t1

ON t2.Description = t1.Description

John

Charbel

I've never tried doing anything like that before, so I don't know exactly how to do it.  One way round it would be to edit your format file as described...

Eamon

You can use the sys.dm_exec_sessions view to find out what session(s) a given SID has open.  Then simply put the session number(s) into DBCC INPUTBUFFER command.

John

Charbel

This is from the Microsoft website:

To create a format file that is easily modified, start the BCP

   utility by using the following command line:

      bcp <db_name>.<owner>.<table> out <data_file> /S<server>...

Charbel

If you read the BULK INSERT topic in Books Online, that should tell you everything you need to know.

John

Charbel

I think you can, but, depending how much data you are importing, you may find it easier to import into a staging table that has the same columns as the...