Steve is correct, a heap in SQL Server is a table without a clustered index.  If you look in BOL at Table and Index Architecture, it shows that there are...

If you’ve got it narrowed down to a stored procedure, as complex as it may be, you’d benefit from knowing what resources the SP has...

This sounds fairly straight-forward, but it would help us if you would give us your table DDL, sample data, and an example of the result set that you desire.

That's exactly what it is doing.  The total comes from the COUNT(*), the number within the range comes from the CASE statement.  As you can see, the CASE statement results...

David is correct.  You can remove the outer most CAST if you aren't planning on having the % as part of the results.  I was under the assumption that it...

You could put it all into one query like this:

SELECT CAST((CAST((CAST(SUM((CASE WHEN PL.PLcurrentStatus IN ('11', '25', '30', '31', '32', '33', '35', '41', '51', '53', '55', '75', '80', '82', '86') THEN...

DECLARE @WorkRequest TABLE (WRid int)

INSERT INTO @WorkRequest

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5 UNION ALL

SELECT 6 UNION ALL

SELECT 7 UNION ALL

SELECT 8...

Glenn,

Yes, you can install SQL Server on the server and use the SAN storage for housing your database files.  You will want to make sure that whoever is responsible...

"Does anyone know of any software that may be able to read an old Progress Database?"

If you are after software that can read a Progress database, why not get Progress...

This solution does not account for ties in the same way that the poster requested.

PS - Thanks for the detailed clarification David.  That's exactly what is happening....

Did you try it.  Plug your new values into my example and it still works. 

DECLARE @table TABLE (Record int IDENTITY(1,1), value int)

INSERT INTO @table (value)

SELECT 100 UNION ALL

SELECT...

It may be Merant.  The Progress DataServer may also do the job.

I believe SQL Server 2005 has a RANK function, but for now, you're stuck with using T-SQL.  Try this, I just threw it together based on assumptions on data types,...

What problems might the /3GB switch cause?