Thanks Mahesh

Your code did not work as what I wanted to be. Anyway, I figured it out with someone's help.

CREATE PROCEDURE Get_userstatus_firstandlastlogday_month

@User_ID varchar(50),

@Year int,

@Month int

AS

declare @errorcode int

SET NOCOUNT ON

SELECT a1.User_ID,...