Convert script(Oracle 10g to MSSQL 2005)

See more:

SQL-Server-2005

SQL-Server

Dear,
Please help me to get out from this problem.

FUNCTION Get_New_DISTRIBUTERID (a IN NUMBER)
   RETURN VARCHAR2
IS
   tmp_id   SM_DIVIDEND_BONUSDISTRIBUTER.DIVIDEND_DISTRIBUTER_ID%TYPE;
BEGIN
   SELECT   NVL (MAX (DIVIDEND_DISTRIBUTER_ID), TO_CHAR (SYSDATE, 'yymmdd') || '000000000000')
     INTO   tmp_id
     FROM   SM_DIVIDEND_BONUSDISTRIBUTER;

   IF SUBSTR (tmp_id, 1, 6) = TO_CHAR (SYSDATE, 'yymmdd')
   THEN
      RETURN TO_CHAR (tmp_id + 1, '000000000000000000');
   ELSE
      RETURN TO_CHAR (SYSDATE, 'yymmdd') || '000000000001';
   END IF;
END;

i need to convert in sql server 2005,it can be in sql function or procedure.

thanks in advance
Mahmud