Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by fcaldero

  1. fcaldero

    PIVOT Function in SQL Statement

    Thanks markros. Your approach helped get the table I needed. I ended doing a view and from the view used your logic to get the %of Test-Totals. Good suggestions.
  2. fcaldero

    PIVOT Function in SQL Statement

    Hello - Have a SQL where a PIVOT function creates the following: test_number SHIFT1 SHIFT2 SHIFT3 9000 4 3 0 9002 10 8 0 9008 2 2 0 9010 2 0 0 I would like to add a TOTAL colum and Row where I...
See more

Part and Inventory Search

Back
Top