ALTER procedure [dbo].[IBS_PodiumSummeryCount]
   @locid integer = null
as
begin
    SET NOCOUNT ON;

    SELECT
       sum(status_receved) as Receved,
       sum(status_parked) as Parked,
       sum(status_requested) as Requested,
       sum(status_requestedinprocess) as Requestinprocess
    FROM
       (SELECT
            CASE WHEN (status = 0 ) THEN 1 ELSE 0 END AS status_receved,
            CASE WHEN (status = 2) THEN 1 ELSE 0 END AS status_parked,
            CASE WHEN (status = 3) THEN 1 ELSE 0 END AS status_requested,
            CASE WHEN (status = 4) THEN 1 ELSE 0 END AS status_requestedinprocess
        FROM
            transaction_tbl
        WHERE
            locid = @locid AND dtime >= getdate()-1 AND status IN (0,2,3,4)) a;

    SELECT
       l1.StartTime, CONVERT(VARCHAR, GETDATE(), 108) AS Time
    FROM
       Location_tbl l1
    WHERE
       l1.Locid = @locid
END

select  dbo.podiumsummerytime(
                convert(decimal(10,1),
                    avg(convert(numeric(18,2), datediff(ss, t.dtime, t.PAICdate  ))))

            ) as Avgparkingtime,
           dbo.podiumsummerytime(
                convert(decimal(10,1),
                    avg(convert(numeric(18,2), datediff(ss, t.Paydate, t.DelDate ))))

            ) as AvgDelivarytime,
            dbo.podiumsummerytime(
                convert(decimal(10,1),
                    avg(convert(numeric(18,2), datediff(ss, t.dtime, t.DelDate ))))

            ) as Avgstaytime

            from (select top 30 * from transaction_tbl where locid=@locid and dtime >= getdate()-2 order by transactID desc ) t
            end

ALTER procedure [dbo].[IBS_PodiumSummeryCount]
    @locid integer = null
AS
BEGIN
    SELECT * FROM Customers WHERE Location = @Locid;

    SELECT * FROM Suppliers WHERE Location = @Locid;
END