Post reply

Input data with mulit records for a parameter.

  • January 27, 2011 at 9:36 am

    #74152

    I'm sure this is an easy one for all you experts out there... I'm a bit new to this and hope someone can help me.

    My input data is coming from a SSRS report and one of the parameters can have multiple entries or none. It works like this..

    ALTER PROCEDURE [dbo].[rpt_CaseFolderLabels]

    @startDate date

    ,@endDate date

    ,@court char(02)

    ,@location char(02)

    ,@caseNbr char(12)

    ,@filingFee int

    AS

    IF (@caseNbr <> null or @caseNbr <> ' ')

    BEGIN ....

    Now if @caseNbr is null or blank, the stored proc goes to the "else" and gets the information for the labels based on all the other parameters - no problem that works. If the user keys in ONE caseNbr no problem ... if they key in more than one caseNbr I get data for the first @caseNbr and not the others.

    All suggestions will be a great help!

    thank you!

    Martha

    How do

  • January 27, 2011 at 11:37 am

    #1279274

    Please don't crosspost.

    No further replies please.

    Discussion already started here.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply