hojohappy
asked on
SQL Server Select CAST and SUM
I need to change the CAST of column and also SUM the column. How can I do this?
SELECT CAST([ProductTaxonomy.csv] .[YTD Sales Amount] AS numeric) as Total
FROM [ProductTaxonomy.csv]
INNER JOIN [Product Management.csv] ON [ProductTaxonomy.csv].[Pro duct Code] = [Product Management.csv].[Product_C ode]
SELECT CAST([ProductTaxonomy.csv]
FROM [ProductTaxonomy.csv]
INNER JOIN [Product Management.csv] ON [ProductTaxonomy.csv].[Pro
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.