SELECT BENCAT,

SUM(CASE Gender WHEN 'M' THEN 1 ELSE 0 END) AS NumMales,

SUM(CASE Gender WHEN 'F' THEN 1 ELSE 0 END) AS NumFemales

FROM [dbo].[masterenroll]

WHERE DMIS = '0005'

GROUP BY BENCAT

The distinct's...

No. In fact, only the moderator can lock a topic and there's no mechanism to close a topic.

YSLGuru (6/19/2009)

---

If this difference is no longer ture then I wonder why the DERIVED TABLE method is not at least on par with the SUBQUERY method instead of being far...

YSLGuru (6/19/2009)

---

There may not be enough here to answer my specific situation but in general, isn't it true that when all conditions are equal, a sub-query version of a query...

Table definitions?

Is the first worksheet the sample data? What's in the second worksheet?

Can you perhaps explain, in detail, exactly what the trigger is supposed to do.

Sometimes the size doesn't update immediatly,...

If you look at that article is covers a way to post sample data. If you can't get that to work, zip and attach an excel spreadsheet with sample data....

The...

Hang on.... sysobjects? This is a SQL 2000 server?

I've requested Steve to move this to a SQL 2000 forum.

Generally, with CheckDB if there's a repair level specified then the error...

Is that the full and complete output of checkDB? If not, please run the following ad post all of the output.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

If it's the SQL commands that you're talking about, it's a sql script, hence .sql

2. I...

One I asked once (in an interview for senior position) was how to repair a torn page without losing any data. Anyone want to guess the answer I got?

You wanna maybe tell me why you want to remove an entry from an error log? The main use I could see for that is to hide evidence of something...

Without seeing the procedure all I can suggest is to try and replace the cursor with...

Server-side trace. Far less impact than profiler and you can schedule it with SQL Agent.

There's a section on creating a server side trace here - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/