Click here to Skip to main content
14,328,979 members
Rate this:
Please Sign up or sign in to vote.
Can Any Body Tell Me About Recursive Function in Postgres Sql or Sql Server.
Posted
Rate this:
Please Sign up or sign in to vote.

Solution 3

   
Rate this:
Please Sign up or sign in to vote.

Solution 1

Here is a short article with an example and further links:
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=24[^]
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

Hi,

Have you tried googleing ?

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:
Please Sign up or sign in to vote.

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
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100