Unwrap Your Holiday Gifts - Up to 30% OFF Shop Now

Winter Webinars 2024 with Ian Barker Save Your Seat

RAD Studio 12.2 Now Available! Learn more

Ready to take your apps to the next level? Upgrade to Enterprise today. Contact sales

See What's New in RAD Studio 12.2 Athens Watch the Replay

Delphi 12 and C++Builder 12 Community Editions Released! Learn more

InterBase 2020 Update 6, released! Learn more

Discover The Getit Page

Deep discounts available on InterBase 2020 for OEM or VARs – Contact sales

Renew your Update Subscription license now Read more

Press Releases

SAN FRANCISCO — Aug. 14, 2013 — Embarcadero Technologies announced today it is hosting an online event titled "Common Table Expressions on SQL Server," featuring SQL Server expert Rick Morelan. Two separate sessions will be held on Aug. 20, 2013.

What:
Have you ever wanted to create a recursive query, but didn't see how to do it? What about finding and cleaning duplicates? Now you no longer have to cringe when asked to turn a self-join table into a tree path outline or level hierarchy.

Each of these goals is now just one query if you use a common table expression (CTE). Using a CTE offers the advantages of improved readability and ease in maintenance of complex queries.

Attendees will learn:

  • What is a CTE and how it compares to other subqueries
  • How a CTE can simplify complex subqueries
  • How to create outlines, tree paths, and hierarchies from a single query using CTEs

When:
Tuesday, Aug. 20, 2013
7:00 a.m. PT / 10:00 a.m. ET
11:00 a.m. PT / 2:00 p.m. ET

Where:
To register for the "Common Table Expressions on SQL Server," webinar, visit: http://forms.embarcadero.com/CommonTableExpressions_RickMorelan.

About the Presenter
Rick Morelan has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD, MOE, MCSE and MCSE+. His SQL certification in 2008 is the 4th generation of SQL certification in Implementation, Administration, and BI, which also includes (SQL 7.0, SQL 2000, SQL 2005, and SQL 2008.) As the author of the "SQL Joes 2 Pros" book and video series, the focus is upon delivering the most effective and relevant learning material. Rick has comprehensive real-world knowledge in the subjects to prepare you for real-world troubleshooting issues while backing it up with the IT certification.

About Embarcadero Technologies
Embarcadero Technologies, Inc. is a leading provider of award-winning tools for application developers and database professionals so they can design systems right, build them faster and run them better, regardless of their platform or programming language. Ninety of the Fortune 100 and an active community of more than three million users worldwide rely on Embarcadero products to increase productivity, reduce costs, simplify change management and compliance, and accelerate innovation. Founded in 1993, Embarcadero is headquartered in San Francisco, with offices located around the world. www.embarcadero.com

Press Contact:
Kristina Lanpheir
Kulesa Faul for Embarcadero Technologies
831-251-9120
This email address is being protected from spambots. You need JavaScript enabled to view it.

###