Mike C (10/17/2007)
Sergiy (10/17/2007)
Mike, it would be nice if you'd pay some attention to the name of the forum.It's on top of the page, between "Home" and "T-SQL".
There is no point to repeatedly post SQL2005 solution not appropriate to SQL2000 on this forum.
Thank you for the constructive feedback Sergiy. I was, however, responding to questions from another poster who asked for specific examples after I mentioned that it was possible in SQL 2005 with censored. I sincerely apologize if my answering someone else's question has caused you undue stress.
To show my sincerity, and to bring this conversation to a complete and total end, I've removed all references to non-SQL 2000-specific sample code, methods, and keywords from all of my posts in this thread. I sincerely hope that relieves your anxiety.
Thanks again!
Mike,
First of all I never requested to remove anything from you posts. Don't lie.
Second, there was no any anxiety from my side, only some nervous reaction from yours.
I'm not a doctor, don't know what to suggest to relieve your anxiety.
Third, you posted same code 3 times. For what reason? Trying to prove yourself insisting on your suggestion?
Bad call, because
Forth, CROSS APPLY sucks in terms of performance, as most of the features introduced in SQL2005. Try to compare it with simple view instead of that table function and see the strong reason why CROSS APPLY should never be used.
_____________
Code for TallyGenerator