Viewing 2 posts - 1 through 2 (of 2 total)
Nonscalar types such as cursor and table cannot be used as input parameters for user defined functions. See SQL Server Books Online (Create Function) for more information.
April 30, 2004 at 6:46 am
#504810
Why not just use a case statement? ie:
SELECT
CASE WHEN (X < 100) THEN 1
WHEN (X >= 100 AND X < 1000) THEN 2
ELSE 3 END [MyColumn]
...
GROUP BY
CASE WHEN...
April 22, 2004 at 10:56 pm
#503936