THANK you all

I really liked it..

here is what i did..

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

CREATE PROCEDURE InsertUser

 @User_Id  varchar(15),

 @UserName  varchar(50),

 @UserCatID  tinyint,

 @AllowBackEntry bit,

 @Description  varchar(50) =null, 

 @TransLimit  money =null,

 @teller   bit  ,

 @journal  bit  ,

 @vault   bit  ,

 @Entry   bit  ,

 @Verify   bit  ,

 @Post   bit  ,

 @Viewbalance  bit  

AS

INSERT INTO USERINFO

(User_Id

, UserName

, UserCatID

, AllowBackEntry

, [Description]

, TransLimit

, teller

,...