hojohappy
asked on
SQL Server Select SUM
I am getting error "datatype nvarchar(max) is invalid for sum...".
SELECT SUM([ProductTaxonomy.csv]. [YTD Sales Amount])
FROM [ProductTaxonomy.csv]
WHERE NOT EXISTS
(SELECT [Product Management.csv].[Product_C ode] FROM [Product Management.csv] WHERE [ProductTaxonomy.csv].[Pro duct Code] = [Product Management.csv].[Product_C ode])
SELECT SUM([ProductTaxonomy.csv].
FROM [ProductTaxonomy.csv]
WHERE NOT EXISTS
(SELECT [Product Management.csv].[Product_C
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
of course, doh! what was I thinking - sorry
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.