PeterLehmann

select ic.ItemCodeNo
, il.ItemLocalId
, i.ItemNo
, ru.RetailUnitNo
, pil.StartDate
, pil.EndDate
, pp.PromotionPOSNo
, pp.StartDateTime
, pp.EndDateTime
, promotionLineStatus.Code as "promotion line status code"

PolarbearDK

-- Change 0 to -1 yesterday, -2 day before, ect.
DECLARE @date DATETIME = DateAdd(Day, 0, GetDate());

DECLARE @startedLaterThan DATETIME = DateAdd(Hour, -18, @date);
DECLARE @businessDate DATE = DateAdd(Day, +1, CAST(@startedLaterThan AS DATE));

-- To see details about each store, remove (comment out) this summary header (up to "FROM ("), and footer (last two lines)
SELECT
	AccountingDate
	,"Store Type"

marcind

# Execute this in Nuget powershell console

get-project -all | %{ $_.Properties | ?{ $_.Name -eq "WebApplication.StartWebServerOnDebug"} | %{ $_.Value = $False } }

#