Thanks for the quick reply, although that is bad news.

I will check with the company who will be collecting the logs (VeriSign), but I think the appliance that does the...

Since you say postcode is your unique key, you can safely assume that there will not be duplicates in the table without having to group by the column.

If you still...

Ouch, although I think that is almost true in...

john (4/15/2008)

---

Hi

Thanks to this government and partly to the sort of work I used to do, the costs of continuing to do business as a freelancer, and particularly the fees...

bicky1980 (4/14/2008)

---

Hi Rod

If I was not to aggregate my fields it won't allow me to select them fields as they are not part of my group - How do you...

Hi Bicky1980,

The short answer is yes... But before hand another question is "what is the end result you are trying to achieve?" The result of your three queries...

The roles are also in sysusers. Query on the IsAppRole or IsSQLRole columns.

It's not allowed in Transact-SQL. You can't even do that with sp_executesql.

I think it's to do with the fact that it's implicitly converting the parameter to unicode and so...

I use Macs at home, (it's nice to keep home and work seperate ;)) and even with the very limited MacBook Air, VMWare Fusion works great on those few occasions...

For my current role in the UK, I needed to fill out a screening form which had sections for employment history. Leaving the salaries blank, I was soon called...

Rob Goddard (4/10/2008)

---

That's the one.

Select the field you want to group on in the 'Group on:' expression table, click in there (on =Fields!State_Sort.Value) and you should see it's...

That's the one.

Select the field you want to group on in the 'Group on:' expression table, click in there (on =Fields!State_Sort.Value) and you should see it's a dropdown.

Alternatively,...

If you right click on the group row identifier (just to the left of the group header or footer), you can select "Edit Group..."

Hope that helps

Hi Sean, thanks for your reply!

After a couple of days of failing, the problem just went away for me, too. The fact that the packages couldn't be simpler...

Thanks Matt, that's perfect, exactly what I was looking for!

Rob.