如何在SQL中将查询的未显眼部分放入粗体部分的子查询中 [英] How can bring unbold part of query in to subquery of bold part in SQL

问题描述

How can bring unbold part of query in to subquery of bold part in sql

当我试图收到错误时

when i trying to i am getting error as

Msg 116, Level 16, State 1, Line 23
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

我尝试过：

What I have tried:

Declare @DateFrom DateTime
Set @DateFrom='2018-08-01'
Declare @DateTo DateTime
Set @DateTo='2018-08-31'
   
  Select( 

    SELECT [Date],
       t.[Quantity],
       sum(t.[Quantity]) OVER(ORDER BY [Posting Date]) AS RunningTotal
FROM
  (SELECT( Select distinct [Date] from Calender where [Date]=ord.[Posting Date] )[Date], sum(ord.[Quantity]) [Quantity]
   FROM [Snowman Logistics Limited$Item Ledger Entry] ord
   INNER JOIN [Snowman Logistics Limited$Item] prod ON ord.[Item No_]=prod.No_ 
   where prod.[No_]='H1023038'
   and [Posting Date] <  @DateTo
   GROUP BY prod.No_,[Posting Date]  ) t 
   )
   from [Snowman Logistics Limited$Item Ledger Entry] where [Posting Date]between @DateFrom and @DateTo
   order By [Posting Date]

推荐答案

项目分类帐分录] ord
INNER JOIN [Snowman Logistics Limited

Item Ledger Entry] ord INNER JOIN [Snowman Logistics Limited

Item] prod ON ord。[Item No _] = prod.No_
where prod。[No _] ='H1023038'
和[Posting]日期]< @DateTo
GROUP BY prod.No _，[过帐日期]）t
）
来自[Snowman Logistics Limited

Item] prod ON ord.[Item No_]=prod.No_ where prod.[No_]='H1023038' and [Posting Date] < @DateTo GROUP BY prod.No_,[Posting Date] ) t ) from [Snowman Logistics Limited

项目分类帐分录] @DateFrom和@DateTo之间的[过帐日期]
顺序[发布日期]

Item Ledger Entry] where [Posting Date]between @DateFrom and @DateTo order By [Posting Date]

这篇关于如何在SQL中将查询的未显眼部分放入粗体部分的子查询中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！