Viewing 15 posts - 2,266 through 2,280 (of 3,232 total)
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...
May 15, 2007 at 9:34 am
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.
May 14, 2007 at 4:19 pm
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...
May 14, 2007 at 2:17 pm
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...
May 14, 2007 at 1:11 pm
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...
May 14, 2007 at 12:34 pm
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...
May 14, 2007 at 11:26 am
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...
May 11, 2007 at 3:02 pm
"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...
May 11, 2007 at 12:54 pm
This solution does not account for ties in the same way that the poster requested.
May 11, 2007 at 11:55 am
PS - Thanks for the detailed clarification David. That's exactly what is happening....
May 11, 2007 at 11:06 am
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...
May 11, 2007 at 11:05 am
It may be Merant. The Progress DataServer may also do the job.
May 11, 2007 at 10:40 am
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,...
May 10, 2007 at 3:07 pm
What problems might the /3GB switch cause?
May 10, 2007 at 2:02 pm
It sounds like you are missing the boot.ini parameters that ALZDBA has mentioned. Also, as ALZDBA has said, you want to leave memory for the OS. I recommend 1...
May 10, 2007 at 1:54 pm
Viewing 15 posts - 2,266 through 2,280 (of 3,232 total)