I've just been investigating Microsoft SQL Server 2005 Reporting Services (SSRS) and in a word its great! However this post is about fixing a problem I found when trying to use the ReportBuilder from other computer.  When you click "ReportBuilder" in the SSRS web-based UI it will fail with a 401 denied error. By default (for security) the "ReportServer" virtual directory doesn't allow anonymous access, and Microsoft's ClickOnce technology doesn't seem to allow you to provide a username and password - fairly limited I think you'll agree. Anyway on to the solution... if you give anonymous acces... [More]

If you've ever done a UNION in SQL you may not have noticed that by default it actually does the same as a SELECT DISTINCT on the resulting data - so if you had the same 5 rows in two tables you'd get only 5 rows after the UNION. That's great most of the time, but what if you want all 10 rows? That's where UNION ALL comes in - that won't do a distinct and will get you every row. Cheers Mr Sherwood for posing the question....