In a perfect world, yes.

However we have this DBA.... to cut a long story short ... we don't even bother asking any more.

Doh! (too quick to post before engaging brain)

I've solved my immediate problem without using RANK at all

; WITH RankedData AS (

SELECT pKey,

...

Yes Jeff's articles are always interesting, even if you didn't realise there was a problem and can't find an excuse to use his solution.

Now excuse me I've just lost track...

Thanks for the comments Craig

?? II's :unsure: Whats an II? (Some DBA shorthand for developers perhaps Ignorant Idiots?, Itinerant Interns? Infernal Irritants? )

Maybe I'm one as I'm not sure what...

Does anyone know of a code analysis tool for T-SQL?

Perhaps there is something similar to ReSharper - the visual studio add-in.

Yes compliment first. I like it. I'm tempted to go along the lines of

"Its great. It does what its supposed to do, and it follows a...

Hi All.

Its been a while since I've been active in "the thread".

Sorry to barge in throwing you off the important subjects of phone choice and how best to hide...

Its a wierd one. I came across this myself today, and your link did the trick.

Seems the order of creating the alias is important.

I started by deleting everything,

1) run...

Guess I'm resigned to writing the trigger. Thats not the problem, its justifying it to the DBA thats going to be the problem.

Still I learned something...

Thanks,

Interesting blog. I've tried to created the indexed view as I was hoping to avoid the trigger route (for reasons expressed in Gianluca's blog), however I'm getting errors in...

I'm in favour of this change, but I'd advocate just a simple toggle for the OP to mark his problem solved.

And an Icon in the topics view to show the...

Carlo Romagnano (9/14/2011)

---

Unfortunately, the editor to contribute with a question, sometime, changes the text both in the question and more often in the explanation. Yesterday, the explanation of "Unary &...

Thanks,

I'm going with the trigger suggestion.

For completeness Mark's suggestion to try Googling sql nullbuster gave another method: Using a computed field - see the workarounds on this link

http://connect.microsoft.com/SQLServer/feedback/details/299229/change-unique-constraint-to-allow-multiple-null-values

But that...

+1 for Itzik Gen-Gan's Inside SQL Server T-SQL Querying. This book helped me loads, and still does.

His "Inside SQL Server T-SQL Programming" is very good too.

I tried that, but the third-party trigger settings on QUOTED_IDENTIFIER prevented any updates.

Msg 1934, Level 16, State 1, Procedure triggerUModifiedGroupAttribsORDERDATA, Line 2

UPDATE failed because the following SET options have...