There was no offence intended I just got frustrated with following a line of conversation to have it interrupted with something as equally interesting and then losing the thread of...

I like the use of CTE but could you not get the same result by simply using:

select min(hierarchyid) hierarchyid, hierarchyval from #test

group by hierarchyval

Just seems a tad easier?

Why not create the detailed report as a sub report? That way when an entry is "clicked" it will open the sub report without scrolling, surely far more practical?

I had a number of reports that many could not access or see (lack of forward planning on groups - make sure you plan well ahead - due to sensitive...

Ok, I think I now have the general idea, I got the possible answers WRONG :blush:

What it should have read, as far as I can tell from comments is;

Up...

OK OK, I think I got it, it was my first question and it was badly worded, many apologies for that.

I made the mistake of changing the SQL statement to...

Actually looking for something else but stumbled across the link by accident, thought it was a great lecture on Indexes and query plans, no where near as dry as the...

Thank you great question which proved that I wasn't listening at some point 😉

Nice question indeed, never stored txt files but had a good inkling.

What I don't understand is why it is not possible to define all file extensions that you want recognised...

I have been a member of SSC for a great number of years although admittedly only active in recent months and was frankly appalled at the amount of spam that...

Would have to agree with HappyCat59 with regard to directly trying to do this, however you may wish to check out the following:

http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652.

Which links from:

https://msdn.microsoft.com/en-us/library/hh368261.aspx

Hope...

Heisenberg

Deadlock victim!

Fell right into the trap and learnt something in the process - after considering the correct response!!! Many thanks for this one 😉

sipas (10/7/2015)

---

Never used Filetables, but isn't the limit to the number of subdirectories subject to the NTFS limit of 2^32 - 1 (4,294,967,295)?

Therefore the given answer to the question would...