From what I've experienced, a table in...

If you are inserting one "lock" row at a time, you can do the insert and then the latest lockid would be available with "scope_identity()". If you are not inserting...

post deleted

nilknarf (9/22/2016)

---

I ran

select * from IDCARD where try_cast( barcode_comp as int ) is null;

and still get

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar...

I have reformatted this post to help SSC's team of experts assist the OP

(case when [ID_NUM] like 'AE%' then CONVERT([varchar],(111210000000.)+CONVERT([int],substring([ID_NUM],(3),(20)),(0)),(0))+right(CONVERT([varchar],CONVERT([int],substring(CONVERT([varchar],(((((case when CONVERT([int],substring(CONVERT([varchar],(111210000000.)+CONVERT([int],substring([ID_NUM],(3),(20)),(0)),(0)),(12),(1)),(0))*(2)>(9) then CONVERT([int],substring(CONVERT([varchar],(111210000000.)+CONVERT([int],substring([ID_NUM],(3),(20)),(0)),(0)),(12),(1)),(0))*(2)-(9) else CONVERT([int],substring(CONVERT([varchar],(111210000000.)+CONVERT([int],substring([ID_NUM],(3),(20)),(0)),(0)),(12),(1)),(0))*(2) end+case when CONVERT([int],substring(CONVERT([varchar],(111210000000.)+CONVERT([int],substring([ID_NUM],(3),(20)),(0)),(0)),(10),(1)),(0))*(2)>(9) then...

Eric M Russell (9/22/2016)

---

I'm sorry, but this is hands down the worst sample of SQL posted ever. It looks like a hex dump. Conversion error in Line 2? Where is...

Steve Jones - SSC Editor (9/8/2016)

---

I had a report about this thread. I think it's a valid discussion, and as long as everyone remains respectful, that's fine.

There have been a...

Jeff Moden (9/7/2016)

---

patrickmcginnis59 10839 (9/7/2016)

---

Jeff Moden (9/2/2016)

---

On 2)

A lot of people will answer yes or no on this without clarifying and it could be a trick question. In my...

Jeff Moden (9/2/2016)

---

On 2)

A lot of people will answer yes or no on this without clarifying and it could be a trick question. In my mind and in the...

ThomasRushton (7/27/2016)

---

From the SSC homepage:

The spam does make me wonder how many of those 1.86M DBAs...

If you are worried about saving your...

Looks like you're getting there. Check out these queries! And as always, test the heck out of your work in a development environment! Don't forget databases that might have multiple...

Ok interesting that they suggested (partially) what I was thinking would work but with the XLOCK and HOLDLOCK hints. So is that suggesting that having the criteria in the...

While I'm not sure about your stack of insert and update statements, maybe you could take advantage of the already existing "where" clause.

for instance:

insert into MySchema.MyCasesTable

...

David.Poole (8/8/2016)

---

That pretty much sums it up for me. No-one sets out to write bad software. ...