Post reply

common table expression(cte)--query

  • November 17, 2010 at 4:35 am

    #141440

    hi everyone,

    i m working on a query related common table expression.my doubt is i got the results but i needed the result which combines the two coloumns in single coloumn

    and also

    the parent s corresponding childs must be displayed in a coloumn.

    please anyone can suggest me ,can i use joins or any other concepts before CTE result or after?????

  • November 17, 2010 at 4:44 am

    #1251814

    It is very hard to understand your question. Pleas fallow the URL in my signature to see how to write a question. If you’ll fallow the direction at that article, you’ll get answers much faster.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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