<div>
Use a stored procedure and temp tables. Dataset A will be the only data set. Then have a veraible, &nbsp;@Date or something which you use to store your calculated date. So your where clause would look like this: <br />
<br />
Declare @Date datetime<br />
<br />
Set @Date = (select mydate field from mytableb where mycolumn = mywhereclause)<br />
<br />
Select * from mytable<br />
where date &gt;&nbsp;@Date<br />

</div>


Use a stored procedure and temp tables. Dataset A will be the only data set. Then have a veraible,  @Date or something which you use to store your calculated date. So your where clause would look like this:

Declare @Date datetime

Set @Date = (select mydate field from mytableb where mycolumn = mywhereclause)

Select * from mytable
where date > @Date


<div>
** your SP, not Where clause would look like this.... sorry! typo!
</div>


** your SP, not Where clause would look like this.... sorry! typo!

<div>
how do i use a sp with reporting services?
</div>


how do i use a sp with reporting services?

<div>
<div class="content wysiwyg-content">
I am going to have a dataset which will calculate a date, call it dataset A. &nbsp;My dataset B which will return all records since that date.<br />
<br />
So how can I say something like<br />
where date &gt;&nbsp;datasetb.date or something?
</div>
</div>


I am going to have a dataset which will calculate a date, call it dataset A.  My dataset B which will return all records since that date.

So how can I say something like
where date > datasetb.date or something?

Call Dataset B From Dataset A

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.