Everyone says that PowerShell is an essential skill for the modern DBA... bumping this for Bruin to give people the opportunity to demonstrate that skill. 😀

ZZartin did make a submission...

@steve-2 Collins,

I'm still interested in the ChatGPT prompt that you used to generate the populated test table because it'll help people understand how to use ChatGPT to do such a...

For anyone that wants to do a little analysis as to why the use of OR is so bad and to do a little performance testing, here's code to build...

Here is an alternative that a) does not use an OR and b) does not use a subquery.

WITH TempOrdered AS
(
    SELECT t.ID
 ...

Hi Ddee,

You can achieve the desired result using the following SQL query:

sql

SELECT ID, flag, name FROM your_table t WHERE (flag = 0 AND NOT EXISTS (SELECT 1 FROM your_table...

Heh... I saw no indication of your comment being hypothetical.  I'm concerned that others won't, either. 😉

My personal feeling is that phone numbers for people that have taken a survey are actually no one's business and should not be included in a DW.

Hi, Ellen.  Welcome aboard.

It'll be interesting to see how the ORs in that affect performance on larger tables.  I'll try to setup a larger test tonight.

Preamble:

I know Jonathan posted test code and solution code but his code returns the word "Header" for the "Edge Case" of the "LineType" (my name for the "field") not being...

We are in the process of rolling out SQL Server 2022 to production. Hopefully getting the first environment done after the Summer. The dealbreaker for us was Azure AD...

Ah... my apologies, James.  Based on your request (repeated below), I interpreted it as there would be 1 to 4 "numbers" in a single row.  What you meant was "one...

Thanks to ChatGPT for creating the temp table

DROP TABLE if exists #TempTable;
go
CREATE TABLE #TempTable
(
    ID INT,
    flag int,
  ...

Let's see what the actual prompt for that was, please.

For those interested, here's a link to the prompt that I used and...

You can get it via this SQL code:

SELECT t.ID, t.flag, t.name
FROM your_table_name t
WHERE 
    (t.flag = 0 AND NOT EXISTS (
  ...

How can i adjust the substring to grab from 1 to 4 numbers in the UISeq?

SELECT UIMth = substring(t.yourcolumn, 8, 8) , UISeq = substring(t.yourcolumn, 24, charindex(' ', t.yourcolumn,...