Are you using a slash (/) or a backslash (\) to separate server from instance name ? Just a guess from experience 🙂

Jeff's article is very nice, but I'll try to give you a direct answer in much simpler form.

In the result, letters A,B,C are unique per row. So, you have to...

If you don't care to have special handling of the error case:

SET XACT_ABORT ON -- in case of error, there will be implicit rollback and procedure stop

Begin Tran

Insert into Table1...

Comment out HAVING clause and if that doesn't help, comment-out WHERE also.

Please use aliases, e.g:

SELECT mt.Name

from myDatabase.mySchema.MyTable mt -- mt is alias from this long full table name

See why your query is slow, what it is waiting for. You can find a very nice sp_who2 replacement here:

http://sqlblog.com/files/default.aspx

It is procedure sp_WhoIsActive from Adam Mechanic, and displays wait info.

Very...

Thank you all 🙂

select * from dbo.Abbreviate(' aaa .. bbb ,, ccccc ')

--Result (without ;):

&#;x20;

Sory, result text was eaten by some html machinery - strange result...

Jeff, what your function Abbreviate supposed to do ?

It seems to me that it does not do much:

select * from dbo.Abbreviate('aaa bbb ccccc')

Result:

a

select * from dbo.Abbreviate(' aaa...

Jeff, did you run the script ?

Jeff Moden (5/9/2011)

You have test code that proves that,...

Why count at all ?

If you want to check that all rows from the source table (tblimportdaily_ageukdif_tvl) are successfully inserted into target table (tblTvlInvites) you could check if @@rowcount after...

I could easily write it in the form of the non-RBAR, but the performance would not be as fast. How many times do we pass through the loop here ?...

This handles different separator characters (not just space),

handles multiplication of the separators (e.g. double space or space at the beggining of the string),

and works from SQL 2000 and up:

DECLARE @string...

Your COMMIT and ROLLBACK commands are both under IF's and it can happen that none of them is executed (e.g. if one of the variable in logical expression is NULL...

My guess is that you should not join "MyTable" several times in your UPDATE statement.

Instead of:

UPDATE MyTable SET .... FROM (SELECT FROM MyTable ...) x WHERE x.id = MyTable.id

Use:

UPDATE t

SET...