Shift value to begin fiscal year 2012/04

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Shift value to begin fiscal year 2012/04

Author

Topic

micnie_2020
Posting Yak Master

232 Posts

Posted - 2012-12-20 : 20:45:27

Hi All,

How to shift the price value if the ID having Datt 2012/04 else remain same.

Before:
ID Datt Amt Price
1 2012/01 3 50
1 2012/02 3 0
1 2012/03 3 0
1 2012/04 3 0
2 2011/01 5 90
2 2011/02 5 0

After:
ID Datt Amt Price
1 2012/01 3 0
1 2012/02 3 0
1 2012/03 3 0
1 2012/04 3 50
2 2011/01 5 90
2 2011/02 5 0

Please advise.

Thank you.

Regards,
Micheale

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-20 : 20:51:04

Your question is not clear.

micnie_2020
Posting Yak Master

232 Posts

Posted - 2012-12-20 : 20:56:32

Hi,

To explain further,

eg:

i need all the group ID which having Datt 2012/04, the previous Price value will shift to Datt 2012/04
ID Datt Price
1 2012/04 50

and the previous record price will zerolize
ID Datt Price
1 2012/01 0

For ID 2, there is no Datt 2012/04. Mean the value remain as Current without changing the price value.

Hope i make my question clear.

Thank you.

Regards,
Micheale

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-20 : 21:09:00

[code]Select T.ID,T.Date,T.Amt,Case When T.Date = '2012/04' then P.Price Else T.Price End as Price
from Table T
left join
(
Select ID,MIN(Date) MinDate,MIN(Price) Price
from Table
Group by ID
)P on P.ID = T.ID and T.Date = P.MinDate[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources