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.
Tag :list view
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 are a great way to review data. In the first part of this …
Avoiding an “Invalid Property Array Index” Error
In 5 (Often Forgotten) Productivity Tools I mentioned that List Views are a great way to review data. However, the TMS interface expects the SQL view to return only one row per selected record. If your table joins create more than one row per record, then TMS will truncate the SQL view results. If your …
5 (Often Forgotten) Productivity Tools in TMS
Schools are closing, and temperatures are rising: Summer is arriving. As end-users are preparing to leave for the traditional family vacation, here are five (often forgotten) tools to help them work smarter.