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

Not sure I understand. Do you mean you don't want the chart to print, but still be visible on the screen?

Looks like this article should give you at least...

Post what you tried.

And while you're at it , could you explain how the logic works to generate what you're describing? I have no clue how you got from your...

You can probably do that following the examples in Jeff Moden's article. http://www.sqlservercentral.com/articles/T-SQL/63681/

I would be nice and work on it, but it's almost 2 AM here... start there and if...

Do you have any control over the underlying database? The fact that you have a bunch of data coming from different tables makes me wonder if if they underlying...

Thanks for posting the data, but if you could post it in consumable format, then people could help you a lot easier - and you would get tested solutions. ...