declare @portalId int

--set this value to the portalId to report
--abandoned carts
set @portalId=0

select cast(floor(cast(c.datecreated  as float)) as datetime) as Date,
  count(distinct c.cartId) as Count
from {databaseOwner}[{objectQualifier}cvstore_cart] c
inner join {databaseOwner}[{objectQualifier}cvstore_cartItems] ci on c.cartId=ci.cartId
where portalId=@portalId
group by cast(floor(cast(c.datecreated  as float)) as datetime)
order by cast(floor(cast(c.datecreated  as float)) as datetime)