• I sure wish JC would get off his high horse once in awhile. His constant diatribe about portability is a joke. Then he berates posters for not making things clear. Has he ever actually looked at his posts? They sure have the look of an archaic programming language that he constantly bitches about attempting to recreate in sql. Why does he try to recreate it in an HTML forum? Seriously...the leading ">>>" went away from nearly every forum ever somewhere around 1998 or so. He comes across as a crotchety old opinionated bastard who is contradicts himself over and over by demonstrating the he himself is guilt of the very things he can't believe somebody else is so stupid for doing. Sorry...needed to get this out. I really enjoy the last year or so where his venomous attacks and mindless ventures into things that nobody in the real world experiences was quite nice. Unfortunately it has ended and he is back. :angry:

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/