用于SQL过程的PIVOT表 [英] PIVOT table for SQL procedures
问题描述
我有程序表并且要求在程序表中添加一个数据透视功能,根据我试图添加一个Pivot函数来获取一个部门代码明智地反对'CurrentPeriod'数量,但它的语法错误,你能支持
来解决这个问题,作为参考,我已经在Midiafire共享位置上传了该查询文件。请在Mediafire共享位置网址下方进行操作,并获取当前查询。
I have procedure table and have requirement add a pivot function to procedure table, According to i'm tried to add a Pivot function to get a Department code wise against 'CurrentPeriod' Amount, but its getting syntax error, Can you please support to sort out this my concern, for your reference i have uploaded that query file on Midiafire share location. please follow up below Mediafire share location URL and get the current query.
查询共享位置 - :
https://www.mediafire.com/file/edqmik43izc2dcl/PROCEDURE.txt/file
推荐答案
嗨团队,
任何人都可以支持吗? ,你的支持非常感谢。
Anybody can support on this?, your support much appreciate.
谢谢
Mahesh
这篇关于用于SQL过程的PIVOT表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!