No because a view is not a table, you can add a column to a table but you only add a column in the select of the view (view definition).

Are...

Can you expand a bit more on the task at hand??

HTH.

I don't remember the actual exact reason for this, but what happens is that the crlf gets cut on 2 separate lines so it stops working. ...

from (fooTable foo

inner join barTable bar on foo.id = bar.ForeignKey) is an inner join

..., #tmpDates >> is a cross join

but if you...

Make sure you have a covering index on those 2 columns (assuming it's not already included in the clustered index). That'll allow the server to use an index instead...

You're working backwards... do the work from the other server, everything will be easier that way.

Good, then I can go back to my perfect self >> back into character .

Can you send a sample name from a Bulgarian costumer?

The concat method just can't work faster than the normal sql methods... but I'll trust your tests on this one.

I meant...

Can you post a sample script that exposes the problem >> create tables, triggers, keys, indexes, relations and constraints.

Insert data, run query where the data balances,

reinsert new data that makes...

Yup, but unfortunately I can't give you confidence so obviously my makers didn't make me perfect, yet!!!!

So your programmers never fail to validate data and there's no way that a new data import procedure can screw up the data????????

Do you have comments around that line? I know there is a little interpretation bug when that happens.

What do you want to do exactly??

Doubling it is simpler... just an easy s/r.