List/Grid

Tag Archives: Handy Scripts

MS SQL Server Temp Table

Use Temp Tables to Easily Insert Effective-dated Rows

Have you come across a situation where you had to insert a large number of effective dated rows into a table? Here’s an easy way to accomplish this using Temp tables. Keep reading for a quick tip.

Process in Posting state

Process Remains in Posting State?

Your process has a Distribution Status that says “Posting”, what would you do now? This post has some simple SQL statements that can do the trick.