My database is SQL and i am using a stored procedure as under. The output is almost correct and i want to rectfy a small error in it
ALTER PROCEDURE [dbo].[Report](
@year int,
@month int
)
AS
BEGIN
SET NOCOUNT ON
declare @d smalldatetime
declare @total int
set @d = CAST(CAST(@year AS varchar) + '-' + CAST(@month AS varchar) + '-1' as smalldatetime)
set @total=datediff(day, @d, dateadd(month, 1, @d))
declare @R_perday decimal(18, 3)
set @R_perday=
case
when @total=31 then 2.47
when @total=30 then 2.55
when @total=29 then 2.64
when @total=28 then 2.73
end
;WITH
L0 AS (SELECT 1 AS c UNION ALL SELECT 1),
L1 AS (SELECT 1 AS c FROM L0 A CROSS JOIN L0 B),
L2 AS (SELECT 1 AS c FROM L1 A CROSS JOIN L1 B),
L3 AS (SELECT 1 AS c FROM L2 A CROSS JOIN L2 B),
L4 AS (SELECT 1 AS c FROM L3 A CROSS JOIN L3 B),
Nums AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS i FROM L4)
select PNO, Name, ...
Go to the complete details ...