Now way around that with the grid result.

Also if you are using access to report this data, you can use the group by functions to "hide" the duplicates.  So a...

Like I said... with a touch of communication skills.

Thanx SDM .

No offense but the temp table part is useless in this exemple (maybe we are not seeing all the code).

Replace somecol with the list of columns you want to display.

Please post sample data from all tables and the required output you need us to create.  SQL and data are universal language .

DTS experts are not common on this board... might have to wait untill tomorrow when the message gets posted in the newsletter!

You want to update instead of inserting, you you need to update data between 2 different tables?

Let me put it this way :

SysDepends may not be 100% IS NOT accurate.

Less headeaches that way .

That's what I said, or unclearly implied.  The problem with sysdepends is that it cannot be trusted to list all dependancies so that's why I go with syscomments!

Syscomments is much safer to use.  You might get too many hits but you will get ALL hits for sure.

It can be done in an update statement but not in select.  You'd have to use a derived table, but I don't think you'd get much of a gain with...

Ok, seems to be a problem with ssms.  Call MS, still don't know how.  Maybe it would be a good time to start a new thread and ask

Still waiting to see what the original poster needs... looks like we're the ones in hurry here .

Select ColLIst FROM dbo.TableName where SomeCol IN (ISNULL(@p1, 0), ISNULL(@p2, 0), ISNULL(@p3, 0), ISNULL(@p4, 0))

I think you are forgetting about case sensitive seaches... but that's the only time I ever used that!!