November 2009 Entries

Calling SSRS report using either T-SQL or SSIS

[Update: 2009-12-30] We got it working using SSIS. Read this post: [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 ......

Posted On Tuesday, November 24, 2009 2:53 PM | Comments (1)

T-SQL extract multiple child node attribute data out of an XML datatype.

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. ......

Posted On Monday, November 23, 2009 4:48 PM | Comments (0)

Absolutely hate "Automatic crash recovery" in IE8

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.

Posted On Friday, November 6, 2009 11:29 AM | Comments (0)

How to add a group without using wizard after a report was created

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, ......

Posted On Thursday, November 5, 2009 4:53 PM | Comments (0)

Cannot do a reliable convert in the where clause for comparison

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 ......

Posted On Tuesday, November 3, 2009 6:09 PM | Comments (1)

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski