Hi Experts Im converting some VBA code to TSQL, nearly there just having a problem with using functions.
Although the VBA I want to use is a bit more complex then what I want to use below in essence its what I want to achieve.
I know I can use insert/update statements in functions in TSQL, so I guess it must be a procedure with (multiple) return parameters.
Please some one help!
Dim strName As String
strName = "Dave"
Function pfMy_ReuturnProcedure(strSirName As String)
strSirName = "Thorn"
'Then do some funky insert SQL statement here