Store Procedure convert into Function

[Edimator]

Hi, i need convert a stored procedure into a online function.

My tables are DAY01, DAY02 ... DAY31, and y need to put the SP in a select query.

the sp is:

ALTER PROCEDURE dbo.sp_get_calls
@day varchar(15)
AS
begin
declare @sql varchar(400)
set @sql = 'SELECT * FROM DAY' + @table + 'WHERE calltype = 1'
exec (@sql)
end


I realy apreciate any kind of help

 

[tlbroadbent]

Please explain what you mean. What result would the function return? Do you intend to return the same data set as the stored procedure or something else? Which SQL Server version are you running? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[Edimator]

I'm using SQL2000, because i cant put a SP in a query from select, i need to convert the SP above in a inline function with one parameter.

This SP returns the same dataset for all tables that tablename begin with "DAY"

Sorry about my bad english, spanish is my natural language.

 

[tlbroadbent]

In SQL 2000, you can create a function that returns a table. You then can use the function in a select statment.

See SQL BOL or this link for details.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_create_7r1l.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.