Converting Queries that Call Functions into SQL Server -- sql server new users

TomTait747
1/27/2005 10:13:05 AM

I have a query in Access that calls a VBA function that in turn can call up
to 7 other functions depending on the arguments fed into it. I would like to
convert the query into SQL Server. Naturally, the query would become a view
but I cannot figure out how I am going to mimic the VBA function in SQL
Server. I suppose I could convert the VBA function into VbScript but how
could I get the view to call the VbScript? Can a view call a stored

Francesco Anti
1/28/2005 11:42:29 AM

You can use user-defined functions or stored procedures, but both consist
only of transact SQL statements.
You can't call Vbscript or VBA functions directly from them.
If you can't translate your VBA functions in SQL statement, try to use
xp_cmdshell.

Francesco Anti

[quoted text, click to view]

sql server new users : Converting Queries that Call Functions into SQL Server