Dynamic Filter and Order By

Question

Post reply

Dynamic Filter and Order By

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

PiMané SSChampion Points: 13965 More actions · Answer 1

Thanks,

Pedro

If you need to work better, try working less...

Jeff Moden SSC Guru Points: 1004439 More actions · Answer 2

Sean Lange (10/2/2012)
It will work but referring to columns by ordinal position is fraught with maintenance issues.

Not to mention that (IIRC) it's been deprecated.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Jeff Moden (10/4/2012)
Sean Lange (10/2/2012)
It will work but referring to columns by ordinal position is fraught with maintenance issues.
Not to mention that (IIRC) it's been deprecated.

And something I have avoided like the plague long before it was deprecated.

_______________________________________________________________

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/

TomThomson SSC Guru Points: 104773 More actions · Answer 4

Sean Lange (10/4/2012)
Jeff Moden (10/4/2012)
Sean Lange (10/2/2012)
It will work but referring to columns by ordinal position is fraught with maintenance issues.
Not to mention that (IIRC) it's been deprecated.
And something I have avoided like the plague long before it was deprecated.

+1

Tom