• gurjer48 (4/2/2013)


    WHAT THE TABLE CREATED IS I HAVE ...I JUST WANT TO

    DISPLAY

    IT,MARKETING COLUMNS UNDER WHICH THE PERSONS NAME BELONGING TO THAT DEPARTMENT SHOULD COME...

    GROUPING PERSONS UNDER SAME DEPARTMENT.

    First of all please turn off the caps lock. All caps is considered yelling and it is difficult to read.

    The problem we have here is that we don't know your project, we don't know your data structures, we don't know what you are trying to do and we can't see your screen.

    Is the data that I posted an accurate depiction? If so, what should the output look like? I am willing to help but you have to help me understand what the problem is.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/