Robert:  the [1] is required, the Pragmatics would call it RTFM.

The xquery.value() function requires a singleton result.  Even though, in this case, leaving...

Japanese time does not have AM and PM; it's a 24-hour clock. 

Instead of 5:27pm, use 17:27.

12:00 am = 0:00

6:00 am = 6:00

12:00 pm = 12:00

6:00 pm = 18:00

-Eddie

For the second question, the CONVERT function can format dates.  See BOL for all the different options.

To format a date as yyyy/mm/dd, use CONVERT(char(10), DateToFormat, 111)

http://www.microsoft.com/sql/howtobuy/default.mspx

I posted some more info here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=276890#bm277331

The client may be installed on anywhere that is licensed to access SQL Server, either because:

1. the SQL Server was licensed with the per-processor...

If you are properly versioning scripts (each object as a script file), then those scripts should be built using IF EXISTS...DROP / CREATE.

The object must be CREATEd before it can...

Here's something to consider:  Order the EntityAddress table by the order of the classification IDs you wish to check (ID = 2 first, ID = 4 second, etc.) and pull the TOP...

Christopher: close interpretation of EXEC, but the requirement to use EXEC/EXECUTE is when there is more than one statement (the procedure call) in a batch.  You have to use EXEC...

To move a table from one filegroup to another, re-create the clustered index on the target filegroup:

-- SQL 2000 syntax:
CREATE CLUSTERED INDEX [name] ON [table](column, column, ...)