JSFiddle - React, Tailwind, and code Playground

by Ravichandra Thota

JavaScript

CREATE PROCEDURE [dbo].[getHomespaceCollectionFromPersnum]
(
	@custodianId varchar(50)
)
AS
Begin
DECLARE
@EfilesSize float =0

SET @EfilesSize=(select CAST(ROUND(Sum(es.sizefield)/1048576,2)as decimal(10,2)) as AggregateHomeSpaceSize
				 from estimateRequestSummary es
				 inner join
				 estimateReuest e
				 on e.RequestID=es.RequestID
				 inner join 
				 caseAssoc ca
				 on ca.assocID=e.assocID
				 inner join dbo.caseAssocCase cac
				 on ca.assocID=cac.assocID
				 inner join caseassocdatatypeevidence cadte
				 on cadte.caseAssocID=cac.caseAssocID
				 inner join
				 ev.evidenceObject eo
				 on eo.evidenceID=cadte.evidenceID
				 inner join casedatadtype cd
				 on cd.DataTypeID=eo.DataTypeID
				 where persNum=@CustodianId and es.sizefield is NOT NULL and 
				 (select count(*) from evidenceobject where	
				 		originalassocid=ca.assocID and cd.abbrev="HS" and collectionDate< DATEADD(DAY, -5, GETDATE())!=1 )

	Select @EfilesSize;
	END