Let me first say that this is the kind of situation where it's better to sort at the client. But if it's not possible, then read on.

There's a catch...

It's always a good idea to have a clustered index. Make sure you don't just make a clustered index for the fun ot it. Be certain that it's...

I hate to guess... that's why I didn't bother to even try on this one.

No clue... keep me posted .

Can't help you with that.. never used RS before.

Can't you put a label or a textbox for that?

HTH

Select ColorNO from dbo.YourTable where OID = 666 group by ColorNO

having count(*) > 1

Still a pointless debate.

Use what you like and I'll keep using text datatype only when I need to, and it's still not known to be the case here. I've...

Yes just like the car is his, he just doesn't have the ????? box he's an administrator.. or past 5k posts??

Question about >>>> SQL Query Anylizer

nothing about a command object that would make me think it's about the apllication call of the parameter.

Open profil then click My Avatar

between "Your Signature" and "Profil picture"

Would be too hard with a datagrid (might be wrong here, didn't use 'em since I got my diploma).

The idea would be to have a vertical select instead of a...

The can post the table definition with some sample data so we can create the correct query this time.

Is this for reporting purposes, because if it's not, or if it's an asp report, this statement could easyly be done without any temp table nor dynamic sql??