ok... i have a stored procedure (SP) that calls one of my UDF's... in the call it is supposed to pass 5 different variables... but my problem is that the end result is not coming out. here is a code snipit from the stored procedure...
count(*) as Instances,
sum(OutportMinutes) as...
yes... i have that part... but how do i deal with the gaps? like i said...
record1 = low-14/high-15/percent-15
record2 = low-17/high-18/percent-25
record3 = low-13/high-14/percent-05
record4 = low-18/high-19/percent-35
passedvalue = 16....
what i need it to do is if it fails to find one that...
this is the situation --
i am creating a user defined function...
have a table with highvalue, lowvalue, percent fields.
will be passing in a value and need to get the percent field from a "between" the high/low values...
ok that works fine except one thing... what happens if there is a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.