I think richard is onto something here... without the entire query I'm guessing, but it looks like this could be some sort of correlated subquery directly in the subject line,...

To get the + sign you need to set the visible property as well as the visibility toggle property.

You'll need to set this for the details group. I believe it's...

How is your field defined? Is is just =fields!mycolumn or do you have some other logic in there like = "SomeText " & fields!mycolumn & "MoreText" ?

I've found that...

Shirts... so apparently I was not one of the lucky hundred to get a free polo, no prob maybe next time, but until then, Ever given any thought to selling...

Use the Google Custom Search at the top of the page...

The forum search tends to be less than reliable at times...

-Luke.

Congrats Steve, SSC and Red-gate.

Here's to 1 Million More.

-Luke.

Couple of things...

This looks like a homework problem. Most people here, including me, won't actually give you code to help because of this...

I can however point you in the...

How are you doing the update? Is it via SSIS, DTS, SQL Agent Job etc?

If so, you should be able to use their logging features to do this. ...

Unfortunately, the reason why some very large companies end up dong this is that someone comes along and says he we need to represent x data y way... Or more...

I take it that your tempdb is set to autogrow...

Perhaps your bumping into the issue where it does the autogrow, but it doesn't grow enough in one shot that the...

Principle of least privlege says that you create a shared and grant only those rights it needs. IE. give it rights to read/write to that share instead of giving...

Do you have any size metrics over time that you've been able to correlate with a particular process that's using all the tempdb it can get? Sorting some really...

More than knowing how to stop your tempdb from filling the drive, you need to find out what's causing it to grow so large? Have a look at the...

OK, thanks to you all. You've definitely given me the appropriate ammo for the conversation I need to have with some folks today.

Thanks again.

-Luke.

thanks for the quick response.

I appreciate your time, however it seems odd that your db is showing no multi county codes as http://www.zip-codes.com/zip_database_fields.asp#multicountydata states that approx 25% of Zips span...