Author Archives: gwilliams

Two more tools for your bag of T-SQL tricks

Have you ever been writing a new view and had the need to use an ORDER BY only to be greeted by an error message when you go to create the view. Never fear, there is a solution. ORDER BY can only be used in views, inline functions, derived tables, sub-queries, and common table [...]

Posted in Uncategorized | Comments closed

Adding CROSS APPLY to your bag of T-SQL tricks

Recently I found myself stuck on a problem while constructing a query for a stored procedure. Like any other developer when I get stuck I start looking through my “bag of tricks” to see if I can find something that will help me solve this problem, but this time I came up empty handed. That’s [...]

Posted in SQL Server, Tips and Tricks | Leave a comment

Intro into Behind the Scenes Managed Code with InfoPath

InfoPath is a great tool for creating simple and complex forms that can be easily managed and utilized. It is designed in such a way to try to make the process easy for non-programmers so that anyone can use the software to implement a form. This sometimes causes problems when you want to do a [...]

Posted in Uncategorized | Leave a comment

The Queue Manager solution to the Healthcare business

From my limited experience working for a client in the Health Care business I saw the magnitude of positive change the right solution can have on a problem. In the health care business it is often the case that patient information needs to be managed in such a way that it is easy to organize [...]

Posted in Uncategorized | Leave a comment

InfoPath, SharePoint and Outlook woes

InfoPath is a great tool already provided in the office suite since the 2003 edition. It allows you to relatively easily create data entry forms. They can be created from scratch, derived from a database or web service, they can be sent via email, published to SharePoint, used as a browser based form amongst many [...]

Posted in Uncategorized | Tagged | 1 Comment