Oh, the reason I needed the bucket names.....

I can now do a JOIN between the Staging table and the DimCoverageBucket table on the BucketName so that I get...

As soon as my current code run quits, I'll try that, buuuttt.....

Are you saying the parens around the OR part of the statement aren't working correctly? I put in...

I didn't look at my code before I submitted the post. The forum screwed it up. Let me try again.

ISNULL(RetroDate) == FALSE && (RetroDate lessthan (DT_DATE)"01-01-1900"...

Will do.

Also, just a note. My build problem doesn't seem to exist in other solutions, not even the one I created from scratch and moved my "problem child" existing...

And if there wasn't already a result set partially loaded, I'd agree with that.

You know how when you do a SELECT the results start loading as soon as...

Jim,

I appreciate your opinion, but I hate doing the half-day to full-day's worth of work uninstalling two programs and re-installing them if there is another perfectly logical explanation for the...

I was able to re-run my query without any problems. In fact, I haven't even closed out that session of SSMS yet. And haven't seen any additional error...

Other people are using BIDS with no problem on their PCs. I don't have time for a reinstall. My project is due Monday.

I finally closed the project out,...

DOH! I was looking at the wrong transformation task.

Thanks! That helps. @=)

Ah. I thought you had the subreport as a column instead of as a row.

Nevermind. @=)

Why does the subreport have to be a column? Why can't it be a row?

Try also turning off "Can Shrink" and making sure all the row sizes are the same. Then, check each individual cell to make sure all your changes are propagated...

Melissa,

Are all the widths the same for each column and for the subreport "form"? What about the widths of the columns within the subreport? They should be just...

David,

You should be careful. To install VS, you're probably going to have to uninstall SQL 2005 first. When we tried installing SQL before VS (the full version), SQL...

I'll have to check. Can you verify which study guide you're using? (Publisher & Author name).