Windows Server 2003: IIS not running aspx pages

Usually indicated by a "page not found" error even though you can get at static files like images, stylesheets, etc.

1. Open IIS


2. Expand Web Service Extensions


3. Make sure ASP.NET v1.1.4322 and ASP.NET v2.0.50727 are both allowed


4. If v2.0 is missing, run:aspnet_regiis -i from the command line to add it

XCOPY: Exclude .CS and not .CSS

Add the following to your exclude text file:
.cs\
Example:

From the command line...
xcopy c:\from.path c:\to.path /D /E /Y /EXCLUDE:exclude.txt
With the following exclude.txt file (relative to the working directory):

.config
.sln
.suo
.csproj
.vbproj
.cs\
.vb
.pdb
.refresh

Note: I know robocopy exists, I just haven't messed with it.
Note: "XCOPY /D /E /Y" copies all files and directories recursively without prompting

SQL 2005: CTE Example

WITH MyCTE (Col1, Col2) (
SELECT Col1, Col2 FROM MyTable
UNION
SELECT Col1, Col2 FROM MyOtherTable
)
SELECT * FROM MyCTE