Gazareth (11/6/2014)

---

I actually encountered this exact behaviour last weekend. Got me a bit worried!

My explanation would be that the CTE is never materialised as such, so the rn value is...

:blush: just noticed, had several "versions", this one is no good

😎

Quick thought, there are actually two row_number instances in the plan, one used for the delete and another for the output. As only one row is outputted, the row number...

Alan.B (11/4/2014)

---

Taking this one step further... Why not just replace PatExclude8K with PatReplace8k() ?:w00t:

I like the idea, tinkered a little bit with the code and got the average execution time...

Less than five minutes in vi, slightly more in notepad++

😎

Further on Koen's question, restarting the service is not a blanket solution, in fact the same principle applies here as elsewhere, why "fix" it if it isn't broken? Also you...

Hi and welcome to the forum.

Further on Stewart's answer, have a look at this article, Detecting and Ending Deadlocks

Avoiding deadlocking is best done by design, making certain that resources...

Quick suggestion, instead of nesting IIF's use the Switch statement

😎

=Switch(

Fields!Currency.Value = "USD" ,"'$' #,0;('$' #,0)"

,Fields!Currency.Value = "AUD" ,"'AUD' #,0;('AUD' #,0)"

,Fields!Currency.Value = "EUR" ,"'€' #,0;('€' #,0)"

,Fields!Currency.Value = "GBP" ,"'£' #,0;('£'...

Quick crosstab as an alternative to the pivot

😎

USE tempdb;

GO

SET NOCOUNT ON;

Declare @detail table

(

grn_no varchar(55),

po_no varchar(50),

vendor_no numeric(10,2),

...

Quick suggestion, add WITH NOWAIT to the RAISERROR

😎

BEGIN

BEGIN TRAN;

RAISERROR ('Sorry!You have entered more discount',16,1) WITH NOWAIT;

ROLLBACK;

END

Quick suggestion, change the primary key, something like this:

😎

IF OBJECT_ID('') IS NOT NULL DROP TABLE BasicData;

CREATE TABLE BasicData

(

BasicData INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

...

Quick question, an you post the ddl (create script) for the destination table?

😎

Jeff Moden (11/4/2014)

---

Heh... after 6 years, we might finally...

Almost there;-)

😎

Ed Wagner (11/4/2014)

---

Erikur, I don't know how you got that bit of logic from the decimal values, but well done! It seems to make sense. I was hoping...