Nothing is wrong. That's what it is supposed to do.

The row you posted starting with '28129' does not contain the string "Target Domain" so this:

CharIndex(''Target Domain'', Field9)

will return zero, and the subsequent expression:

Pos3-Pos2-15

will be negative

... and http://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/

I think he has, and it's not working. That's the problem.

Check out SCOPE_IDENTITY in BOL here

Another question, what do you do to verify that the update has occurred?

Given your table definition I can see no reason why you cannot do this.

One question, are there any triggers on your Work table?

Particularly when they are in upper case.

Nice editorial Grant, a polite rant if ever...

Wilfred van Dijk (5/5/2010)

---

WOW! :w00t::w00t: that was an easy one! Sometimes you're working on a solution which can be replaced by a very few lines ( I feel stupid :ermm::ermm::ermm:...

robshobs (5/5/2010)

---

Keep in mind that this only works up to 23:59:59. Anything greater than or equal to 24 hours (86,400 seconds) will not work. I have reports were...

An alternative, using DATEADD and CONVERT

select CONVERT (varchar(8),DATEADD(second,@duration,0),114)

... are you trying to do formatting in SQL that would be better done in your application or report?

Your output does not match your supplied data!

You have a row for filename '12-5-09.pdf' in your table which doesn't appear in your output, and two rows for filename '12-4-09.pdf' in...

Alternatively, using a Tally table (see link in my sig) to avoid the loop:

declare @x nvarchar(100)

set @x = 'AZ az' + char(160) + '01' -- note: 160 is an html...

... or in table names, column names, procedure names...