that's ok, i tinkered with it some more and managed to get what i needed.

Thank you,

This works for me. These are just one shot deals. another dept has programs for maintaining the data. all they need for me to do was mass copy from one...

ROW_NUMBER sounds promising.

the values they want in spdd_f5 will be 1 thru 100 (will never go over 100) no duplicates.

it is just a pad number but it would need...

that is what i was needing. the not in was doing me in.

Thanks

I am trying to find anywhere how to link fields together to match the index. These indexes range in size from 1 to 12 columns. I tried the + thing...

I guess what I am looking to do is INSERT but skip/ignore/don't care about any duplicates.

Some of these tables that I am working with have multi-column unique indexes and...

OK after going over this with the users i have been told that duplicate f1 (indexed unique) is possible. how would i go about changing the insert command to avoid...

Super, thanks so much for the information.

That's pretty much what I have been coding in my application to do. Find all the matching columns then sorting them by name. I then got concerned about the sorting...

you are on to something there because i have the database and some of the tables but not all of them. the tables missing are the ones with the bit...

I am relaying this from memory but I thought it was a UDF that allowed the sql server to recognize True/False as a valid variable in the sql statement but...

It is a bit

no the code created a data type that the code could reference it as True or False

it allowed sql syntax to work

select * from tbl1 where bit_column = true

I have...

Steve Jones - SSC Editor (5/3/2012)

---

Your subquery 1 after the WHERE clause looks to be pulling lots of data for the NOT IN. I think that's your problem. You need...

OK sorry for posting but i got it figured out... (eliminated the select from the where clause...)

insert into LIVEDB.dbo.APHEXPF

(aph_comp, aph_vend, aph_type, aph_id, aph_padd, aph_acct, aph_post_co,

aph_desc, aph_amt, aph_proj, aph_pline)

select...