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 that it might just be due to the page taking...
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.log file to convert SMS queries to SQL queries...
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 and make it a web report it returned a ‘permissions...
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. In Part 3 we will look at each line of the 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. What are SQL Views? SQL Views are predefined SQL...
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 in that big brain of yours, we can finally start converting...
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. When we ran the query, there were several errors...
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, we will add the SMS Site Code to the report. Out...
Posted by bleary | 1 comment(s)
Filed under: