Have you noticed that dynamic SQL is more popular today than ever before? There are a number of factors contributing to the success of dynamic SQL. Commercial off-the-shelf applications, such as SAP, ...

Peter continues his series on integrating cascading DropDownLists with databound controls. But this time, he looks at what's different when you're using the ObjectDataSource. In two previous columns I ...

When working with address data, you may encounter situations where you need to merge multiple columns, such as address, town, and postcode, into a single column. Power Query makes this task a breeze.

Upgrade your spreadsheets with BYCOL to consolidate column logic, prevent manual errors, and build automated reporting dashboards.

You've given your users cascading DropDownLists to make it easy for them to find the item they want -- but now your page won't update. Peter has a solution for single-tier applications using the ...