Just a thought about triggers. Make sure you build your logic so that it can handle more than 1 record. In other words you want to join to the inserted...

No, in an update you "inserted" (the new values) and "deleted" (the current values). That make sense?

Yes you can use the "inserted" table.

select * from inserted

This will be the same structure as your table but will be the new values. In a delete trigger you have...

Thanks Matt. I knew I had seen a way to do that somewhere in my past but couldn't think of it for the life of me.

There is probably another way to do this but I have always done that like this.

select '<fields>' +

(

select [Your Field] as field from [Your Table] for xml path ('')

)

+...

Well...

Well you are attempting to create a multi statement table function but your syntax is that of Inline table valued function. You will have to define the layout of the...

Reading the question was the easy part. The hard part was reading your mind. As ColdCoffee asked in the first post we need some...

skynet_si (6/16/2011)

---

uhh..forgot to tell you....I am using Access database.

Since this is used in connection to programming , the way I pass my parameters to the queery :

ADOQuery1.Parameters.ParamByName('a1').asString := lookupcombobox1.text;

etc...

SQL is...

Well unless you are willing to share you salary we aren't going to do your homework for you. There is plenty of information on this site and across the internet...

The other big advantage of varchar over char fields is that there is a lot more work on the front end of apps when all the fields are char fields....

Or you could just add distinct to your select.

select DISTINCT ct.name,cot.id

from tags ct,ct_tags cot,doc_details cds,cont_poperties ccp

where ct.tagid=cot.tag_id and cot.contentid=cds.contentid and cds.contentid=ccp.contentid

The SQL connection could not possibly know the windows login ID of the person who established a database connection. You will have to do this in your application. You can...

I'm going to be off site the next couple days with a client. I will try to check back this evening and help if I can. Hopefully somebody else will...

Glad you found a solution and thanks for posting your final code. Will definitely help others having similar issues down the road.