通过访问SQL Server查询表达式 [英] query expression from access to sql server

问题描述

我在Access数据库中有一个表，如下所示.

I have a table in access database like as following way.

I_WHSE,   I_PART_NO,     FIELD_NAME,	MASK
00        001            INCRQTY        5
00        002            MAXQTY         10
00        003            METATITLE      6
00        004            MINQTY         1
00        005            NOTIFYQTY      6

我想从访问查询中在SQL Server中编写透视查询，如下所示

这是访问查询

I want to write pivot query in sql server from access query as below

This is access query

TRANSFORM First(INVE_WB_MASK.MASK) AS FirstOfMASK
SELECT INVE_WB_MASK.I_WHSE, INVE_WB_MASK.I_PART_NO
FROM INVE_WB_MASK
GROUP BY INVE_WB_MASK.I_WHSE, INVE_WB_MASK.I_PART_NO
PIVOT INVE_WB_MASK.FIELD_NAME;

返回结果:

RETURN RESULT:

COLUMNS:	I_WHSE, I_PART_NO, INCRQTY, MAXQTY, METATITLE, MINQTY, NOTIFYQTY

谢谢
imrankhan

thanks
imrankhan

推荐答案

尝试一下

try this

select * from INVE_WB_MASK
pivot (avg(mask) for Field_name in (INCRQTY, MAXQTY, METATITLE, MINQTY, NOTIFYQTY)) as A 

这篇关于通过访问SQL Server查询表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！