Those specific examples you gave will work fine for that query, however, the problem is that somewhere in your data, you have something that doesn't work.

You could filter...

Is there any reason why you're using the NOLOCK hint? Also, perhaps ISNULL (Transact-SQL) or COALESCE (Transact-SQL) would be better choices than a CASE Statement for...

Is there actually a many to many relationship here? YOu state "Basically a single 'Tag' can relate to many ParentTask items and many ChildTask items.", which means, unless I am...

I find the worse point is when someone who is outside of IT (like a director) gets involved. At the moment we have a user constantly asking to be able...

Use the credentials you need, you or your dba and your network Administrator, will likely need to set them up. I can't tell you what those credentials are, as they...

Let's start off by fixing some of your trigger so that it can handle more than one row, but also making it readable (there's no indentations your post, so telling...

It is failing at this point:
insert into OnlineActivity (Activity_Date, Router_Number, Activity_Number)
values (CONVERT(char(8), GETDATE(), 112), @routerno, @activity)
The error your showing is saying that the value of...

When supplying data, you should really do so in a format that we can make use of in SQL. A table doesn't meet those requirements. I've done this for you,...

You'll need to amend the report's datasource then. When you manage the report in the web console, there is a "tab" called Data Sources. You'll need to enter the credentials...

Sounds like you have the datasource set up to use the current users credentials. If it's a subscription, then there is no current user, thus no credentials to use. if...