The only way to do this is to compare the value in that column between the inserted and deleted tables. Here's how I'd do it:

INSERT INTO [dbName].[dbo].[log_table]

...

SQLRNNR (7/17/2014)

---

Eirikur Eiriksson (7/16/2014)

---

Jack Corbett (7/16/2014)

---

Eirikur Eiriksson (7/16/2014)

---

No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub...

Hmmm, I hope I'm...

I'm pretty...

For the error in mine you just need to replace the max_policy_status_v_id to i because I aliased the CTE in the FROM clause.

Jason Selburg (7/16/2014)

---

and another possible approach. ** although without test data I can't be sure. 🙂

I'd also recommend coming up with another way to identify the data_set_nbr. That is what...

T-SQL beginnger (7/16/2014)

---

Thanks for your reply Jack.

Basically the reason for creating this view is to get the latest version of policy since there are a lot of of policies in...

Can you provide the requirements of view? Something like:

"Return the Policy information for active policies based on the most recent status of the policy."

I know that isn't right, but...

For some reason when...

You don't. There really isn't way I know of to do what you are trying to do. You could look into BIML, but even then you need metadata...

As HanShi said, there really isn't one query (I suppose you could write one) that would get all that for you. I recommend you look at SQL Power Doc[/url]...

You need to work with a rows groups, http://msdn.microsoft.com/en-us/library/dd255263(v=sql.110).aspx.

Your "header" group would group on product (and any other fields you would include on the header) and in the group properties...

As far as I'm concerned your vendor hasn't provided any evidence for making any changes on your server.

Are you experiencing performance issues and how do you know? ...

I wouldn't except present company all the time.

Steve Jones - SSC Editor (7/16/2014)

---

GilaMonster (7/16/2014)

---

I would be, if he...