Casualties?

😎

A non-typecast version

😎

USE tempdb;

GO

declare @eventid table(Eventid int);

insert into @eventid values(31206),(31206),(31206),(31206),(31206),(31207),(31207);

SELECT

E.Eventid

,E.Eventid * POWER(10,2) + ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS New_Eventid -- two...

eniacpx (9/3/2014)

---

We are almost positive the issue has something to do with worker threads, at this point I am just interested in what all of these values tell me. I...

Quick solution, subtract the modulo of 0.01

😎

USE tempdb;

GO

DECLARE @MyPay DECIMAL(18,9);

SET @MyPay = 258.235543210;

SELECT @MyPay = @MyPay - @MyPay % 0.01

SELECT @MyPay

SELECT CAST(@MyPay AS decimal(5,2))

Results

---------------------------------------

258.230000000

(1 row(s) affected)

---------------------------------------

258.23

(1 row(s) affected)

I share Sean's concern here, at least there should be a check for the key-number existence and adjustment if there is a key combination collision.

😎

TomThomson (9/3/2014)

---

Luis Cazares (9/3/2014)

---

xsevensinzx (9/3/2014)

---

Koen Verbeeck (9/3/2014)

---

xsevensinzx (9/3/2014)

---

I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just...

Quick thought, check the lock and sys.dm_os* statistics, chances are that "popular" locks are using up most available Workers, causes connection havoc.

Search keywords: Workers, Scheduling Options, SQLOS, sys.dm_os*

😎

Quick thought, multiply the EventID with 10^(num digits) and add the digits (sub ids)

😎

Quick thought, there is something missing in the code, check that all variables are declared and initialized.

😎

Hi and welcome to the forum. Could you do us a favor and post a create table script and some sample data, makes it much easier to answer your question.

😎

Nice question Stewart, thank you for this.

😎

crazy_new (9/3/2014)

---

Just a quick scan, you have an update table, which is the same table I am deleting and inserting to, I cant update because there are no unique identifiers....

Did a quick little testing, see the results, DDL, data generator and test code below. Code also attached.

Feel free to play around and improve 😉

😎

-----------------------------------------------------------------------------------

Dense set: 1000000 (10000 customers x...

Koen Verbeeck (9/3/2014)

---

And even more important,...

Think that here is a proper use for a TERMINATOR:-D

😎