Technical Article

RE: SQL Construct

  • Reply

 try:INSERT INTO UNRESOLVED (CaseNbr)SELECT  T3.CaseNbr FROM  Table3 T3  LEFT OUTER JOIN   (Select CaseNbr From Table 1   UNION   Select CaseNbr from Table 2 &nbspQ  ON T3.CaseNbr =Q.CaseNbr WHERE  Q.CaseNbr is Null


Technical Article

RE: Lookup Table

  • Reply

I also agree with Melanie. As does my friend Joe. In his usual charming style from another list: quote: This is a common mistake that Newbies and idiots often make. They literally do not know what a table is. A table is a set of things of the same kind (as per 1NF and DKNF […]



Daily Coping 3 Feb 2023


Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023


Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023


Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs


Do entry-level cloud positions exist?

By nadolguna

Hello friends. I’m new here, so if this is the wrong place for my...

Configuring Fargate task duration

By akarjendo

Hi everyone! I've been working with a Fargate app recently and I've managed to...

Coding Magic Values

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Coding Magic Values

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers