|
|
6#
楼主 |
发表于 2016-3-9 17:59:34
|
只看该作者
INSERT INTO @Forms(PermissionID, ReportID)
SELECT p.PermissionID, r.ReportID FROM (SELECT PermissionID FROM Permission WHERE DisplayText = 'View Project Board') p CROSS JOIN (SELECT TOP 1 ReportID FROM ReportOffice WHERE ReportPrintOptionID = @ContractSalesInvoice) r
|
|
发表于 2016-3-2 13:13:57
收藏
支持
反对
