Ahh, I think I misunderstood slight,it's not specific objects that you want to restore, but only specific data. Using a Restore/Transfer, the only way you could achieve this would be...

If you transfer or restore a database, then you do exactly that; the whole database is used. You can't restore part of a database, as that's not how it works.

Without having access to your, or sample, data, this will be impossible for me to test.

Considering that you are doing date Math on the same field that contains...

You can't put two expressions in a single expression. you'll need to stack your inline Ifs. Something like the following might work (untested):
=IIF(Fields!Full.Value = "No Full","Red",IIF(DateDiff("d",Fields!Full.Value, Now())>2,"Orange","white"))

What do you mean it "didn't work"? We'll need more information than that.What was the error? What were they trying to do?

What was the SQl you ran in...

Something readable:
IF Object_id('tempdb..#temp') IS NOT NULL
DROP TABLE #temp
select 1 id, 'hello 123 fff 1234567 and today;""o999999999 tester 44444444444444 done' strlist
into #temp
union all
select...

I feel really daft for posting this, but does anyone know where you find SQL Server 2012 Developer? I've got to set up a couple more instances for our new...

If you're adding more users, with all the same (basic) permissions, it sounds like a better option would be to create a database role. Then you can give the role...