Create unique user name from first and last name

• rasoulov

  Right there with Babe

  Points: 765

  More actions

  July 15, 2004 at 8:09 am

  #85855

  Does anyone have a function or stored procedure to create a unique user name from first and last name?  I would appreciate the help.

   

  Thanks

• ewilson10

  SSCarpal Tunnel

  Points: 4255

  More actions

  July 15, 2004 at 11:42 am

  #514712

  Would this work?

  USE Northwind

  select LastName + FirstName +

  CONVERT(varchar(2),(DATEPART(mm,GETDATE()))) +

  CONVERT(varchar(2),(DATEPART(dd,GETDATE()))) +

  CONVERT(varchar(4),(DATEPART(yy,GETDATE()))) +

  CONVERT(varchar(2),(DATEPART(hh,GETDATE()))) +

  CONVERT(varchar(2),(DATEPART(mi,GETDATE()))) +

  CONVERT(varchar(2),(DATEPART(ss,GETDATE()))) +

  CONVERT(varchar(4),(DATEPART(ms,GETDATE())))

  AS UID

  from Employees

  
  
  Everett Wilson
  ewilson10@yahoo.com

• rockmoose

  SSCarpal Tunnel

  Points: 4601

  More actions

  July 15, 2004 at 3:14 pm

  #514758

  Elaborating...

  USE Northwind

  select LastName + FirstName + convert(varchar(36),newid()) from Employees -- Very Unique

  select binary_checksum(LastName,FirstName) from Employees-- Case sensitive

  select checksum(LastName,FirstName) from Employees-- Case insensitive

  /rockmoose

  
  You must unlearn what You have learnt