Comments by Member 12189753 (Top 2 by date)

Member 12189753 9-Jan-17 21:34pm View

thanks for the suggestion. A price can be added or removed later, but for the current purposes, i need to use the identifier to join with another reference table which gives benchmarks based on the prices and whether the dates are weekdays or not. I will essentially need to extend the logic here to update the indicator based on whether it is a weekday or not. And i see your point on adding strings to rowid's. Is it possible to achieve the solution without using triggers or inserts?

Member 12189753 16-Aug-16 16:37pm View

@David_Wimbley: that makes sense. but this could be unwieldy if the query I much longer. the question I have is a more extensive one. we run a longer production sql in general simplified version of which I have posted in the question. as we are making enhancements, to add in more columns, clauses (where and groupby), which in turn have case statements and conditional logic, etc, we need to omit out the adds/enhancements depending on the system/business line to customize the query per user/group. I am looking for a way either procedurally or using some form of transact or straight sql way to establish this customization.