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,...

Nothing, anywhere, is perfectly secure. There are always vulnerabilities. We just don't always know what they are until it's far too late.

However, I still land where I always land...

There are also hidden dangers to "Autonomy" and that is the danger of being "forgotten" or "pigeon-holed" or coming across as a bit arrogant.  For example, if you answer the...

This is a beautifully written article and the order of revelation is spot on.  Of course, I cannot be sure but it looks like something that AI would write (and,...

One of the things that people seem to forget it that it was almost 2023 by the time 2022 came out.  It may have gone past the "plan the funding...

Although it's more than a decade old, good things don't need to change...

Hi everyone,

I have a directory of many csv files such as

C:\Temp\NP-001.csv

C:\Temp\NP-002.csv

C:\Temp\NP-003.csv

In each csv file, there are 5 columns: Name, DOB, MemberID, Address, Email

We need to somehow loop through each...

That, good Sir, is what I'm talking about being the problem.  That is...

In calculated columns...

I think you may have correctly identified the problem...  Someone who is more knowledgeable about PoSh than I may have a bit of magic that I don't know about but...

If I'm reading all of this correctly, another issue with filtering the calculated columns of a view is that all of the rows must first be materialized and then the...