Jonathon Prosper (10/25/2007)

I think it might get a bit messy around the interface between BC...

Garbage in, garbage out. If you don't know when or whether...

Can we have more questions where the answer is in the title of the question!

John

Yes. I work in the north of England... if I were based in London then I'm sure I could beat US salaries. And don't forget we Brits don't...

I see. Perhaps points will be refunded in due course.

The explanation appears to explain why RANK is preferable to DENSE_RANK, but not why it's preferable to the other two,...

Wow! What a sweeping generalisation. Europe's a big place, you...

Can I have my point(s), then, please? I gave the answer RANK, but it was marked wrong.

Thanks

John

So what is the correct answer? The answer and the explanation contradict each other.

John

This really isn't difficult. What have you tried so far?

John

OK, so you have to tweak your "@sql=" line so that it inserts @MyCol in the middle as well as at the end. But I'm sure I don't need...

Answered here:

http://www.sqlservercentral.com/Forums/Topic412662-8-1.aspx?Update=1

You need to use dynamic SQL. Make sure you understand the security consequences of doing this. Your query will look something like this:

DECLARE @MyCol nvarchar(28)

DECLARE @sql nvarchar(400)

SET @MyCol...

Are you using SQL Server 2005? If so, please don't cross-post in the SQL Server 2005 forum. If not, please don't cross-post in this forum.

John

Especially if you use incorrect or incomplete syntax.

Gary

I hope you took a backup of hostdb before you started!

Please will you post all scripts you ran so that we can try to see what went wrong.

John