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