Alvin Ramard (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 to read...

Reminds me of an old story, once upon a time the...

Quick solution (if I got it right 😉

😎

USE tempdb;

GO

;WITH BASE_DATA(Ticket,[User],[Priority]) AS

(SELECT Ticket,[User],[Priority] FROM

( VALUES

('A','ME' , 1)

...

Ray K (9/3/2014)

---

Eirikur Eiriksson (9/3/2014)

---

Ray K (9/3/2014)

---

Eirikur Eiriksson (9/3/2014)

---

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

Ray K (9/3/2014)

---

Folks, you're...

CELKO (9/3/2014)

---

Why are you...

Koen Verbeeck (9/3/2014)

---

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...

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)

😎