1. Put a constraint on the table to produce error for duplicates

2. Change the INSERT statement to only insert rows not already present

    (use LEFT OUTER JOIN)

Use @@ROWCOUNT, something like this

SET ROWCOUNT 100

DECLARE @rowcount int

SET @rowcount = 1

WHILE @rowcount > 0

BEGIN

UPDATE test_bulk_update

SET updated = 'Y'

WHERE updated IS NULL...

Are you ignoring trapped errors?

e.g. no permission to table

If command fails, ExecuteScalar will return nothing and CInt will convert it to zero.

What are you trying to achieve

SELECT DATEADD(dd,1,GETDATE())

or

SELECT 'DATEADD(dd,1,'''+ CAST(GETDATE() as char(11)) + ''')'

Does your table name contain spaces?

http://support.microsoft.com/kb/q298674/

will give you your answer

Edit:

p.s. I always use fully-qualified column names in my subqueries

Try this

DECLARE @LastName varchar(20)

DECLARE @FirstName varchar(20)

SET @LastName = 'Smith'

SET @FirstName = 'Jo'

CREATE TABLE #temp ([ID] int IDENTITY(1,1), Username varchar(40))

INSERT INTO #temp (UserName)

SELECT l.LastName+f.FirstName

FROM (SELECT n.Number,LEFT(@LastName,n.Number) AS [LastName]...

You cannot use #temp in dynamic SQL

Yes you can

Provided it is...

Notwithstanding what has already been said

Top of the head answer

Create a permanent table consisting of SPID and Username

In SP

Insert @@SPID and Username into...

...the Deleted table is empty for Deletes...

Oh not it's not

...CASE Count(*) WHEN 0 THEN 0 ELSE 1 END AS CountStore...

Or

SIGN(COUNT(*)) AS [CountStore] 

It is not a command it is a label for use with GOTO, eg

start:

PRINT 'Looping'

GOTO start

What is "transform data task"

It is the task within a DTS package that transforms data between the Source...

...the '00' unicode country code in these examples sticks out like a sore thumb...

Thanks Jeff