...
>
>Nick Cabell
First of all, let me say, I agree with the most people's opinion "minor space gain with quite a bit of effort may not be worthy". Now, on the technical feasibility of the problem, I believe yes, here's a starter,
use UDF, then, map it into Table DDL, say, table name, tmp,
-- the UDF may look like this
create function keyVal()
returns int
AS
begin
declare @intID as int
if exists (select * from tmp)
select @intID = (select Min(keyCol) + 1 from tmp)
else
select @intID = 1
RETURN @intID
end
On a similar note,
>[Tom Kitta]
>My philosophy is to make things as simple as possible (but not simpler)
I fully agree.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
