Database

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'%'

SELECT  isnull(lb.somefield,vb.anotherfield) as columnname
FROM    mtblVehicle_Booking vb
LEFT JOIN mtblLog_Book lb
ON vb.Sno = lb.Sno

select ISNULL(LogBook, Vehcile_Booking) from ..