Michael

You will find a table with the meanings of the columns in Books Online.  For your report, I think you will need to create your own lookup tables with this...

Tryst

Here's a way of doing it without a CASE statement

TABLE #MyTable (TableID int,...

I would set it to the size of the disk (assuming you don't use the disk for anything else) and then leave it.  Make sure you grow the file out...

Richard

More information, please.  Is it all the indexes on this table, and if so have you rebuilt them all, including the clustered index (if there is one)?  How do you...

Frances

To see the Taskpad View, click on the database in Enterprise Manager, then right-click and choose View and then Taskpad.  Unused DB and log space are the amount of space...

Dan

In a cluster environment, the operating system regularly polls SQL Server to check that it is still alive.  I think it does this by connecting as a Windows account and...

It all depends what the requirement is.  A view can be thought of as a virtual table.  It can be queried, joined to other tables or views and, under some...

MK

As far as I know, this isn't possible.  Just as a matter of interest, why do you want to do it?

John

Casper

I think the fact that you have to register to download your document is putting a lot of people off.  Search these forums for "coding standards" - you will find...

You should be able to do that with a trigger.  Unfortunately I'm not the person to ask about that.  I recommend that you spend half a day reading about triggers...

Not the most elegant solution, but it works...

John

--Data

create

table #John (data varchar(20),

If you have already done the update, you will not be able to do what you have been asked.  You'd have to restore a copy of the database from a...

Mitesh

I think you've stumbled on one of the pitfalls of using Enterprise Damager: that you have to refresh before you do almost anything.

John

Jude

I think all you need to do is turn your IIF statement into a CASE statement (look this up in Books Online) and alias your subquery, thus:

...

ResearchStudent.EnrollmentCategory, q.Suspension

FROM...

Sushila

Yes - you're right - I hadn't noticed the CASE statement higher up that traps the 0.

John

[Edited when realisation dawned on me!]