November 2009 Entries
[Update: 2009-12-30] We got it working using SSIS. Read this post: http://geekswithblogs.net/L... [Original post] Would love to know if there is a way to kick off a SSRS report and pass some parameters into it via T-SQL or SSIS. Unfortunately, we can't have MS SQL Enterprise edition. Guess this is the true list of possible solutions: VB script PowerShell WMI script batch file T-SQL Sad thing is I know how to make this ......
Business scenario: We have an XML file (HIPAA 837) saved as a XML data column in a table and we need to go through each row and get different information on different nodes and output to a table. The real reason of this design lies in with how the claim system is designed, which I will not try to explain here. Approach: Using Common Table Expression (CTE) to get all the necessary info so that the data can be joined later. Use ROW_NUMBER() to make sure the information comes from the correct line. ......
There have been many occasion when I try to kill iexplorer.exe process and the browser came back. Now I have to remember this when I use a new computer, which is to go to IE8 and turn that settings off.
If anything, I think this setting should be turned off by default and the user can adjust it on a site by site basis.
SSRS 2008 gave me a lot of white hair for sure. Here are a few things I learned that have made my life a little easier. Do not use Page Header, or rather, page header is useless. If you want to do anything with data per page, use the group header. Do not use column header given to you by default. Create your column header as another row in the inner most group that does paging; you can control it better from there. When creating report for the first time, create header and footer for each group, ......
I'm dealing with this custom database where an attribute for an authorization can store many things (amount approved, flags, yes/no, etc.) For the attribute that store the amount approved, I have a job that starts off periodically to put a TermDate on it based on some business rules. I had an expression like this in the where clause: CONVERT(MONEY, @value, 1) > 10000 simply because @value comes in as a VARCHAR field. This fails, which I can understand. it's doing a table scan and failed when converting ......