I am currently finding a solution to a problem i have and i was hoping the great minds of the forums could help. The problem goes as fallows: I am wondering if there is a way to access a function called getUserPoints() stored in a COM object within an MS SQL Statement. For instance,
in a programming manner i want to do something like this:
"Update [table] Set Points = " & getUserPoints(param1, param2) & " WHERE ID=9". I know you can do this with PL/SQL, but is there a solution for MS SQL????
HELP PLEEEEASE!!!