本帖最后由 SylvestreLee 于 2022-11-16 11:45 编辑
试了 写死都取不出来内容 其他两个数据集都正常出数据 我把数据表结构和数据导出来放到附件吧
- exec sp_executesql N'Select
- F_CostDate as 费用日期,
- F_CostExplain as 事由,
- (Select F_Name From Zgy_Cost_BudgetSubject Where F_Id = F_CostSubjects) as 费用科目,
- F_SubjectsSurplus as 可用余额,
- F_Amount as 报销金额,
- F_TicketQuantity as 票据张数,
- F_Notes as 备注
- From Zgy_XM_ExpenseAccountdetail Where F_id = @F_ID',N'@F_ID nvarchar(36)',@F_ID=N'0803fc04-cecd-416c-80e6-5a6f9fee635a'
复制代码
|