TecNQ (5/8/2013)
Thanks Craig. I found that link too (yes I can use Google), but I didn't understand it. Your reply made more sense actually. Thanks
No worries, usually it's a case of keyword choices sometimes being painful and msdn hiding a few pages deep. Heck, I usually ask for help on some things simply cause I can't remember them, so that wasn't intended to be a slight.
If you present the rest of the query and logic behind why it's looking to get those row numbers we can probably pull it apart and look for an alternative if that's part of your requirement.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA