query expression from access to sql server

See more:

SQL

MS-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

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

thanks
imrankhan