Viewing 15 posts - 1 through 15 (of 19 total)
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....
February 4, 2015 at 7:28 am
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...
November 27, 2012 at 1:08 pm
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...
November 27, 2012 at 12:33 pm
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.
July 25, 2012 at 10:06 am
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.
July 25, 2012 at 8:18 am
I don't know about you, but I try to avoid functions in WHERE clauses like the plague
January 24, 2012 at 11:53 am
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...
January 24, 2012 at 8:59 am
Congratulations. Well deserved.
September 14, 2011 at 9:15 am
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...
June 24, 2011 at 5:48 am
Thanks for the help and to Jeff Moden for the great articles on tally tables! This is the code snippet I wound up using:
SELECT 'ABCDEF', 10, 125.50
May 9, 2011 at 3:44 pm
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...
December 29, 2010 at 8:36 am
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...
December 26, 2010 at 12:25 pm
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...
December 15, 2010 at 10:30 am
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...
November 29, 2010 at 9:35 am
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...
November 29, 2010 at 9:05 am