I found it. I needed to add TYPE to the end of my XML Path statement.

Thank you! This is very slick!

I keep going back and forth on the one lookup table design. For UI purposes in this case it makes it easier to...

The documentation on that is wrong. There are posts about that all over the internet. At any rate I realized I had spent a ridiculous amout of time...

Doing that gives me the same error messages as mentioned in the earlier thread. That fails.

I deployed it from VS. I just didn't realize it would show up as a sproc. Once I found it there the rest has been smooth sailing. ...

First, thanks for the pointer to the stored procedures area. I actually found it by accident looking at a different sproc and it in fact feels just like all...

Sorry about the missing information.

I deployed it to SQL 2005 and it appears in the Assembly area. The routine creates an iCalendar formatted email message and then sends it....

Looking at your two examples I see no pattern at all. In order to have SQL do this for you there has to be something VERY regular you can...

Julie Zeien (8/13/2008)

---

Ken's code looks like it'll work to me based on what we know about the query. You might be getting tripped up because you posted a very...

That won't work because it gets everything. I need it to ONLY get from the appropriate table. At least, that what I think from looking at this. ...

set myDate = cast(isnull(mystring,'12/31/2008') as datetime)

Place a table in the empty cell above the cedula and nombre columns.  Set the width of the columns in the table the same as the width of the cells...

This is not tested, only a theory but it should work.

Create a group for month that uses the month number.  Then sort by that group.

You will need to open SQL Server Business Intelligence Development Studio (the link comes from the SQL Server 2005 program group).  From there open the project where ever you have...

I realized I could just change the column I am selecting in my source and not bother with this lookup this way. So, never mind.