mind pieces

create function [dbo].uuid(@id varchar(36))
returns varchar(48)
as
begin
 declare @ret varchar(48)
 select @ret=format(getdate(),'yyyyMMddHHmmss')+lower(replace(@id,'-',''))
 return @ret
end

select dbo.uuid(NEWID())