Where did you get that quote Sue (really nice )???

How the heck would that help?? you still need to populate each combo by filtering that query somehow, that assuming that the cost of building that massive temp table is...

Dude :: 1 select/combo. End of story. It's the third time we say it and the last in my case. Good luck with any other solution...

Thanx for the troubleshooting... should help somebody in the future.

HTH.

create trigger tr_audit_u on dbo.TableName

for update

as

set nocount on

Insert into dbo.AuditTable (id, cols)

Select i.id, d.Name from Inserted I inner join Deleted D on I.id = D.id where coalesce(i.name, '') coalesce(d.name,...

Can you tell us again why you need to do this?????????

I can suggest like and and =, but I guess you really mean functions. What do you need to do exactly?

NP... just post to general when unsure.

HTH.

The final call is really simple :::

Select CAST(EachID as INT) AS EachID, Rank from dbo.fnSplit_Set (@IDS, ',')

It doesn't get much simpler than this

Select name from tempdb.dbo.SysObjects where name like '#%'

I think you'll need to make a single statement per combo and select only the data you need.

Please dot not cross-post.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=218415

7) Remi's notes about timestamps on Views were very interesting. However, MS documentation implies that Access 2002 and above can only edit data in the "most-many" table of a...