Hi,

I have attached the required result. Check the Plant_Date and Void Status.

Regards,

Jag

The below query is kind of working but stops at the Let_Date. In the example below property 3143 is let on 2016-03-14 and in the result set the property does...

Yes, i'm using a calendar table but how do I write the query to only show me the void status with plant_date as the month end date. Below is...

The amount 300,000 is a budget figure which I'm given. I'm just trying to use sql to blend data so thinking if I can create a view to spread the...

Hi Hall of Fame,

Actually there is no table, I'm looking how I can create a view so I can join it with another view.

Thanks

Hi Ed,

I have updated the explanation and sample table.

Thanks

Jag

Hi Kapil,

This is why I came to the forum for support. Below is the solution from another forum.

DECLARE @table TABLE

( Prop_Code INT

,Current_Rent Money

,Revised_Rent Money

,Rent_Review_Date varchar(10)

...

Thanks Milos that really helped. If you do mind could you explain how the partition query works please for my understanding.

Thanks

Jag

Hi Milos,

We will need time as well as for few prop_code the rent was updated twice on the same day and we need to take the max for that date...

Hi,

I have updated the table to reflect to prop_code with no rent updates.

Jag

Thanks Eirikur. What if I just need the view in normal columns please.

PropCodeYearMonthMarket Rent

27182014July299.18

27182014August299.18

27182014September299.18

27182014October299.18

27182014November299.18

27182014December299.18

27182015January310

27182015February310

27182015March310

27182015April310

27182015May310

27182015June310

39012014July400

39012014August400

39012014September400

39012014October400

39012014November400

39012014December420

39012015January420

39012015February420

39012015March420

39012015April420

39012015May420

39012015June420

39602014November470

39602014December470

39602015January470

39602015February470

39602015March470

39602015April470

39602015May470

39602015June470

Jag