12,747,207 members (28,362 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
 Dave Kreskowiak 158 Graeme_Grant 140 OriginalGriff 130 Maciej Los 85 NightWizzard 80
 OriginalGriff 3,658 Peter Leow 2,751 ppolymorphe 1,983 Karthik Bangalore 1,700 Richard MacCutchan 1,329