That is what the multivalued parameter is for. You need 2 datasets in your report. Dataset 1 will return a list of employee names and ids and dataset...

david.sims (7/23/2008)

---

I am pretty sure that this is not working correctly as I executed it and it kept going for ten minutes. Meanwhile it generated 10 million lines of...

Grant Fritchey (7/23/2008)

---

Just a point of detail... You can overflow the buffer even when capturing to file. It just takes a heck of lot more to do that since writing...

Are you using SSRS 2000 or 2005? In 2005 you can create a Multi-Value drop-down list parameter that passes a commas delimited list. In your Report you would...

Here are a couple of T-SQL options:

[font="Courier New"]IF @ActionID IS NULL -- or @ActionId = [DefaultValue]

    BEGIN

        SELECT

            *

        FROM

            dbo.Actions

    END

ELSE

    BEGIN

        SELECT

            *

        FROM

            dbo.Actions

        WHERE

            ActionID = @ActionId

    END

-- OR

SELECT

    *

FROM

    dbo.Actions

WHERE

    ActionId = CASE

                        WHEN @ActionID IS NULL THEN @ActionID--...

I just ran these procs I created to answer another forum question in AdventureWorks:

[font="Courier New"]ALTER PROCEDURE temp_table_test_1

AS

CREATE TABLE #test

    (

    test_id INT IDENTITY(1,1),

    test NVARCHAR(50)

    )

INSERT INTO #test

    (

    test

    )

    SELECT

        name

    FROM

        production.product

SELECT * FROM #test

EXEC temp_table_test_2

SELECT *...

spamhdp (7/23/2008)

---

I am pretty sure I have seen this behavior on my SQL. I mean, update a value, query it and have the old value for a few seconds, and...

You could put a textbox on the report and set the visibility (Hidden Property) by checking the value of the parameter like this =IIF(Parameters!test.Value = "x", False, True) and set...

You cannot pass a temporary table to a stored procedure. You can create a temporary table in stored procedure 1 and then manipulate the data in the temporary table...

kayuca (7/23/2008)

---

Below appears my code, which BTW gives me the following error: “Conversion failed when converting the nvarchar value ‘RICSU’ to data type int. [stored proc2 - line 13]....

Andy,

Good advice from both Grant and Herve. You should also know that you can use Profiler to create the trace, script it, and then run it on the server...

In SSMS connect to a server using Object Explorere then Go to SQL Server Agent -> Jobs. Right-click -> New Job, etc..

Cross post. Original here: http://www.sqlservercentral.com/Forums/Topic539362-145-1.aspx

If currently the data from DB2 is being loaded nightly, why is there a need to hit it dynamically now?

Also your biggest hit as a percentage of the query plan...

Please do not cross post. Original post is here: http://www.sqlservercentral.com/Forums/Topic539275-1063-1.aspx