12,063,645 members (71,201 online)
Rate this:
See more: , +
Can Any Body Tell Me About Recursive Function in Postgres Sql or Sql Server.
Posted 13-Sep-12 19: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
 Chris Maunder 135 CPallini 135 ppolymorphe 115 F-ES Sitecore 110 Anisuzzaman Sumon 103
 Dave Kreskowiak 1,827 Richard MacCutchan 1,250 d@nish 980 OriginalGriff 804 Sergey Alexandrovich Kryukov 733