Thanks for sharing with the community... perhaps better suited for a new topic... but here we are...

First a public service warning - with SSRS 2000 and 2005 (and perhaps 2008)...

 For reference, cross Posted from http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=148843

The key is that you need to associate a data region with a dataset.

When you associate multiple regions with the...

The key is that you need to associate a data region with a dataset.

When you associate multiple regions with the same dataset, the navigation is automatic.

Only when the two regions...

These resources may be of assistance (I have not personally encounted but would like to know if eaither of these is helpful):

1. spaces after the tcp port on the server...

Thanks for the followup on this posting - great reference for how to do this in that other posting.

SQL stored procedure parameters do not support arrays of values natively.

That being said, you can pass a comma separated list into a stored procedure parameter defined as nvarchar(x) where x...

Could you post the schemas for ContractTable and table1?

My inital guess is that the subquery that you are using within the CASE statement is not constrained on the outer queries...

The problem I am framing involves not just knowing which system tables the information is a part of but in what manner one can perform the following:

1.      Iteration through tables...

Really? Duh.

Sergiy, get your posting count up on another thread... I have reviewed your "look in bol" type responses and they are not welcomed...

Thanks... looking for more specific guideance than search all the scripts on SSC or go to bol.

Has anyone done this before?

Can anyone share the best way to navigate the...

SOLVED!!

This took some exploring and lots of trial and error to figure out, so I'll share my insights:

Post SCD wizard - using it's generated objects:

1. Changed the SCD Data...

The requirement was for the Document Number (aka DocumentId) to be incremented separately for each log rather than have a unique id (e.g. identity) for every document regardless of which log...

THANK YOU BOTH for the great suggestions and help understanding all this!

I will be looking at both of your ideas this afternoon and...

Hmmm... does the first (inner) query complete prior to running the second (outer) query when they are combined?

I REALLY am thankful for you assistance! I am just trying to understand...

Those queries ran exceptionally fast when separated. Why?

#1 Start:  8/10/2005 1:49:52 PM

#1 End and #2 Start: ...