SET NOCOUNT ON
DECLARE @DOCUMENTNO VARCHAR(20)  = '8508569';
DECLARE @MAKEDOW VARCHAR(1) 
SET @MAKEDOW        = DATEPART(WEEKDAY,(SELECT [Make Date] FROM [Kitchen Fresh Foods$Sales Header Import] WHERE [Document No_] = @DOCUMENTNO and [document type]= 1))
SELECT @MAKEDOW