xxxxxxxxxx
DECLARE @deltaStartRowkey NVARCHAR(255) = (
SELECT PTP.pipelineTaskParameterValue
FROM dwhframework.dbo.pipelineTaskParameter PTP
WHERE PTP.pipelineTaskSID = @pipelineTaskSID
AND PTP.pipelineTaskParameterKey = 'deltaStartRowkey'
)
xxxxxxxxxx
select cart.Id, cart.UpdatedOnUtc,cart.CreatedOnUtc, cart.RentalEndDateUtc,cart.RentalStartDateUtc, map.Quantity,
cart.CustomerEnteredPrice,cart.AttributesXml,cart.ProductId,cart.CustomerId,cart.ShoppingCartTypeId,cart.StoreId
from AUR_ShoppingCart_WishList_Mapping map,ShoppingCartItem cart where cart.Id = map.ShoppingCartItemId and map.WishListId = '55'