DSLUG is the only event exclusively for Dynamics SL users, partners, and solution providers and you won’t want to miss it. With over 124 sessions in four days, you’ll have the opportunity to explore solutions and gain a deeper understanding of Dynamics SL. No matter how experienced you are or what version you’re using, you’re guaranteed to walk away with valuable tools and connections that you can leverage all year.
Back To Schedule
Wednesday, April 17 • 10:15am - 11:45am
SQL 401 - Expert SQL queries

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Supercharge your advanced knowledge of T-SQL by learning techniques like dynamic SQL, the FOR XML clause, and advanced JOINs. We will cover some of the newer SQL Server functions such as TRY_CONVERT and FORMAT. All examples will be practical code using the Dynamics SL schema. We will also demonstrate some methods to make your SQL code perform better, including temporary intermediate tables, speed testing, and recasting. If you liked the SQL 301 session, you should be ready for SQL 401.
CPE learning objective: Learn some expert techniques to use with SQL queries.

avatar for Jonathan Van Houtte

Jonathan Van Houtte

System Architect, XLstatements
I have been a Dynamics SL consultant for more than 30 years. I also consult on SQL Server and Excel. I am the principal designer ("System Architect") of the XLstatements for Dynamics SL financial reporting application.

SQL401 sql
SQL 401 pptx

Wednesday April 17, 2019 10:15am - 11:45am PDT
Elite 1