[col1] = @Value OR [col2]=@Value

?

use OR?

Maybe this one is better?

SELECT x.County
 , x.Gender
 , x.Members
 , y.TotalMembership
 , RelPct = CASE WHEN Gender IS NULL THEN NULL ELSE x.Members/(1.0 * y.TotalMembership) END
FROM 
(
 SELECT 
  County
  ,Gender
  ,members = SUM(ActiveMembers)
 FROM...

Makes it a lot easier to help if you post consumable data in the form of CREATE TABLE scripts...

use tempdb;
go
CREATE TABLE #SampleData (
 County VARCHAR(12) NOT NULL,
 Gender CHAR...

use the standard ROW_NUMBER() with a windowing function, and then remove any where the ROW_NUMBER() value is not 1?

What was it? Use STUFF() or STRING_AGG() with the PARTITION clause?

Well, perhaps not, but how else to you capture update events on a table?

Do you have a trigger on the relevant columns that writes the change info somewhere, or how are you collecting the change information? Awful thin on details.

unless you have some way to order them in insertion order, you can't. You'd need a column that's either an incrementing identity column or a datetime field with a default...

NVARCHAR()??? You sure you need that?

Check this out: https://support.microsoft.com/en-us/office/comparing-access-and-sql-server-data-types-9188f41d-6c0e-4733-9d20-d08916f50bd2?ui=en-us&rs=en-us&ad=us

Access Date/Time data type maps to SQL Server Date/Time data type, not DateTime2.

LOL... Part of the problem is the fact that Access uses VBA to accomplish anything complicated (transactions etc), and uses VBA to manipulate the interface etc. Separating the two might...

Wendell,

Thanks for answering! I was hoping you would.  Super handy list! I'll have to have a read and pass on the links. (Pretty sure I told the OP to post...

• This reply was modified 5 years, 11 months ago by pietlinden.

If it were me, I'd do something like this to identify all the tables containing the column I want...

SELECT ao.name AS objectName
 , ao.type_desc
 , ac.name as ColumnName
FROM sys.all_columns...

• This reply was modified 5 years, 11 months ago by pietlinden.

I just want the first record from TableB.fname returned for each of the 9 results in TableA and then move to the next record.

SELECT A.Col1, A.Col2, BTop.Col1B,...

So far so good. Could you post the expected output of the query you need?