12,953,263 members (60,314 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
 OriginalGriff 190 RickZeeland 65 Member 13197019 65 Dave Kreskowiak 40 ppolymorphe 40
 OriginalGriff 6,429 CHill60 3,490 Maciej Los 3,103 Jochen Arndt 1,975 ppolymorphe 1,920