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!]

Run the following query, which will generate the SQL to change the permissions all at once.  Be careful, because if you have any DENYs on any of the views, they...

If I understand your requirement correctly, you're looking for a query that will return all TransBaskets that contain the specified two items.  This should do it for you:

--Create the table...

Mitesh

This part of your query worries me:

((ISNULL(SUM(InvoiceTotals.[Total Net]), 0) -

ISNULL(SUM(InvoiceTotals.[Total CostBC]), 0)) /

ISNULL(SUM(InvoiceTotals.[Total Net]), 0)) * 100

If all the values in [Total Net] are NULL, then you're going to have a...

The REPLACE statement is what you are looking for.  You can replace certain characters with an empty string to get rid of them.  Also, you can nest the statements to...

That's fine.  SQL Server will take as much memory as it needs.  If the operating system or another application needs more, SQL Server will give some back.  If you have...

Mitesh

You haven't posted your original query, but I'm guessing you used an INNER JOIN to join the Employee table to the InvoiceTable totals.  Try using a LEFT OUTER JOIN, and...