thanks so much, I see what it's doing now.

Last question, while this gives me a range of dates I can manipulate, I'm trying to find the number of rows with...

thanks so much! I will try this out. This is for the previous week, correct? How would I also find anything in the current week?

Thanks again for...

Thanks for the reply, no I don't have a name table at all, just the phone number. I was thinking of somehow using a reverse phone number site like...

Yes, it worked fine. I had to change the ID to a variable of the current ID, but the synatax was perfect. Thanks again.

awesome! Thanks

I got this working nicely, thank you very much.

Got it, thanks so much!

Thanks for the help. 'get_total_numbers_total' is a whole bunch of union statements that summarize different pieces of information from different tables, etc. I tried to add a unique...

Thanks for the help. This is the sql that puts the stored procedure into a temp table with a unique ID:

CREATE TABLE #trustgoals

(ID int IDENTITY,

Trust varchar(100),

InitialReview varchar(100),

ReReview varchar(100),

TotalReview varchar(100),

TotalQAApproval...

I don't need to get back to the db, the id column is just 1 through 44, it's only there because my module needs a unique ID column to display...

thanks for everyone's help. I got it to execute in a stored procedure:

CREATE TABLE #temptable

(ID int IDENTITY,

col1 varchar(100),

col2 varchar(100),

col3 varchar(100),

col4 varchar(100),

col5 varchar(100),

col6 varchar(100))

INSERT into #temptable

EXEC original_sp

Select *

From...

I'm trying to do it in sql2000. So I've created my temp table, then the rest of the SQL is just a bunch of union all joins:

CREATE TABLE #temptable

(ID...

Ok, thanks for the reply! Are there any examples out there that I can look at to figure this out? Also, I do have SQL Server 2005 if...

Thanks for the reply. It only returns about 25 rows, it's a summary of many different tables, but sql returns it in a secord or two.

Thanks again for the replies! What I plan to do with the information:

These are for PR firms and we're tracking the number of media hits and other things...