Browse by Tags

All Tags » SQL Basics for SMS Admins (RSS)
Sorry, but there are no more tags available to filter with.
Monday, March 12, 2007 10:45 PM

Download: Creating SMS Web Reports from SMS Queries

I had a couple different people e-mail me and say that they couldn't see the images for my "Creating SMS Web Reports from SMS Queries" blog posts. I thought...
Posted by bleary | 1 comment(s)
Filed under:
Monday, March 05, 2007 9:36 PM

Creating SMS Web Reports from SMS Queries - Part I

From SMS Query to SQL Query In the past, there have been some articles written on myITforum.com and also some forum posts describing how to use the smsprov...
Posted by bleary | 3 comment(s)
Filed under:
Monday, March 05, 2007 9:35 PM

Creating SMS Web Reports from SMS Queries - Part II

Using Query Analyzer In part one of this article series, we saw how to convert an SMS query to a SQL query, but when we tried to take the same SQL statement...
Posted by bleary | with no comments
Filed under:
Monday, March 05, 2007 9:34 PM

Creating SMS Web Reports from SMS Queries - Part III

Deciphering the SQL Query Part 2 of this series showed how to use the SQL 2000 Query Analyzer, what SQL tables are, and showed how to run a SQL query....
Posted by bleary | with no comments
Filed under:
Monday, March 05, 2007 9:33 PM

Creating SMS Web Reports from SMS Queries - Part IV

SQL Views In Part 3, we dismantled our SQL query and explained what it is doing and the logic behind it. In this article, we will be covering SQL views...
Posted by bleary | with no comments
Filed under:
Monday, March 05, 2007 9:32 PM

Creating SMS Web Reports from SMS Queries - Part V

Modifying the report to use views In Part 4, we defined what SQL views are and compared them with the tables. Now that you have all this SQL knowledge...
Posted by bleary | with no comments
Filed under:
Monday, March 05, 2007 9:31 PM

Creating SMS Web Reports from SMS Queries - Part VI

Selecting the Proper Column Names From the Views In Part 5, we replaced the table names with view names, and tidied up the query by removing the aliases...
Posted by bleary | with no comments
Filed under:
Monday, March 05, 2007 9:30 PM

Creating SMS Web Reports from SMS Queries - Part VII

Adding the SMS Site Code Column In Part 6, we learned how to use the errors in our query to use the correct column names in our views. In this article...
Posted by bleary | 1 comment(s)
Filed under: