Expanding on PW's post, I suggest you use this format:

'YYYY-MM-DD HH:MM:SS.mmm'

So your query becomes:

...

and PickupDate > '2006-02-03 00:00:00.000'

order by PickupDate

(if you're using English date format.)

A strange request!

update table set age = 32 where id = [PK for row containing John's data]

update table set age = 26 where id = [PK for row...

Please do not cross post. Follow this thread.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=268690

Are you exporting the field as text?

So what's wrong with my solution?

Your solution, I'm afraid, is logically flawed. Eg if this is sample data

T1 (CustNo, OrderNo)

1,1

1,2

2,1

T2 (CustNo, OrderNo)

1,1

Your query...

So are you thinking of adding a new column to the 'old' table corresponding with 'software_no' in the new table?

Once you have the 'next' identity number, what are you going to do with it?

Maybe @@IDENTITY, or Scope_Identity() (check BOL for details) will give you what you need?

Your idea is probably the way I would do it.

The tricky bit is the creation of the mapping table. Perhaps you can partially automate this, by matching on 'test description'...

select t1.*

from t1 left join t2 on t1.Custno = t2.CustNo and t1.OrderNo = t2.OrderNo

where t2.CustNo is null and t2.OrderNo is null

Why do you want to return every single field, in every single record, for such a large table?

A clustered index will help if you run a query with a suitable...

Yes it matters (see next para). The triggers will fire as usual, because they are defined at table level. So you need to avoid importing into those tables that will...

Maybe you could create a trigger that would perform the integrity checks that you need on insert, update etc.

So what is the DTS package transferring? Not records, I presume. Why do you want to call triggers when they look after themselves after inserts/updates etc?

You'll have to be a...

This code reproduces the error - could it be the problem?

declare @contact varchar(10)

set @contact = 'abbbbbbbbc '

select substring(@contact,1,charindex(' ',@contact)-1)

Hang on. VARCHAR value 'NULL'?? Suggests that this might work:

select * from tableA

where col5 = 'NULL'

If so, it's not empty - it's a string set to NULL.