Working on a recent project, I had a task that required me to number the rows of result set; however, I needed to reset the numbering based on the distinct value of a field, or group of fields. I accomplished my task by leveraging ROW_NUMBER() and PARTITION BY.
[ Read More ]
I was recently working on a client project where I had need to create a delimited field from multiple SQL rows returned for a query. To accomplish this I used a recursive SQL query that allows me to aggregate multiple results together into a single string with a delimiter.
[ Read More ]
I was recently trying to add a unique index on a table, and it gave me an error that the index could not be created because the table contained duplicate records across the fields I was trying to use in my unique index. As a result I found a need to remove duplicate records from my table, and decided to share the code I used to do so below.
[ Read More ]
I had a local copy of a WebSphere Commerce database that was performing horribly, and I decided to create a script that would retrieve a list of all available tables for all non-system schemas, and perform a RUNSTATS and REORG for those tables.
[ Read More ]
Working on a project recently I found the need to determine the master catalog for a list of stores within a WebSphere Commerce database. Seeing as a WebSphere Commerce instance can contain a variety of stores, ranging from your traditional Consumer Direct model to a more extensible Extended Site model, I generated the following query which can be run against the WebSphere Commerce database to properly determine the master catalog identifier for each store.
[ Read More ]
