SQL Server Professionals,
The user group meeting is tomorrow Thursday October 20th.
Please join us for pizza and networking starting at 6:00 followed by our
presentation at 6:30.
Our presentation will be "Problem Solving with Common Table Expressions".
Are you looking for an easier way to de-duplicate your data? Do you need to
join a SELECT statement to itself six ways to Sunday? Common Table
Expressions (CTEs) can make these tasks (and many others) so much more
manageable, you'll wonder how you ever got along without them. CTEs are a
very useful method for abstracting data access in most of the popular
relational database platforms (MS SQL Server, Oracle, PostgreSQL, DB2). This
session will walk through syntax and implementation of CTEs in MS SQL
Server. We will then focus on their practical uses, including self-joins,
taking advantage of windowing functions, removing duplicates from data sets,
Phil Helmer has been working with relational databases for the last 10
years, the last half of that with SQL Server. He is particularly involved
with database design/development as well as integrating databases. He is
currently a Database Developer in San Diego, where his role includes helping
the staff stay up to date with the features in the SQL Server product. Phil
also has a degree in Management Information Systems from the University of
New Horizons Computer Learning Center
7480 Miramar Road Suite B202
San Diego, CA 92126
Detail directions to the building:
East on Miramar Road from the 805.
Turn left on Carroll Road at the Pyramid.
Turn right into the parking lot.
Suite B202 is upstairs in the last building on the left at the east end of
the lot above Greene Music.
See you there.
Phil Robinson - President SDSQLUG
[Non-text portions of this message have been removed]