I need to query the values in one table repeatedly against records in a temporary table, while the system_user is the same value .... The temporary table @TmpTbl has three columns and data as per the example
How can I find values in table DIM_DEPT where the values are between startvalue and endvalue for each row of the @TmpTbl where the usr = DOMAIN\user1 Simple "between" wouldnt work because the query returns more than one value each time?
how should the query look which can return values from the DIM_DEPT - in a table format, a single column, for the all values found between the start and end values of each row of the @TmpTbl?
This resulting table will be used as a parameter list in a SSRS report.
asked Jan 28, 2010 at 12:52 AM in Default
Just a simple JOIN should do it:
answered Jan 28, 2010 at 07:10 PM