Add inf a currency symbol to a calculated column

  • The question is in the title. The code is

    SELECT SalesLT.Product.Name




    ,SalesLT.Product.ListPrice - SalesLT.Product.StandardCost AS Profit

    ,SalesLT.ProductModel.Name AS SubCatNameType


    ,SalesLT.Product.Name AS SubCatName

    FROM SalesLT.Product INNER JOIN

    SalesLT.ProductModel ON SalesLT.ProductModel.ProductModelID = SalesLT.ProductModel.ProductModelID


    Many thanks

  • So, formatting? Personally, I'd recommend doing that on the front-end. Databases aren't the greatest at formatting.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply