If you need to transfer data between SQL server and a flat-file, you could also try the BCP command.

BCP {[[database_name.][owner].]{table_name | view_name} | "query"}{in | out | queryout | format}...

The easiest way to highlight any duplicate records would be to count records per fields that should be unique.

If your table should only have one record for Example : District and...

Assuming your salesNo is unique and incremental.

UPDATE A

set A.totalavailable = C.Totalqty

FROM

TableTwo A,

(

  Select Top 1 Salesno

  FROM TableTwo WITH (NOLOCK)

Order By salesno Desc

) B,

Table1 C

WHERE

 A.Salesno = B.Salesno

and A.partno=C.partno

Subquery B...

Hi all.

Is a query provided for the questions, or should we choose answers on probability based on available options ?

 

Would a "Copy SQL Server Objects Task" in DTS not be less troublesome?

Hi. I hope I understand you correctly, as this does not seem a very complex problem.

Create a DTS package with Text file Destination as target connection.

You can create multiple extracts...

This query should return only employees that is not in the selected MeetingAttendance range.

Select A.*

from

   Employees A Left outer join

   MeetingAttendance B

ON

    A.EmployeeID = B.EmployeeID

AND A.Meeting_ID =...

Hi.

Why not use the Isnull() statement ?

Select * from T1 Where Isnull(C1,0)=Isnull(C2,0)

You can usually not compare a Null to a value, as technically it is not actually a value.

Hi.

Something obvious I know, but Is the same user / server used for the batch run as the manual exec ?

I have made this mistake previously, and tried to run the...

Hi.

You could alternatively also try the query as below. The "WHERE" at the bottom will ensure that only records that do not exist in any of the union queries will...