Okay. I don't really get logging the new value since the new value is always the value currently in the table. All you need to do is change...

My first thought was that the report was using a cached version of the report, but that wouldn't be the behavior you are describing and it wouldn't explain why a...

The only way to show all the errors is to use THROW and let the client get the error. There is a CONNECT item about it found here.

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...