SELECT 'Region 1' as [Entity],
[name].[dbo].[TableName$G_L Account$437].[No_] As 'GL Account'
,[name].[dbo].[TableName$G_L Account$437].[Name] As 'GL Name'
,CASE [name].[dbo].[TableName$G_L Account$437].[Account Type] WHEN 0 THEN 'Posting' WHEN 1 THEN 'Heading' WHEN 2 THEN 'Total' WHEN 3 THEN 'Begin-Total' WHEN 4 THEN 'End-Total' END As 'GL Account Type'
,CASE [name].[dbo].[TableNamee$G_L Account$437].[Income_Balance] WHEN 0 THEN 'Income Statement' WHEN 1 THEN 'Balance Sheet' End As 'Income/Balance'
,CASE [name].[dbo].[TableName$G_L Account$271].[Exclude from Provisional] WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' End As 'GL Excluded'
FROM [name].[dbo].[TableNamee$G_L Account$437]
JOIN [name].[dbo].[TableName$G_L Account$271] ON [name].[dbo].[TableName$G_L Account$437].[No_]=[name].[dbo].[TableName$G_L Account$271].[No_];
上面的代碼可以自己運行。但我想做以下事情：
SELECT 'Region 1' as [Entity],
[name].[dbo].[TableName$G_L Account$437].[No_] As 'GL Account'
,[name].[dbo].[TableName$G_L Account$437].[Name] As 'GL Name'
,CASE [name].[dbo].[TableName$G_L Account$437].[Account Type] WHEN 0 THEN 'Posting' WHEN 1 THEN 'Heading' WHEN 2 THEN 'Total' WHEN 3 THEN 'Begin-Total' WHEN 4 THEN 'End-Total' END As 'GL Account Type'
,CASE [name].[dbo].[TableNamee$G_L Account$437].[Income_Balance] WHEN 0 THEN 'Income Statement' WHEN 1 THEN 'Balance Sheet' End As 'Income/Balance'
,CASE [name].[dbo].[TableName$G_L Account$271].[Exclude from Provisional] WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' End As 'GL Excluded'
FROM [name].[dbo].[TableNamee$G_L Account$437]
JOIN [name].[dbo].[TableName$G_L Account$271] ON [name].[dbo].[TableName$G_L Account$437].[No_]=[name].[dbo].[TableName$G_L Account$271].[No_];
Union All
SELECT 'Region 2' as [Entity],
[name].[dbo].[TableName$G_L Account$437].[No_] As 'GL Account'
,[name].[dbo].[TableName$G_L Account$437].[Name] As 'GL Name'
,CASE [name].[dbo].[TableName$G_L Account$437].[Account Type] WHEN 0 THEN 'Posting' WHEN 1 THEN 'Heading' WHEN 2 THEN 'Total' WHEN 3 THEN 'Begin-Total' WHEN 4 THEN 'End-Total' END As 'GL Account Type'
,CASE [name].[dbo].[TableNamee$G_L Account$437].[Income_Balance] WHEN 0 THEN 'Income Statement' WHEN 1 THEN 'Balance Sheet' End As 'Income/Balance'
,CASE [name].[dbo].[TableName$G_L Account$271].[Exclude from Provisional] WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' End As 'GL Excluded'
FROM [name].[dbo].[TableNamee$G_L Account$437]
JOIN [name].[dbo].[TableName$G_L Account$271] ON [name].[dbo].[TableName$G_L Account$437].[No_]=[name].[dbo].[TableName$G_L Account$271].[No_];
任何人都可以在這里幫助使用聯合，因為我有 30 個區域要同時查詢
uj5u.com熱心網友回復：
如果每個查詢回傳具有相同資料型別的相同數量的列，則 UNION ALL 應該可以作業。
如果這是一個存盤程序或函式，您可能需要考慮 UNION ALL 是否是您的最佳選擇。您可以創建一個臨時表，將每個查詢中的資料檢索到該表中，然后從臨時表中選擇結果。
uj5u.com熱心網友回復：
只需洗掉;即可
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/422821.html
標籤：
下一篇：連接垂直和水平表