We solved this problem by replacing the pc.

thank you for your response.

Hello everyone - Thought i would share my solution. I used a function that someone pointed me to and a cursor to create the file of case numbers..

Life...

thank you everyone for your help! I will work with all suggestions, one of them is sure to work for what I need.

thanks again!! 🙂

And thats...

The @caseNbr is not null part is not working correctly. I get back data for the first caseNbr keyed in by the user and not the second.

the...

I was told to use the "nolock" to prevent a data lock.. ?? So far it has not been a problem with the other stored procs.

Yes the problem is...

The else part works.. it gathers the data based on the start and end date parameters and ignores the @caseNbr parameter. Heres the "esle" part:

ELSE

BEGIN

-- get all...

This the code for if the @caseNbr is not null:

ALTER PROCEDURE [dbo].[rpt_CaseFolderLabels]

@startDate date

,@endDate date

,@court char(02)

,@location char(02)

,@caseNbr char(12)

,@filingFee int

AS

IF (@caseNbr is not null)

BEGIN -- get all the active parties...

This is the results of the profiler:

exec rpt_CaseFolderLabels @caseNbr=N'10-cc-033227,10-cc-032468',@startDate='2011-01-27 00:00:00',@endDate='2011-01-27 00:00:00',@court=N'CA',@location=N'TA',@filingFee=0

The two @caseNbr entered are received. the other parameters are ignored because the @caseNbr is not null.

Gail

I corrected my "IF" to

IF (@caseNbr is not null)

Begin

...

And I still only get one label printer.

thank you for your help

Sorry i did not realize I posted this twice... where is the original?

The data for the multiple records for @caseNbr will look like this:

12-XR-012345, 12-RT-098733, 09-CA-123456

The user can input 3 case numbers or 20. And the case number is six...