Nice back to basics question. It seems from the discussion that this is still not as widely known as I would expect. For the first time in quite a long...

You could do that however I would argue that writing your trigger to sidestep auditing is not really auditing. Depending on the business this kind of loophole can be big...

I agree with not creating a scalar UDF. They are prone to horrible performance. Drew is spot on that a correlated subquery or APPLY is better approach. Like he said...

Take a look at the first in my signature about best practices on posting questions. We need a lot more details to even begin working on a solution here.

njdevils39 (3/26/2012)

---

capn.hector (3/26/2012)

---

im amazed at your patience sean. im sitting here laughing. ill save you at least one time.

We need the DDL and sample data. im supprised...

Yeah I first requested ddl and sample data for employee and employee_other in post #5 of this thread. I am now writing post #68 and still asking for the same...

BROKEN RECORD!!! You continue to ignore the most basic and simple request. Are you a troll looking to be annoying or are you seriously unable to read and comprehend basic...

I've got a fun one to add to that list. Working in healthcare insurance. In the US, our Social Security Numbers are assigned for life and are supposed to be...

Meaning you want to slow down sql to format data for display? 😀

Is there a question here or are you just somewhat shamelessly plugging your Oracle site? You did happen to notice that this is a sql server forum right?

Pictures??? They are not even attached to your post. Even if they were they wont help. What will help is sample data for the employee_other table. Looking back at the...

Yes but do you want to me to just blindly think I might have it right or would you prefer I actually test my code? I would assume you want...

I know but it is this insert right? You are trying to insert this data and 2-3 of the columns data comes from your xml?

njdevils39 (3/26/2012)

---

The temp table is the join of two tables, the employee table and the employee_other table. There is no source table in this stored proc.

Its a simple join statement...

njdevils39 (3/26/2012)

---

This seems harder than the prototype I created, all I have to do is join the two tables, but only extract items from the rate_history XML column.

Give me...