My bad... I meant like this >>

Help us help you

Generate insert statements

There's just no need for dynamic sql here... what's the problem??

The Curse and Blessings of Dynamic SQL

All I can find is System.Data on google, but I have no way of testing it.

Then I'd go back to my original assumption... Check out the 2k5 books online, maybe they have the explaination.

I c... too bad you can't do anything about it.

What does the server errlog says?

Does the Windows' log help?

Can you post the table definition, sample data and the incorrect results sets VS the correct on so we can figure it out?

Or maybe this is the error message you are getting!!!

What happens if you move the rank() function in the where instead of the alias name (assuming it's even possible)?

This is just an assumption, but I think the the result set must be created first for the RANK() function to be able to be executed. A little like...

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=226335

Why not add a composite foreign key on those columns?

This is a generated code. I know it can be written in a shorter fashion, but at least it'll get you started :

P.S. MyCn is a global connection...

No clue... never used that parameter. I just found it on connectionstrings.com.

Let me make this clear once and for all : THAT'S NOT THE WAY TO CODE.

What do you need to do exactly?

Also, those kind of questions must be asked before the user hits execute. If you need input after something execute, then you need to ask that question after the...