However, there are just as many, if not more, where it shouldn’t be used. I have found some applications for which this stored procedure was the ideal solution – I hinted at these in the first paragraph. It’s a balancing act that demands careful consideration. Just because it seems that you can’t do something, it doesn’t mean you shouldn’t. True, but I for one think that the opposite is also applicable. It has also been said that just because you can do something, it doesn’t mean you should. Anyone who has tried to pound data in SQL into a meaningful set of information, using a complicated set of business rules, will probably agree that SQL tends to discourage you from doing so, and the more fancy and creative you try to make your solution, the stronger that discouragement becomes. The SQL database engine’s primary role is the storage and retrieval of information, not the complex processing of it. There is a general rule which states that data manipulation of this sort is best left to the application or reporting levels of the system, and for good reason. It is for these exceptional cases that I decided to write a dynamic cross tab stored procedure. You’d like to export some data, already set out in the required format, to a text file.You are using a legacy application that you’d rather not fiddle with.You may be using a reporting solution that doesn’t provide this functionality.
It won’t do to have the reporting system do it, nor is it feasible to build that functionality into the application.
Sometimes, you just absolutely have to generate a cross tab in SQL. Tables must contain the same number of columns in each row and rows in each column TR must be a child of Table, THead, TBody, or TFoot Other elements that require alternate text
Tab order is consistent with structure orderĪlternate text must be associated with some contentĪlternate text should not hide annotation The checker found no problems in this document.Īccessibility permission flag must be setĭocument structure provides a logical reading order Acrobat Accessibility Report Accessibility Report Filename: Pivot CPA English PIVOT_ENG_November_December2018.pdf Report created by: Organization: