How to execute a stored procedure inside a select query

by

Thanks @twoleggedhorse.

Here is the solution.

  1. First we created a function

    CREATE FUNCTION GetAIntFromStoredProc(@parm Nvarchar(50)) RETURNS INTEGER

AS
BEGIN
   DECLARE @id INTEGER

   set @id= (select TOP(1) id From tbl where col=@parm)

   RETURN @id
END

  2. then we do the select query

    Select col1, col2, col3,
GetAIntFromStoredProc(T.col1) As col4
From Tbl as T
Where col2=@parm

More Related Contents:

  1. SQL Server Insert if not exists
  2. Split values over multiple rows [duplicate]
  3. Stored procedure that exports data into csv files only exports to one file
  4. SQL Server: should I use information_schema tables over sys tables?
  5. Unpivot with column name
  6. How can I delete using INNER JOIN with SQL Server?
  7. What this query does to create comma delimited list SQL Server?
  8. SQL Server – Return value after INSERT
  9. Convert varchar into datetime in SQL Server
  10. sql query to return differences between two tables
  11. Check if a row exists, otherwise insert
  12. SQL Call Stored Procedure for each Row without using a cursor
  13. How to select the last record of a table in SQL?
  14. Execute Stored Procedure from a Function
  15. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  16. How to write UPDATE SQL with Table alias in SQL Server 2008?
  17. SQL Server 2008- Get table constraints
  18. Restrict an SQL Server connection to a specific IP address
  19. Execute Dynamic Query with go in sql
  20. TransactSQL to run another TransactSQL script
  21. How can I get a list of element names from an XML value in SQL Server
  22. Why are logical reads for windowed aggregate functions so high?
  23. How to rename something in SQL Server that has square brackets in the name?
  24. Comma Separated values with SQL Query
  25. how to separate string into different columns?
  26. Backup a single table with its data from a database in sql server 2008
  27. COALESCE Function in TSQL
  28. Script entire database SQL-Server
  29. Check if a parameter is null or empty in a stored procedure
  30. Try_Convert for SQL Server 2008 R2

Leave a Comment