The @decode_string needs a slight adjustment, moving the decode value for "255" to the end of the string.

As there's really no need to recompute the string every time, let's just...

I don't think it's really that complex.

I suggest a single lookup/"decode" string, with eight bytes per ip code; I'd also use a leading 7 "filler" 🙂 bytes, just to make...

dr.mannhattan (4/9/2013)

---

ROUND(ISNULL ((SL2.Importe - SL2.Propina - SL2.ScAmt) -((SL2.Importe - SL2.Propina - SL2.ScAmt)/ 1.16),0), 2, 1) As ImpIVA, --the final ", 1" on the ROUND function "tells" it to truncate,...

SQL will automatically cast the result to the receiving data type; cast will automatically round.

To prevent rounding, you can explicitly use the ROUND function yourself (kinda ironic):

ROUND(ISNULL ((SL2.Importe - SL2.Propina...

Turn on trace flag 1222:

DBCC TRACEON ( 1222, -1 )

Then when a deadlock occurs, SQL will put detailed info about the deadlock into the SQL error log.

Rebooting will not help...

rarascon (4/9/2013)

---

One more thing, I did wind up having to add a new column, because as Sean mentioned the original column as varchar is always going to be a thorn...

STUFF(TheDate, 3, 0, '/01')

Would convert 'mm/yyyy' to 'mm/01/yyyy'. You could then use it as a date, either implicitly (somewhat risky) or explicitly, 100% safe but you have to use...

I don't think that's true. If it is, it violates...

In SQL Server, temporary tables start with # or ##, such as #table or ##table.

IIRC:

SQL will automatically destroy # tables when the connection ends.

For ## tables, under SQL 2005 and...

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/4/2013)

---

Lynn Pettis (4/4/2013)

---

Not saying I am right or wrong. I wanted a straight answer to a straight question: Is it a problem to lose the data...

Lynn Pettis (4/4/2013)

---

Not saying I am right or wrong. I wanted a straight answer to a straight question: Is it a problem to lose the data if there is...

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/4/2013)

---

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/4/2013)

---

You're vastly more likely to lose a single connection than have the entire instance go down, which would kill a temp table from that...

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/4/2013)

---

You're vastly more likely to lose a single connection than have the entire instance go down, which would kill a temp table from that connection as well.

I...

Agree absolutely. Can you not specify any time of date range to help limit the rows to be processed?

And, what the heck, maybe try this first too:

SELECT CASE WHEN...

rajarshi_ghosh_05 (4/4/2013)

---

ScottPletcher (4/4/2013)

---

It sounded like one of those types of processes, where you basically just need a temporary "cache" of results / report. Typically those are easy enough for...