To format a short date like MM/DD/YY try the following: select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate For a complete guide to&nb...

[Read the rest of this article...]

SQL, Date, Convert

Syntax: SELECT field1 [ , field2 [ , ... ] ] INTO newtable FROM source field1 Is a parameter that specifies the list of the fields that are to b...

[Read the rest of this article...]

Here's a great sql script to use for the DotNetNuke Reports Module: Select --   AU.Username,    U.FirstName,   ...

[Read the rest of this article...]