I have this code:
dbo.Invoice.InvoiceDate, COUNT(*) AS [Order QTY],
It works well in my View, however I want to build an expression from it like this:
dbo.Products.CartonCount * 'dbo.Inventory.BoxId:OrderQty' AS TotalPieces,
When I try to run it however I get this error:
error converting data type varchar to real
Can anyone help me understand why?