vinnu

vinnu

  • NA
  • 61
  • 202k

how to display the months based on date

Feb 23 2011 1:59 AM
hi..
this is my SP

USE

[TASKDB]

GO


SET

GO

SET

GO

ANSI_NULLS ON QUOTED_IDENTIFIER ON

ALTER 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




Answers (3)