Great article! The "Using a Table-valued Expression" example was spot-on for a thorny problem I'd been working on. I adapted your example and came up with a solution....

Thanks for your reply.

You're absolutely correct about required columns (minOccurs).

I've been leaning toward the hybrid approach, viz., storing frequently used/searched fields as columns then using an xml column to persist...

Thanks for confirming what I already suspected re the nodes question.

Regarding the storage question, a client has an old Access app I've been asked to refactor. The app has...

Good job!

I tried using True yesterday but it kept throwing the error.

Today when I use True (it's not case sensitive because I tested true, True, TRUE) SSRS accepted the Value.

Go...

Hopefully you'll be able to see the screenshot I uploaded.

I've come up with a workaround using expressions, but to my mind the approach shown in the screenshot SHOULD work.

I'm going...

I don't know about you, but I try to avoid functions in WHERE clauses like the plague

I find a calendar table with pre-defined columns for month, fiscal month, etc., and other columns like YYYY-MM is invaluable for aggregating and sorting data like this.

Joining the source table...

Jeff,

Congratulations. Well deserved.

Christian Bahnsen

Hmmm, I thought I'd posted the solution here. Anyway, for my particular situation the solution was to uninstall the Express Edition tools (yes, I had SQL Server 2008 Express...

Thanks for the help and to Jeff Moden for the great articles on tally tables! This is the code snippet I wound up using:

INSERT tblDupesDemo_ccb

SELECT 'ABCDEF', 10, 125.50

FROM dbo.tblTally_ccb

WHERE...

Yes, either using that drop-down or by using File | Connect Object Explorer and then using the "Server type" dropdown in the Connect to Server dialog box.

The only server types...

Could it be that these services are NOT running as Local Service or Network Service? In the Log On As column of Services they show the account they were...

Hmmm, I'm really surprised that no one else seems to have had this problem.

I have an existing SQL Server 2008 Express Edition With Advanced Services instance installed on this laptop...

Jeff,

Thanks for the suggestion. Among others, I'd looked over Erland Sommarskog's article on How to Share Data Between Stored Procedures

(http://www.sommarskog.se/share_data.html). I was trying to avoid...

dataguru1971,

Thanks for the suggestion. This worked like a charm:

SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'foo'

I wasn't aware of the INFORMATION_SCHEMA. I can see other uses...