IT Professional

GPUG

ITP09 - SQL Commands for Experienced Users

Thursday, October 12
11:15 AM - 12:15 PM
Location: Canal E - Delta Mezzanine Level M

Format: How2
Level: Advanced
CPE: 1
Version: Any

This session would explain how to use some of the more advanced SQL statements that can make reporting from the GP data model much better. The statements proposed are PIVOT, PARTITION by, OVER, COALESCE, and UNION. While each statement provides specific benefits, overall, you'll be able to take a vertically organized data set and represent it horizontally.

Learning Objectives:




Leslie Vail

President
ASCI, Inc

Leslie Vail is a Microsoft Dynamics GP MVP. She has been working as a Microsoft Dynamics GP consultant since its beginning in 1993 with release 1.0. She presents sessions at many partner and customer conferences and conducts training classes throughout North and Central America.
Leslie has been recognized throughout the industry for her product expertise and the contributions she makes to the Dynamics GP Community. She has authored two books and shares her expertise with other authors as a technical editor.
Leslie is a passionate supporter of Dynamics GP with unbridled enthusiasm for getting new users and consultants off to the right start.

Presentation(s):

Send Email for Leslie Vail


Assets

SQL Commands for Experienced Users



Attendees who have favorited this

Send Email for SQL Commands for Experienced Users