Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    1

    Unanswered: Organize data by years and dept, please help, thanks

    Hi experts,
    I have a database with three queries of data named 2008,2009,2010. They are organized by varies department number. Is there anyway I can create a query with dept number sorted and different years data in different columns? like 1st column dept #, 2 column 2008 data associated with that dept #, etc? what is the sql for this thanks alot.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Can you show us the current SQL scripts?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •