And it probably wasn't me. Now I feel bad. :crying:

I haven't made it...

That's definitely true. My take on many posters at...

Thanks for noticing. I was actually hoping to hit it in 2009, but I slowed down...

RECEIVE will remove the event from the queue so as long as you don't do a ROLLBACK TRANSACTION the processed event will be cleared from the queue.

Yes, but I'm not sure it's a good idea.

I'd personally be inclined to try to return the all the data in the query instead of trying to do it all in the report, but that is just because...

I think if you want to do this, and I'm not sure this will do what want either, you need a second group on the Material then your details rows...

A good place to start to understand how this works would be these 2 blog posts by K. Brian Kelley:

http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/10/27/sql-university-diving-into-authorization.aspx

http://www.sqlservercentral.com/blogs/brian_kelley/archive/2009/10/30/sql-university-multiple-paths-and-ownership-chaining.aspx

How are you creating the ID field and the item number?

What do the different values in the ID field mean and what is the logic for creating them?

Your...

Here's the BOL link for MERGE

I'm also going to make my standard comment on most trigger posts. You do realize that your trigger will only work correctly when a single row is updated. ...

Yes, you can insert into an audit...

paucann (2/2/2010)

---

I don't want to post the whole query but this section prevents anything other than a date stored as a varchar:

t_UserExtended_1.ue_ControlName = 'PO_InvoiceDate'

That's the join I was alluding to...

It might help us if you were to post the entire query.

I can't think of any reason why the query would ever work if there is any invalid data in...

WayneS (2/2/2010)

---

Paul, are you saying that sometimes it holds a date, and other times something else? Jeez, this is a horrible...