Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Deathsbain
-
printing variable values from within a UDF
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...- Deathsbain
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
SQL-Select Command
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...- Deathsbain
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQL-Select Command
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...- Deathsbain
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
