Can you provide some sample data?

If you post your table DDL, maybe we can find a new way to return the records you want.

Now that you have CTE's available, it should be easy.

Try this for a SQL Server 2005 solution

SELECT

<Col List Here>

FROM

(

SELECT

sp_spaceused is stored in MASTER database.

Make a copy and edit as you wish.

USE [master]

GO

/****** Object: StoredProcedure [dbo].[sp_spaceused] Script Date: 08/20/2007 15:55:32 ******/

SET

...

No. The showing of the data has to be done in your ASP page, by calling the SP.

Or, you can create an HTML page from your SP, but why would...

Do you think this is vital information?

If so, you should have posted this in your original post.

I guess typos are geting more advanced each day.

See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=391727#bm391755

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78730

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62729

It seems overlapping is OK, he only wants the date ranges where the date is completely missing.

This was asked as SQLTeam.com recently, I just can't remember the topic ID.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78730

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62729

Nah, too easy

You can do this if you are a member of the local administrators of the machine where sql server is running.

If your table WellsResubmit_Staging already has an IDENTITY column,

SELECT

MAX(SellerUserID),

MAX(BusinessName),

MAX