Absolutely correct Eugene. I believe it would be very difficult to load the history records for update without a trigger. I have already informed my team that loading history without...

1. Using cursor will be much worth than using trigger.

2. What do you mean by "simple queries without a Third table"? What Third table?

3. What you have usually called "Audit...

Thanks Natraj.. Will look into it..

[font="Tahoma"]

Hello Friends,

I got the help from my colleague and I am able to create the drill down in the format as present in the screenshot.

I was using Tablix and my...

[font="Tahoma"]

Great Man.. All the Best for the exam...

[/font]

[font="Tahoma"]

Hey Anthony,

Thanks for your response mate... Yeah, it baffles me as well few times.. But I was able to bring that format just now...It took me around 2 hours...

[font="Tahoma"]

Thanks Jason for your response. Yeah, that seems to be only option...[/font]

Thanks Mark.. That was what i was looking for.. Thanks for your help...

[font="Tahoma"]

Thanks Koen for your response. I closed and reopened the BIDS couple of times and it was working fine. I too went across several threads mentioning that we might have...

[font="Tahoma"]

Hi Gail.. These tables are having foreign keys which are referencing other tables...These tables are not referred by other tables....

[/font]

[font="Tahoma"]

No Identity, No index, nothing.. Simpley foreign keys.. As you have all mentioned this should not be a best practice..

[/font]

[font="Tahoma"]

Thanks Koen.. It worked exactly the way that i was looking for.. Thanks for your help.. I was trying my best without any help, but could not find the way...

[font="Tahoma"]

Try this one

update Attributes

set EntityId = Entity.GlobalId

from Attributes

Join Entity

on Attributes.DQUID = Entity.GlobalId

[/font]

[font="Tahoma"]

I would like to add one more information to the others responses. You cannot use a column alias in the where condition.

So you can use the firstname in the...

Hey Chris.. That worked the way that i was looking for.. Thanks for your help and Thanks John for ur response.