I saw that formatting on Wikipedia, which sort of gave me the idea, however, as I didn't see a need for the other columns (I already have ISO Week number...

I've sort of added a cheeky hack to my existing table, just added an IsoWeekYear column, which I set to the year(thedate) first of all then updated for IsoWeek =...

I'm actually looking at the bulk insert technique now - in terms of data it's very simple, an Excel file with an email address per row, saved as a CSV,...

I'd have to review the split function you linked to - I opened it and had a quick look but I've not had the time to read it yet.

As for...

Ah okay, thanks Thomas. The SSRS stairway series is great (as at most if not all stairway series here 🙂 ) and I use Tablix quite a bit already.

There's...

Thanks for the reply Jeff, if I'm understanding you correctly that's what I'm doing - for instance:

SELECT IsoWeek, YearNumber, count(communicationID)

FROM Comm c

JOIN TallyCal tc on tc.TheDate = c.Comm_Date

GROUP BY IsoWeek,...

Hmm, okay! ...

Well, one thing I think we can all agree on, having rar/7zip backups of the .bak files of these databases on a different disk in my machine is...

Thanks John, I'm currently going through the databases and shrinking them actually. These are monthly archives which are dipped into from time to time and prove very useful. They're not...

Ah I see, run the command, right click on DB in question, tasks --> take offline.

Copy files in explorer from source to destination

right click --> 'bring online' (at a guess!)

Confirm...

Ahh, I see, that makes sense perfectly after delving into that data and seeing what's going on. I can try it with a couple of databases by changing the database_ID...

Funnily enough just after I posted that I had a little play around with some test data - as you say it's skipping stuff that's hidden, so in theory it...

I sort of thought of that but I couldn't get my head around how I'd arrange the report. Surely if I had 4 different grids one below the other with...

I'd never thought of that! That sounds like great alternative, I'll have a play around and see what I think.

Thanks - I need to think about more problems from a...

Right, I've got that tool installed, I've disabled everything except the history, and got rid of the toolbar, it seems to be doing it's job without getting in the way....

yeah I took a look, it's actually in a different location because I'm on Windows 7 : http://aalamrangi.wordpress.com/2011/10/25/recover-queries-after-a-sql-server-management-studio-ssms-crash/

I looked at my original post all those years ago!