## Finding Ratio between two numbers

 Author Message Site Owners SSC Guru Group: Administrators Points: 55141 Visits: 295 Comments posted to this topic are about the item Finding Ratio between two numbers doronyaary SSC-Enthusiastic Group: General Forum Members Points: 108 Visits: 148 Thank you for your code. It was very helpful.By the way... I`m looking for a code to view recent T-SQL that was executed. Just like SQL Profiler but I want to incorporate it in my application. Do you know how to do that or where can I find further help ?Thanks !Doron. Pete Cox SSC-Addicted Group: General Forum Members Points: 470 Visits: 277 Hi,You might like to consider using Euclid's Algorithm to find the Highest Common Factor (Greatest Common Divisor)`CREATE FUNCTION CalculateRatio(@numerator int, @denominator int)RETURNS nvarchar(max)ASBEGIN declare @ratio nvarchar(max) declare @greatestcommondivisor int declare @x int declare @y int set @x = @numerator set @y = @denominator declare @tmp int if (@denominator > 0) begin while (@x > 0) begin if @x < @y begin set @tmp = @x set @x = @y set @y = @tmp end set @x = @x % @y end end set @greatestcommondivisor = @y if (@numerator = 0 or @denominator = 0 or @greatestcommondivisor = 1) begin set @ratio = convert(nvarchar(max), @numerator) + ':' + convert(nvarchar(max), @denominator) end else begin set @ratio = convert(nvarchar(max), @numerator/@greatestcommondivisor) + ':' + convert(nvarchar(max), @denominator/@greatestcommondivisor) end return @ratioEND`It returns a result faster than the original (even being lazy and using nvarchar(max)), much faster for larger numberscheers Iwas Bornready SSC Guru Group: General Forum Members Points: 58222 Visits: 886 Thanks for the script.