>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
>
>

Sergey's right (as usual). If the function is within the same database then

@ctr = dbo.MyFunction()

Otherwise, use

mydatabase.dbo.MyFunction()