Database

H JJ wrote:

How could I resolve this issue?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

A persisted column, that'd be a computed/calculated field? Are you sure that's a
good idea to use as a primary key?

SELECT DATEPART(YEAR,trans_date) AS 'Year',DATEPART(wk,trans_date) AS 'Week #',MIN(DATEADD(wk, DATEDIFF(wk,0,trans_date), 0)) AS 'Week date',   SUM(COALESCE(debit,0)) AS 'Debits', SUM(COALESCE(credit,0)) AS 'Credits' FROM trans GROUP BY DATEPART(YEAR,trans_date),DATEPART(wk,trans_date)ORDER BY 1,2;

HARI JJ wrote:

Getting error

CREATE FUNCTION func_check_seat_availability
( 
@in_bUS_No int, 
@in_DateOfJourney datetime, 
@in_NoOfAdults int, 
@in_NoOfChildren int
) 
RETURNS decimal(36,30)
AS 
BEGIN 
--considering 64 is the total count of bus
declare @value decimal(36,30)
 select 
@value=case when sum(@in_NoOfAdults+@in_NoOfChildren) >= 34 then 0 
when sum(@in_NoOfAdults+@in_NoOfChildren) < 14 then 1 
end
from Details where BusNo=@in_bus_No and DateOfJourney=@in_DateOfJourney
return @value
END

RETURN CAST(CAST(CONVERT(float, @parPercentageToBeFormatted) * 100 AS decimal(5, 1)) AS nvarchar(5)) + N'%'