A stored procedure cannot be called from a query but UDF can.
>what would be the correct syntax for calling a stored procedure within a select statement
>example:
>
>select set @ctr = @ctr + 1,
>(exec dbo.mySP1 @ctr, empfl.empid)
>from empfl
>
>
--sb--