SQL makes the best estimate of the situation at compile time. If the distribution of the data has changed, and the previous execution plan might not be the best. For...

>> .. do a loop statement for the following table <<

Where is the DDL for this table? We don't have loops in SQL! This is a set-oriented declarative language. If...

The terms "child" and "parent" are not part of RDBMS; they come from the network databases and refer to pointer chain structures. In SQL we have "referenced" and "referencing" columns,...

Apparently you don't know that a table by definition, must have a key. Then you don't know how to design a table, even if it did have a key. You're...

As a guy who constantly advocates for ANSI/ISO standards, I would like to point out that the CONCAT is not SQL but local dialect. The correct syntax is in fixed...

I have to tell a story. The choice of the keyword COALESCE () is due to Phil Shaw from IBM, one of the smartest guys that ever served on the...

The name common table expression comes from the way that you factor it out of multiple positions in a query expression and move it to the front. By analogy, it's...

https://www.red-gate.com/simple-talk/sql/learn-sql-server/sql-server-sequence-basics/

Three decades ago, I tried posting super consolatory postings. I tried fixing one and only one problem at a time when somebody posted a total mess. I found out that...

Have you tried using a CREATE SEQUENCE construct?

IIf([var1Title] != '', [var1Title] + ' - ' + [var1Topic] + ' - ' + [var1Name], '') AS Item1

In some cases, the value of var1Name is NULL. Oddly, when var1Name...

Why are you using dynamic SQL? Why are you doing everything with metadata? Why was Dr. Codd so wrong about this AND you are so smart? You might want to...

I strongly recommend that you give up the adjacency list model for an inventory. Use the nested set model instead. You can Google it, or read chapters in my book...

The picture you posted is not a table by definition. It's got duplicate rows! You have no key or constraints. The strings you posted are not how we represent a...

The picture you posted is not a table by definition. It's got duplicate rows! You have no key or constraints. The strings you posted are not how we represent a...