hi..
this is my SP
USE
[TASKDB]GO
SET
GO
SET
GO
ANSI_NULLS ON QUOTED_IDENTIFIER ONALTER PROCEDURE [dbo].[GetCmtRpt]-- Add the parameters for the stored procedure here
@logid
AS
BEGIN
int
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT Date ,From_Name ,To_Name ,Todays_Task ,Tommorrows_Task ,Status,Comments,Date as months from TaskSheet inner join
END
i want to display the months field as jan feb mar based on date how to do...?
login on TaskSheet .loginID = login.loginID where login.loginID = @logid order by Date desc