Oh cool, super helpful!! Like I said, I have a lot to learn still! But I'll work my way through it.

Thanks for the feedback!

They're grading side effects. It was cancer drug testing. It was one of those jobs was okay until things slowed down enough that I could stop and think about the...

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

That's how I received them (and by the dozen) - that's why I was wondering how to normalize them in T-SQL . It was a totally screwed up situation where...

Oh wait... I'm so bright somedays, it hurts my eyes. Use a cursor to loop over the column list. After the first 2 columns, count off (1 => column name...

I would break the SupportingDocs stuff out into a separate table with the foreign key (do this in Access) and then import that.  I'd have to play with it a...

Like this?

Setup:

--Setup:
CREATE TABLE WorkData (
 EmpNo INT,
 JobNo VARCHAR(10),
 Hrs DECIMAL(4,2));

-- add some data
INSERT INTO WorkData VALUES 
(8000        ,    'Office'...

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