14,328,979 members
Rate this:
See more: , +
Can Any Body Tell Me About Recursive Function in Postgres Sql or Sql Server.
Posted

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