It's as much MS fault as anyone for being so inconsistent with when you need a semi colon.  For example with CTE's they could have made it so CTE's...

• This reply was modified 6 years, 5 months ago by Lynn Pettis.

The problem is that people are taught to do this as a crutch to insure that the previous statement is terminated by a semicolon instead of being taught...

How are the parameters for the procedure declared?  Are they declared as VARCHAR(somevalue) or as DATETIME?

Give the following a try:

WITH [Cte1] AS (
SELECT
 [T].[Term]
,[T].[TermEnd]
,[RowNum] = ROW_NUMBER() OVER(ORDER BY [T].[TermSort])
FROM
  [Term] AS [T]
WHERE
  RIGHT([T].[Term],2) IN ('SP','FA')
  AND [T].[TermReportingYear] >= 2010
)
,[Cte2]...

This is one reason why I dislike people being taught that a CTE "starts" with a semi-colon (;), because it doesn't. ; is a statement terminator, not a statement...

Take a really close look at your JOIN clause in the final select.  I am not sure what you are trying to do as you have commas after the names...

My only complaint about your code is the semicolon preceding the WITH for your CTE.  When creating a CTE it is required that the PREVIOUS statement be terminated with a...

Please post the code, not a picture of your code.

Also, trying to read your picture of your code I see part of your problem.  CTEs do not START with a...

• This reply was modified 6 years, 5 months ago by Lynn Pettis.

Problem is that the person doing this doesn't care and doesn't test.  He thinks he knows it all and doesn't listen to my recommendations when I can demonstrate that what...

Yea, I can't do that as the production server is at CENTCOM.

Here is the name: Missing_IXNC_auditDetails_processedDate_total_890D7

How about people that just implement missing index recommendations that create a nonclustered index that is a covering index and recreates the entire table?  Yes, I found one in a...

Now, if you also have to deal with data changes in the tables, that is something completely different and probably shouldn't be done in a DDL trigger.

The other option is...

Read about DDL triggers, the information you would need is available in the event data returned to the trigger.

You could create a DDL trigger that would be able to duplicate the create table statements in the other schemas. You would want to be sure the DDL trigger only...