definately use a temp table and if space-permitting keep a log of transactions made from the exchange. I can't count how many times I had a particular customer complaim...

and null ''

null + 'any string' = null

you will have to use the ISNULL() function which is simillar to the NZ() function in ACCESS.

ISNULL(null,'') + 'any string' = 'any...

nevermind... I found a code solution here

http://groups.google.com/group/microsoft.public.access.adp.sqlserver/browse_thread/thread/955b5f39679d0fd7/9b94a4d5ff7b7f42?lnk=st&q=adp+sql+server+hostname&rnum=1#9b94a4d5ff7b7f42

you can use this code to determine sql or windows security as well.

Thanx many! I don't know why I didn't think of that. Good ole' Bill Gates!

Cheers!

-KM

Happens to the best of us. That's why we come here. Take care!

-KM

It is possible that the surName has variations in spelling?

Not the process (DTS)... the database

Sorry Didn;t read right...

SELECT DISTINCT NInumber, department

FROM Staff

WHERE

NInumber IN

(

SELECT NINumber

FROM staff

GROUP BY NINumber

HAVING (COUNT(DISTINCT department) > 1)

)

SELECT DISTINCT NInumber

WHERE NInumber IN

(

SELECT NINumber

FROM staff

GROUP BY NINumber, department

HAVING (COUNT(*) > 1)

)

Is it a result of adding/removing fields in a table, view, or view dependency (table) that is used by the DTS?

I never could find an effective use for indexing a view when I always have changing data. The first time I heard about it, I got excited until I...

This will eliminate problem of 2 key words in a record

create table x ( t VARCHAR (100))

insert x (t) values ('This is a text')

insert x (t) values ('And this appears...

Thank you for the replies. Our ASP developer has read warnings not to store a recordset in a session. We were avoiding fixed result sizes anyhow.

Fortunately we found...

look up "TRIGGER INSERTED" on msdn.

If you must use a record-based approach, I'd recommend using a staging table with a trigger using a cursor. (INSERTED i INNER JOIN StagingTable).

That being said, 99% of the...