So... if I don't have permissions to run anything on msdb on the Server running the DTS then this won't work.  Any other ideas.

Thanks,

Yes, this was it.  I found it after stepping through in debug.  I had a field name misspelled in my lookup table so it could not be found.

Thank you for...

I have a procedures that generates a cross-tab result like:

recordID, facilityID, CountX, Avg1, Avg2, Avg3, Total1, Total2, Total3

I have another procedure that also generates a cross-tab result like

record, facilityID, Total4,...

Probably a dumb question, but how do you call another SP from within a SP into a temp table that can be used elsewhere in the calling SP?

The date is being referenced datetime in the functions.  The stored procedure returns about 4000 rows in under a minute when the date is hardcoded in the procedure.  The date...

This is the script I am using to run the function:

-- This just runs forever

DECLARE @dtDateEnd datetime

SELECT @dtDateEnd = '03/05/04'

SELECT * FROM [dbo].[fnCMStatsMTD_Summary](@dtDateEnd)

--- This work fine

SELECT * FROM [dbo].[fnCMStatsMTD_Summary]('03/05/04')

Thanks for all the help.  Noeld's answer worked great.  I am passing only a couple of codes in the parameter string so this was the easiest to use and I get...

When I call this function to return a recordset I am using:

SELECT * from fnEmployeesByGroupCode ('CMS,CM')

I keep getting an empty recordset even though I know there are records with either...

Thanks so much for the help. I created a seried of functions

1. Create fn1 that selects the records by the desired date from T1 and add an...

This is working great! I have not utilized function like this and getting parametized views really helps.

Now, I have a new twist on it. I need to use...

I am probably trying to do something I can't.

1. I have a query that inserts a recordset into a Temp table, #Temp1

2. I have another query...

My problem seems to be getting the correct syntax to execute the stored procedure to get the temp table from within another procedure.

Thanks for all of the help. I finally came up with a solution that gets me the last record for each consumer by date, and also gives the correct...

This works for the specific consumer, but I need to get the last record for each consumer. Any help with this?

Thanks.

I am able to create the linked server but I am getting a message when I attempt to verify the tables or query the tables (files)

The error is:

Server: Msg 7399,...