Replace AccountMock with AccountChk in both subqueries. I got the table names mixed up.

Don't use that, it'll be horribly slow. Look for the delimited8kSplit function on this site.

Open up Books Online. Look at the syntax for a SELECT. Look at the examples on the page. Look at your selects and see what's different.

Edit: And buy yourself a...

Tell your manager that a trigger is not the appropriate solution to this. This should be checked in the front end or at the latest in the procedure which does...

Um.......

Replace <column list> with the list of columns. It's a place holder.

And open up Books Online (F1 from in Management Studio) and read over basic SQL syntax for selects...

If you don't want a tested solution, fine (I'm not spending extra time trying to work out data types and write up insert statements)

Something like

INSERT INTO AccountMocktable <column list>

SELECT <column...

No, it won't (won't even compile)

Table definitions (CREATE TABLE ...), sample data (INSERT INTO ...) and expected output please

Yes, that will get the job running (although whether that's the only piece of code withe problem is another matter), you still should go back and take all the stuff...

More readable:

SELECT DISTINCT

C1.containerCode,

C1.containerName,

(SELECT C1.containerCode AS containerCode,

...

VARCHAR declared without a length is VARCHAR(1), so any values assigned to that get truncated silently to 1 character.

p.s. @FromDate and @ToDate should be DATETIME, not strings.

Table definitions (CREATE TABLE ...), sample data (INSERT INTO ...) and expected output please.

Last time I set up mirroring, 75GB database, 25km away, we...

Is google broken today?

https://www.google.com/?q=drop+statistics+sql+server#q=drop+statistics+sql+server

Patience. I'm posting during lunch break, my job takes priority.

To be honest, I'd recommend dropping every single thing that DTA created. You should NEVER blindly implement recommendations,...

DROP VIEW <Name of the View>