thanks for the quick replies guys!

@gilamonster: I dont have the privileges to add tables to the db, but I used the later part of the script;

from(

SELECT TOP...

Hi,

Thanks for the reply, it really helped! 🙂 Creating a filter for the entire dataset wouldn't help, but filtering the chart sorted everything, thanks again!

Thanks a lot, that really helped. Now I do get another problem though. I'm using the query in Reporting Services for a chart and because the specification value is NULL...

thanks a lot, that really helped, never thought of UNION :rolleyes:

I've got a problem now though that RS is complaining about me having ORDER BY items which are not included...

Thanks for the fast reply!

I did try case before, but wasn't really sure about the correct syntax and even now I get an error when I try it:

Column "example.created_as" is...

Alright, then there's no problem. I'm working on a backup database, so no one's actually adding or removing anything on the tables

I am and I will ask them if there are any indexes which need to be updated to improve the speed of some of my queries. Problem might be that...

Cheers Jeff, really interesting article! My queries are notably faster now without the while loop however still a bit slow. The databases are quite enormous (and as easy to find...

wow that easy... thanks a lot for your help!