Recent content by jdraw

Without some examples and not clear on what similar entails, I googled some attributes of Product.

Good one Doc! Reminds me of one I heard years ago. The setting is the introduction of roads and rules, We're introducing the rule that cars must drive on right side of the road..... and if this works well, then in one year we'll adjust to apply same to trucks and motorcycles.

Richard Rost has a multi-part youtube series on an Association database suited to Groups, Clubs, Churches...etc. It may offer some insight on structure and requirements. The first video is here.

wmix, If you provide the table structures/designs including indexes, and the SQL for the query(ies) involved, I'm sure you'll get focused responses. The critical factor/concept is what field or combination of fields in your query make(s) each record unique. Since you have "duplicates", some...

Tony, I totally agree with power needs of the LLMs. I think her comments highlight the "we must all move to EVs to protect the planet (by date xxx)". Where I live (rural Ontario), we can get power failures from time to time-mostly with high winds/storms. The underlying issue is the full lack of...

Hello and welcome to AWF, UseKee!

Here's an example StrConv ("TECH ON THE NET", 3) Result: "Tech On The Net" Parámetros o argumentos texto La cadena que desea convertir. conversión El tipo de conversión a realizar. La siguiente es una lista de parámetros válidos para la conversión. Descripción del valor del...

I have at least 1 site where it is automatic 2 factor authentication and I can get requested to answer a question ( 1 of 3 or 4) that were being used before 2 factor was initiated.

Good point Jon, but I expect the scammers will find a way to infect those new tools and cause havoc. I don't foresee a steady, positive state of things. Let's hope there's more good than harm. I'm thinking of recent articles about new drugs/cosmetics, batteries... only to see that there are...

I think Doc has it right. For a little side entertainment you may find this by Sabine Hossenfelder interesting.

Isaac and Tony, et al The more I attempt to use Chatgpt and CoPilot(Bing Chat) productively, the more I am becoming convinced that the major beneficiaries of these tools will be/are the scammers. As with a lot of technology, the "bad guys" have an intrinsic knack for making the best/worst? use...

Did you try the query I suggested in #4? It should show the unique values in Category.

I agree that readers need to see your table design and some data. Is it possible there is a spelling mistake? You may try Select distinct Category from Contact_People; to see existing Categories.

I agree with theDBGuy---There are several links to Northwind 2.0 Starter Edition here.

Welcome to AWF.