let
 
       DateBegin = DateTime.ToText( Excel.CurrentWorkbook(){[Name="DateBegin"]}[Content]{0}[Column1], "yyyy-MM-dd"),
    DateEnd = DateTime.ToText( Excel.CurrentWorkbook(){[Name="DateEnd"]}[Content]{0}[Column1], "yyyy-MM-dd"),
 ConnectionString ="
WITH NEWSUM AS(
Select
   (m.StockID) AS StockID,
CAST(m.DocDate as date) AS DocDate, 
(DATEPART(hh,m.DocTime)) AS Hour ,
(DATEPART(yyyy,m.DocTime)) AS Year,
DATENAME(Month,m.DocTime) AS Month
 
from t_Sale m With(NoLock)
   Inner Join t_SaleD d With(NoLock) On d.ChID = m.ChID
                   
where 
m.StockID not in (102,115,116)
and ((m.DocDate Between '" & DatePre & "' and '" & DatePre2 & "') or (m.DocDate Between '" & DateBegin & "' and '" & DateEnd & "') )
                                     
GROUP BY m.StockID, m.DocDate, m.DocTime, c.PcatName, g.PGRName, g1.PGRName1,
 g3.PGRName3, g7.PGrName7, ga.PGrAName

 ConnectionString ="   set language russian 
WITH NEWSUM AS(


Select
	(m.StockID) AS StockID,
CAST(m.DocDate as date) AS DocDate, 
		(DATEPART(hh,m.DocTime)) AS DocTime ,

       (c.PcatName) as PcatName,
  (g.PGRName) AS PGRName,
	(g1.PGRName1) AS PGRName1,
  (g3.PGRName3) AS PGRName3,
  (g7.PGrName7) AS PGrName7,
  (ga.PGrAName) AS PGrAName, 
   
 SUM(d.Qty) AS Qty,
   SUM(0) AS QtyV,
SUM(d.SumCC_wt ) AS SumK,
Sum(0) AS SumKV,
(DATEPART(yyyy,m.DocTime)) AS Year,
DATENAME(Month,m.DocTime) AS Month

"Преобразование типа данных varchar в тип данных smalldatetime привело к выходу значения за пределы диапазона."

let
 ConnectionString =" set language russian;
WITH NEWSUM AS(
Select
DATENAME(Month,m.DocTime) AS Month
from t_Sale m With(NoLock)
	Inner Join t_SaleD d With(NoLock) On d.ChID = m.ChID
 						
UNION ALL
	Select 
DATENAME(Month,m.DocTime)
from t_CRRet m With(NoLock)
	Inner Join t_CRRetD d With(NoLock) On d.ChID = m.ChID
	
SELECT 

a.Month as Месяц
FROM NEWSUM a

 ConnectionString =" set language russian;
WITH NEWSUM AS(

Select
DATENAME(Month,m.DocTime) AS Month
format(m.DocTime, 'MMMM', 'ru-RU')

ConnectionString ="set language russian; SET DATEFORMAT ymd;
WITH NEWSUM AS(