vinnu
USE
GO
SET
ALTER PROCEDURE [dbo].[GetCmtRpt]-- Add the parameters for the stored procedure here@logid ASBEGINintSET NOCOUNT ON;-- Insert statements for procedure hereSELECT Date ,From_Name ,To_Name ,Todays_Task ,Tommorrows_Task ,Status,Comments,Date as months from TaskSheet inner joinENDi 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
@logid
AS
BEGIN
ENDi want to display the months field as jan feb mar based on date how to do...?