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

Gary

The easiest way to do it is to right-click on your existing database in Enterprise Manager and choose All Tasks, Generate SQL Scripts, and use the dialog box to choose...

Gary

I take it all of your tables have a date column? Do your tables have foreign key relationships to each other? If so then you'll need to make...

So when you ran that commmand you didn't get an error like this?

[font="Courier New"]Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'MyTable'.[/font]

John

Please don't post the same question more than once. Answered here:

http://www.sqlservercentral.com/Forums/Topic412090-149-1.aspx