12,399,799 members (49,051 online)
Rate this:
See more: , +
Can Any Body Tell Me About Recursive Function in Postgres Sql or Sql Server.
Posted 13-Sep-12 18:50pm

Rate this:

Rate this:

## Solution 1

Here is a short article with an example and further links:
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=24[^]
Rate this:

## Solution 2

Hi,

Here is SQL Server recursive function example,
SQL Server Recursive Function[^]

Postgree example,
Recursive function in Postgree SQL[^]

Hope you got the idea,
Rate this:

## Solution 4

No My Question is Like that I have 'HRA' Formula as '[Basic]+[Da]+[Ca]*1.47/100' then 'Ca' fromula is '[DA]+[Basic]/2' and then [Da] Formula is '[basic]*20/100' my basic value is 10000Rs. and Ca and da dumy values are 800 and 900 Rs.

I want This Type of calculation Which I m Showing.
HRA = '[Basic]+[Da]+[Ca]*1.47/100'
'10000+([basic]*20/100)+( [DA]+[Basic]/2 )*1.47/100'
'10000+([10000]*20/100)+( ( ([basic]*20/100) )+[10000]/2 )*1.47/100'
'10000+([10000]*20/100)+( ( ([10000]*20/100) )+[10000]/2 )*1.47/100'

Then calculate is it posible by a function check formula based value till then when its value comes.if formula is null then put direct value

Top Experts
Last 24hrsThis month
 ppolymorphe 405 OriginalGriff 315 Vincent Maverick Durano 265 0x01AA 175 Karthik Bangalore 165
 OriginalGriff 6,813 ppolymorphe 2,855 Karthik Bangalore 2,727 Richard MacCutchan 2,057 F-ES Sitecore 2,052