Amol Patil

======Create Function CREATE FUNCTION [dbo].[GenerateMapKey] (@keyText NVARCHAR(4000)) RETURNS NVARCHAR(4000) AS BEGIN DECLARE @mapKey VARCHAR(4000) SELECT @mapKey = LOWER(@keyText) SELECT @mapKey = REPLACE(@mapKey,' ','-') SELECT @mapKey = REPLACE(@mapKey, CHAR(39),'-') SELECT @mapKey = REPLACE(@mapKey,'’','-') SELECT @mapKey = REPLACE(@mapKey,'‘','-') SELECT @mapKey = REPLACE(@mapKey,'!','-') SELECT @mapKey = REPLACE(@mapKey,'#','-') SELECT @mapKey = REPLACE(@mapKey,'$','-') SELECT @mapKey = REPLACE(@mapKey,'%','-') SELECT @mapKey = REPLACE(@mapKey,'^','-') SELECT @mapKey = REPLACE(@mapKey,'&','-') SELECT @mapKey = REPLACE(@mapKey,'*','-') SELECT @mapKey = REPLACE(@mapKey,'(','-') SELECT @mapKey = REPLACE(@mapKey,')','-') SELECT ...

==========Create Procedure CREATE PROCEDURE REMOVE_DUPLICATE(@string VARCHAR (100)) AS DECLARE @result VARCHAR (100) SET @result= '' SELECT @result=@result+ min ( substring (@string ,number,1)) FROM (      SELECT number      FROM master..spt_values      WHERE type= 'p' AND number BETWEEN 1 AND len(@string ) ) as t GROUP BY substring (@string,number,1) ORDER BY min (number) SELECT @result  ============ EXEC REMOVE_DUPLICATE 'aaabbbbbcc111111111111112' ===========Output

  Create the variables for the random number generation DECLARE @Random INT ; DECLARE @ Upper INT ; DECLARE @ Lower INT   ---- This will create a random number between 1 and 999 SET @ Lower = 1 ---- The lowest random number SET @ Upper = 999 ---- The highest random number SELECT @Random = ROUND(((@ Upper - @ Lower -1) * RAND() + @ Lower ), 0) SELECT @Random ======Output