Embedding a 'UDF' in a SP in version 7

• BobAtDBS

  SSCarpal Tunnel

  Points: 4590

  More actions

  October 3, 2002 at 11:55 am

  #75965

  I'd like to embed a kind of User Defined Function in a Select statement in SQL Server Version 7. Is there any way to kludge this together?

  Kind of like this:

  Select Field1, MyStoredProcedure(Field2, ProcessedField2 output) from Table

  Oh for the power of VB in Stored Procedures...

  Student of SQL and Golf, Master of Neither

  
  Student of SQL and Golf, Master of Neither

• Antares686

  SSC Guru

  Points: 125444

  More actions

  October 3, 2002 at 5:58 pm

  #437805

  SQL 7 does not support user defined funtions. And you cannot use an SP inline with a Select statement.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)