I was waiting for Jeff Moden to answer, but since he hasn't yet, you might want to read his article:

http://www.sqlservercentral.com/articles/T-SQL/94570/

or

http://blogs.msdn.com/b/mvpawardprogram/archive/2012/06/25/hierarchies-convert-adjacency-list-to-nested-sets.aspx

Or maybe one by Dwain Camps

https://www.simple-talk.com/sql/performance/the-performance-of-traversing-a-sql-hierarchy-/

That's what I suspected. Then I can just filter the Territory dimension with the appropriate year and be off to the races.

Thanks!

Doing things like you describe is not uncommon with date dimension/calendar tables in a data warehouse. Then you can do pretty much any kind of date-related query really easily.

Yeah, until the defense turns up the pressure... then he'll hurry and throw some interceptions like he always does.

Just throwing this out there, but what if you do something like

UNPIVOT to convert the dates in the column names to rows,

join to the Calendar table to get week numbers...

Once you have the DelimitedSplit8K function in your database, you can do something like this:

SELECT test.ID

, test.value

, split.ItemNumber

, Item = split.Item

FROM

(SELECT 1 AS ID,'1' AS Value

UNION ALL

SELECT 2,...

Hard to believe you don't have alerts set up so that this doesn't happen. Scary. Maybe you need to update your resume....

Maybe read this: http://www.sqlserver-expert.com/2012/05/manage-database-files-and-file-groups.html

See the section that...

I was being serious when I said that's how you learn. Try, test, fail, read, try... if you aren't willing to do that, then pay someone to help...

That's how you learn. Try, fail, modify... hit F1, read Books Online, try again.

DECLARE @NewPath VARCHAR(100) = 'C:\Dir\Subdir\File.xml';

DECLARE @sqlstring VARCHAR(200) = 'SELECT * FROM OPENROWSET(BULK ' + '''strFileName'', SINGLE_CLOB)';

SET...

Can you use Conditional Split to divide the dataset -- so that you get the match/no match and then handle there?

Katie and Emil are really good at this kind of...

So create a column in your base query that grabs the first three characters of the string, and then base your summary query on it.

The video on YouTube is handy too... just so you can watch someone do it.

Grant's backup and restore video on YouTube

There's not much more to say that hasn't already been said. I did Access for a long time (and lots of VBA too), and moving to SQL Server takes...

The only thing I can think of is that you have another object named "Report1" in the database. Otherwise it should work.

One way might be to read the names of all the files in the directory into a variable one at a time, then parse off the date into a date...