Typist, at ~80 WPM. I'm curious to know if anyone's using Dvorak rather than QUERTY. I know both, and it seems to give the hands variety to move back and...

Oops. The sp was too long to fit in a single message<g>... Here's the rest:

SELECT tblPSRReport.PD_NO, SUM(PTD_INCUR_AMT) AS PTD_INCUR_AMT, SUM( YTD_INCUR_AMT) AS YTD_INCUR_AMT, tblPD_NO2Month.Short AS ShortMonthName, @FY_CD AS FY_CD FROM...

It's not exactly doing server cursors in vb, just cursors in the stored proc. Here's what I've got:

CREATE PROCEDURE calc_PSRSummaryMixed

@FY_CD varchar(6),

@EMPL_IDCriteria varchar(8000),

@PROJ_IDCriteria varchar(8000),

@IncludePerforming bit

AS

SET NOCOUNT ON

DECLARE @UserProfileID int

DECLARE @EMPL_IDList...

This stored proc will be called by a VB program with a variable number and type of criteria to select IDs. Basically, given some criteria with which to find a...

Yeah. This isn't really performance critical, because it'll be run only once a day at midnight. I just need something that works<g>.

Here's what I came up with:

CREATE procedure calc_EMPLTree (

@ParentEMPL_ID varchar(12),

@EMPL_IDList varchar(8000) output)

as

set nocount on

declare @EMPL_ID varchar(12)

declare @TempEMPL_IDList varchar(8000)

set @EMPL_IDList = @ParentEMPL_ID

declare userCursor cursor local FORWARD_ONLY

for select EMPL_ID from tblUser...

Yes. That is the problem. I need to go n levels deep. N should be less than 6, but I still need to drill down like that.

The problem I'm having is that the IN string is a parameter on the stored procedure. I'm calling the stored procedure from Access using ADO. What should I do? Create...

I did something like that. But my string of possible in values may be up to 32K long. How can I deal with that?