Google: TSQL split string

There are loads of threads about stuff like this.

Have you considered using XML, or not doing this at all(!)?

I hope you aren't using a production (rather...

update t2

set description = t1.description

from dbo.Table1 t1

join dbo.Table2 t2

on t1.id = t2.id

--I suspect you're comparing chars to dates, which would slow things down.

--also don't understand why you are looking only at these dates. But you...

>Bigint is 8 byte, not 16.

ah yes, good point. I thought those mushrooms were a funny shape.

>Varchar can NEVER be more effective than numeric. It uses only 26...

I remember in v6.5 in which quoted_identifier was off by default, I used to use single quotes for the outermost layer, then doubles for embedded quotes. So...

And you have to divide the datalength() output by 2 for unicode (nchar etc.) strings.

That won't help you.

BTW, are you still there?

Can you post the individual statements, with their WHERE clauses, and the select from the view, with its WHERE clause? There shouldn't be any significant difference in execution times.

This is unequivocally better than the solution those MS types came up with:

select s.*,t.* from s