Chad Petrovay

Tag: SQL View

  • Select Top 3 * From [Uses for Select]: Part 2

    Select Top 3 * From [Uses for Select]: Part 2

    In Part 1, we examined how to use the SELECT statement in SQL to create a SQL View that can be used in Crystal Reports for reporting. There are two additional uses for the SELECT statement, which make learning its syntax an invaluable tool for database administrators. (more…)

  • Select Top 3 * From [Uses for Select]: Part 1

    Select Top 3 * From [Uses for Select]: Part 1

    People generally ask me about resources for learning SQL. SQL is a great language for any database administrator to learn, because it gives you full control of the data, without limiting you to an application’s graphic user interface (GUI). With SQL you can query for records, and add, edit or remove them. This post is not meant as a tutorial on the subject, because great resources, like SQLzoo or O’Reilly’s , already exist. Instead, in this series of posts, I want to highlight why the SELECT statement is the most important of these. (more…)

  • Accessioning Clean-up: Part 1

    Whether you are launching a data cleanup project or simply want to verify that standards are being followed, there are times you want to be able to quickly and easily manage your data. In 5 (Often Forgotten) Productivity Tools I mentioned that List Views are a great way to review data. In the first part of this tutorial, we’ll design a List Views to help with a project to clean-up accessioning information. (more…)

  • Text Entries in a Single View

    Text Entries in a Single View

    If you’re anything like me, you probably have a stack of SQL views just to simplify report writing. Since text entries are so pervasive to TMS’s operation, I find that I am constantly making use of them in various Crystal Reports. Here’s a time-saver: a SQL view that combines the four tables used for controlling text entries and handling notes.

    (more…)