It's pretty much the only way to do this.

Check the execution plan and make sure that the function's query is as optmizied as possible.

I'd also make sure that there's a...

Why is it faster that way?

Select PersonName + Char(13) + char(10) + DogName as FullName from dbo.YourTable

BTW this is something that you should do on the client side, not in the query. It's something...

Maybe you should ask him (as I'm not .net either)... but I don't think that this is what you want.

This is the only possible explanation I can give... some dates are just wrong (not likely as I assume Oracle validates the data), or out of range.

The keyword here is "asynchronus"... all queries running at the same time from the same connection... Looking forward to Yukon .

You need to delete data in 2 different tables at the same time, or you need to delete data in tableA depending on some values of tableB?

Looking for something like this?

Select PersonName + ', ' + DogName as FullName from dbo.YourTable

Note that this assumes that you don't have nulls in the table.

"As long a topic is given the poster will need a much narrower read to make just to understand the issues reading a professionally written material. I consider that a...

Ya, in case you missed the first 25 links in big bold blue underlined fonts on yahoo, you can hit googles ang get 2.5 M links

I'll give him the answer he wants to hear : DON'T look in BOL. It's the only information in the world you can't find in there

Now I meant in the oracle table you wanted to transer .

I don't unserstand how you relate the column name to to tables.. can you be more specific?

(udf_Reverse(substring(@instring, (len(@instring)/2 + 1),len(@instring)) OR udf_Reverse(substring(@instring, 1, len(@instring)/2))))

You can't do that in tsql, you'll have to embed another if.

Not really. The fact that this will be dynamic makes generating this code a big pain. Can't this be static?

Can you provide the actual table script, Sample data...