CptCrusty1 (12/11/2012)
Yeah, that's right....Before I use your spiffily written Scalar, how bad is mine? I can take it....
Err... Molasses in a Canadian winter. 😀
I would recommend you use the table-valued function, not the scalar, unless you're doing this:
SET @SomeVariable = dbo.fn_ExpandLotRange(2,8);
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability