CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


How to Un-Pivot Data

by Emma Tsai
In my last blog, I talked about how to use PIVOT operator to group and aggregate data in SQL database. Today, I am going to share how to Un-pivot data.
The starting point is some pivoted data. I used a sample table called Sales.FreightTotals as an example. The sample data shows as below:
Pivot table...
    Read More »

    On October 1, 2014 in General [Post:by] Comment 0
    Tagged With: data management, Pivot / 2106 Views

    Use Pivot Operator to Pivot Data

    By Emma Tsai
    Performing functional testing for software applications is part of the job as a business analyst. Occasionally, I need to work with SQL server to do database queries so that I can verify that the application pulls data results as expected. Recently, I learned how to use PIVOT operator to group and aggregate data in SQL database. Here is how it works:
    In pivot queries, here are the thr...
    Read More »

    On August 27, 2014 in Development, Project Management, Web Development [Post:by] Comment 0
    Tagged With: query, SQL, Pivot / 3289 Views

    How to Transpose a Data Table in Sage 300 ERP Take 2

    By Kristi Feng
    Several weeks ago Sheila showed how to transpose GLAFS from columns to rows.
    Sometimes there is also a need to transpose rows to columns.  For example, we want to see item quantities for a year in a row we can use the following SQL with ICHIST table.
     
    The following two Transact...
    Read More »

    On July 9, 2013 in General [Post:by] Comment 0
    Tagged With: Sage 300 ERP, MS SQL, Pivot, Tips and Tricks / 4211 Views

    How to Transpose a Data Table in Sage 300 ERP

    By Sheila Zhang
    GLAFS table is my favorite data table in the Sage 300 ERP database. It was designed to list all fiscal periods of a fiscal year with 15 fields or columns. Here are two ways to transpose the period’s columns to rows.
    Method 1:

    Method 2:
    ...
    Read More »

    On June 14, 2013 in Products [Post:by] Comment 0
    Tagged With: transpose, GLAFS, Pivot, Sage 300 ERP / 3493 Views

    Search

    Categories

    • General (166) rss
    • Development (158) rss
    • Success Stories (40) rss
    • Products (29) rss
    • Uncategorized (18) rss
    • BTerrell Group (5) rss
    • Project Management (22) rss
    • Web Development (57) rss
    • Web application (33) rss
    • Integration (19) rss
    • Mobile Development (7) rss

    Archives

    • 2015
      • January (5)
      • February (7)
      • March (6)
      • April (5)
      • May (2)
    • 2014
      • January (13)
      • February (12)
      • March (13)
      • April (12)
      • May (11)
      • June (12)
      • July (11)
      • August (13)
      • September (10)
      • October (8)
      • November (6)
      • December (4)
    • 2013
      • April (73)
      • May (22)
      • June (20)
      • July (20)
      • August (22)
      • September (19)
      • October (13)
      • November (12)
      • December (7)

    Tags

    .NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
    ABOUT US / CONTACT US / NEWS & EVENTS
    CodePartners / 17250 Dallas Parkway, Ste. 225 / Dallas, Texas 75248 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
    © 2006 - 2015 codepartners.com All Rights Reserved.