List/Grid

Tag Archives: SQL

Insert into Longchars

Inserting into Record with Long Character Fields

Most of us here follow the good practice of executing our SQL statements directly against the database before using them within an SQLExec in PeopleCode, a view or an SQL actions in App Engines. Even after following this, we might get hit in some situations. Read on to find more.

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.

Expense Sheet Header

Concatenating Rows in SQL Server

Have you ever felt the need to concatenate multiple rows against a particular field into a single row? We can do this sort of row concatenation right within SQL Server rather than bringing the output into Excel and then doing it. Here’s how!

Updating multiple fields with values from another table

Last day we were working with an Application Engine which was relatively simple. It had a single step! We had to update 3 fields of tableA with values of similar… Read more »