关于量表之间取值

2019-05-13 05:02:04 245 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

现金流量表不平排查方法摘要针对现金流量表与资产负债表货币资金余额不平的问题，本文提出系统性排查方法：1.计算差额，确定目标金额；2.检查基础钩稽关系，确保报表平衡；3.分块测试三大活动现金流量；4.运用"凑数法"、"除二法"等技巧定位差异；5.核对常见易错点清单。通过五步法系统排查，可快速发现并解决报表不平衡问题。阅读详情

a表，数据列表
cus, item, date，price
c001,i001,2019-01-01
c001,i001,2019-01-02
c001,i001,2019-01-03
c001,i001,2019-01-04
c001,i001,2019-01-10
c001,i001,2019-02-01
c002,i001,2019-02-02
c002,i001,2019-03-01
c002,i002,2019-03-01
c002,i002,2019-03-03

b表，为单价列表
cus, item, date, price
c001,i001,2019-01-03,100
c001,i001,2019-02-04,101
c002,i001,2019-02-10,200
c002,i001,2019-03-10,201
c002,i002,2019-03-02,202

条件
1，取对应b表中日期在a表中记录日期之后的最靠近单价
2，当b表中的日期比a表中的记录日期旧的，取最新的单价

例如
cus, item, date，price
c001,i001,2019-01-01，100
c001,i001,2019-01-02，100
c001,i001,2019-01-03，100
c001,i001,2019-01-04，101
c001,i001,2019-01-10，101
c001,i001,2019-02-01，101
c002,i001,2019-02-02，200
c002,i001,2019-03-01，201
c002,i002,2019-03-01，202
c002,i002,2019-03-03, 202

...全文

问卷与量表的本质区别：如何设计有效测量工具并验证信效度在用户研究、市场调研和心理学评估中，数据收集工具的设计至关重要。问卷作为一种通用工具，主要用于收集事实、行为和观点等描述性信息，其核心在于问题的清晰性和覆盖全面性。而量表则是一种精密的心理测量工具，专门用于量化抽象的构念，如态度、满意度或人格特质，其设计强调题项的内在关联性和结构性。为了确保测量结果的可靠性和准确性，必须对量表进行信度与效度检验。信度关注测量的一致性，常用克隆巴赫α系数评估内部一致性；效度则检验测量的是否是目标构念，涉及内容效度、结构效度（通过探索性与验证性因子分析验证）和效标效度。掌握问卷阅读详情

zhouguoguang

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

zhouguoguang 2019-05-16

打赏
举报

不好意思，说反了或者可能我说的不够清晰，a表中的日期大于，b表中的日期，取b表中的price，我就以单个cus和单个item为例子 a表，数据列表 cus, item, date，price c001,i001,2019-01-01 c001,i001,2019-01-02 c001,i001,2019-01-03 c001,i001,2019-01-04 c001,i001,2019-01-10 b表，为单价列表 cus, item, date, price c001,i001,2019-01-01,100 c001,i001,2019-01-04,101 结果 cus, item, date，price c001,i001,2019-01-01 100 c001,i001,2019-01-02 100 c001,i001,2019-01-03 100 c001,i001,2019-01-04 101 c001,i001,2019-01-10 101

zhouguoguang 2019-05-16

打赏
举报

或者可能我说的不够清晰，a表中的日期大于，b表中的日期，取b表中的price，我就以单个cus和单个item为例子 a表，数据列表 cus, item, date，price c001,i001,2019-01-01 c001,i001,2019-01-02 c001,i001,2019-01-03 c001,i001,2019-01-04 c001,i001,2019-01-10 b表，为单价列表 cus, item, date, price c001,i001,2019-01-03,100 c001,i001,2019-02-04,101 结果 cus, item, date，price c001,i001,2019-01-01 100 c001,i001,2019-01-02 100 c001,i001,2019-01-03 100 c001,i001,2019-01-04 101 c001,i001,2019-01-10 101

RINK_1 2019-05-16

打赏
举报

引用 3 楼 zhouguoguang 的回复:

不好意思，说反了或者可能我说的不够清晰，a表中的日期大于，b表中的日期，取b表中的price，我就以单个cus和单个item为例子 a表，数据列表 cus, item, date，price c001,i001,2019-01-01 c001,i001,2019-01-02 c001,i001,2019-01-03 c001,i001,2019-01-04 c001,i001,2019-01-10 b表，为单价列表 cus, item, date, price c001,i001,2019-01-01,100 c001,i001,2019-01-04,101 结果 cus, item, date，price c001,i001,2019-01-01 100 c001,i001,2019-01-02 100 c001,i001,2019-01-03 100 c001,i001,2019-01-04 101 c001,i001,2019-01-10 101

试试下面这个


SELECT A.*,B.PRICE FROM TABLE_A A
OUTER APPLY
(SELECT TOP 1 PRICE FROM TABLE_B WHERE A.CUS=CUS AND A.ITEM=ITEM AND DATE<=A.DATE ORDER BY DATE DESC) AS B

RINK_1 2019-05-13

打赏
举报



SELECT A.*,ISNULL(B.PRICE,C.PRICE) FROM TABLE_A A
OUTER APPLY
(SELECT TOP 1 PRICE FROM TABLE_B WHERE A.CUS=CUS AND A.ITEM=ITEM AND DATE>=A.DATE ORDER BY DATE) AS B
OUTER APPLY
((SELECT TOP 1 PRICE FROM TABLE_B WHERE A.CUS=CUS AND A.ITEM=ITEM AND DATE<A.DATE ORDER BY DATE DESC) AS C

关于量表之间取值

相关推荐