PLSQL TO TSQL - SQL Server Forums

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 2012 Forums

Transact-SQL (2012)

PLSQL TO TSQL

Author

Topic

Blessed1978
Yak Posting Veteran

97 Posts

Posted - 2014-07-08 : 11:16:30

convert PLSQL TO TQSL

DECODE(SUBSTR(Period Name,5,2),SUBSTR(date,-2),DECODE(NVL(Prior Fy Expense,0),0,NVL(Pye Deprn Rsrv,0),Prior Fy Expense),NVL(Deprn Reserve,0))

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-07-08 : 12:46:59

Isn't this the exact same question asked a few days ago?

Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA