TWBit
asked on
TRANSFORM, PIVOT - implement in SQL
Here is my access query:
TRANSFORM Sum(tblBudgetAmount.LocalA mount) AS SumOfFunctionalAmount
SELECT tblBudgetItem.CostCenterID , tblBudgetItem.GL as GL1,tblBudgetItem.ProjectI D,
Sum(tblBudgetAmount.LocalA mount) AS ColumnTotal, tblAcctCode_0.sStatus
FROM tblAcctCode_0
INNER JOIN (tblBudgetItem
INNER JOIN tblBudgetAmount ON tblBudgetItem.ID = tblBudgetAmount.BudItemID)
ON tblAcctCode_0.sCodeID = tblBudgetItem.GL
Where tblBudgetItem.CostCenterID ='385' and tblBudgetItem.ProjectID='1 537'
and left(tblBudgetItem.GL,2) like '62' and tblBudgetItem.ActivityID=' 50770'
and tblBudgetItem.FundID='10' and tblBudgetAmount.FiscalYear ='2005'
GROUP BY tblBudgetItem.GL, tblBudgetItem.CostCenterID , tblBudgetItem.ProjectID, tblBudgetItem.GL, tblAcctCode_0.sStatus PIVOT tblBudgetItem.FundingSourc e
How would I go about converting this to SQL?
TRANSFORM Sum(tblBudgetAmount.LocalA
SELECT tblBudgetItem.CostCenterID
Sum(tblBudgetAmount.LocalA
FROM tblAcctCode_0
INNER JOIN (tblBudgetItem
INNER JOIN tblBudgetAmount ON tblBudgetItem.ID = tblBudgetAmount.BudItemID)
ON tblAcctCode_0.sCodeID = tblBudgetItem.GL
Where tblBudgetItem.CostCenterID
and left(tblBudgetItem.GL,2) like '62' and tblBudgetItem.ActivityID='
and tblBudgetItem.FundID='10' and tblBudgetAmount.FiscalYear
GROUP BY tblBudgetItem.GL, tblBudgetItem.CostCenterID
How would I go about converting this to SQL?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.developersdex.com/gurus/code/826.asp