SELECT Outie.*

  FROM dbo.YourTable Outie

    INNER JOIN (SELECT MAX(RId) RId

                  FROM dbo.yourTable GROUP BY City) Innie

    ON Outie.RId = Innie.RId

Is another way to skin the same cat. ...

A trigger can potentially LOCK a table until it is complete.  Depending on your environment you may wind up with BAD performance.  An alternative is to create stored-procedures that MUST...

AFAIK (may be wrong) but you need to retrieve the TEXT column(s) last

If you use it without a TRANSACTION and there is a problem you won't be able to ROLLBACK ...

http://www.sqlservercentral.com/scripts/contributions/194.asp

Look at the COALESCE function for the conversion part.  basically if the DATE field is NULL or EMPTY you could provide a dummy date to return

OR you could use...

How about creating a table with 2 columns 1 for project and 1 for SEED.

Yuu would then use (inside a transaction) a RETRIEVE / UPDATE (to increment by 1)  with using...

Look @ sysobjects WHERE xtype = 'U'

research FileSystemObject on-line

Why not checkout http://www.redgate.com.  I would not look at Quest because they are an Oracle shop trying to get into MS SQL.  They are still primarily Oracle (TOAD is...

Why not add DATEPART(YEAR, DiscoDate) AS 'YrDiscod'

And then ORDER BY YrDiscod, [Quarter]?

Generally UPDLOCK is used for INSERT/UPDATE on a table.  What are you attempting to accomplish by using this lock?

Alternatively, you can use the CD you already have (assume Enterprise edition) and ONLY install the Client tools (QA, EM)...

I know that you say this field is NULLABLE.  Is there anything that performs a mathematical equation

based off this field?  Have you validated that there are no values of...

It could also be something as simple as WHERE FieldX <> 'V' when there are only a few items and when changed to WHERE FieldX IN ('A', 'B', 'C') the...