You must Sign In to post a response.
  • Category: SQL Server

    In stored procedure"[[color:black][price:45.00][quantity:8]]"how to get it

    iam having columns like color ,price,quantity i want to join in one place

    "[[color:black][price:45.00][quantity:8]]" in stored procedure
  • #762063
    Hi
    Dinesh

    Can you explain more or share your stored proc and table structure and send me.


    What is output?

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #762066
    SELECT

    P.ProductId,
    P.ProductTitle,
    c.colourname,
    P.Description,
    P.ListingType,
    P.Brand,
    P.Stock,
    P.ProductCode,
    pd.Colour,
    pd.EAN,
    pd.USPrice,
    pd.USSize,
    pd.stockonhand

    FROM
    tblProducts P
    INNER JOIN tblproductdetails pd on p.ProductId = Pd.ProductID
    INNER JOIN tblcolours c on pd.Colour = c.ColourId
    and p.productid=12981 and c.SiteId=12981

  • #762078
    Hi,

    Not able to understand your question. Can you please explain what exactly you are looking for?
    I can see that you already joined multiple tables!


    Regards,
    Asheej T K
    Microsoft MVP[ASP.NET/IIS]
    DotNetSpider MVM


Sign In to post your comments