The reason I used two CTEs is because I have another dataset in which the ID are in two different columns leading to duplicates

With the sample above, I am not...

I think I managed to solve it using two CTEs and unioning them.  I then used another CTE on the combined table to remove any duplicates

• This reply was modified 2 years, 2 months ago by  masterelaichi.

The column in my dataset is not actually SSN. I just used it as example in this scenario to highlight a unique column

hmm, I tried the above code. I end up getting a number ids concatenated together. For example, if ID A00001 has multiple rows on 3 paydates and Id B00001 has...

Thanks for that.  The sample I included was just a subset of my table. The information I am working with is payroll data. The table contains employees with multiple pay...

• This reply was modified 2 years, 3 months ago by  masterelaichi.

That's interesting. A lot you just said which I didn't know earlier! Thanks!

No major problems as such. Mainly just ease of writing queries, that's all. At work, I have noticed that noen of the tables have any query name specified as the...

When I try to run this query on my data (not the sample posted here) I get an invalid object error "Column name" even though the column exists in the...

• This reply was modified 2 years, 7 months ago by  masterelaichi.
• This reply was modified 2 years, 7 months ago by  masterelaichi.

thank you! that did the trick.

That makes sense. Thanks for all your responses!

I am trying to filter the results on the Numdays column. Is it possible to filter the results on an aliased column ? I want to look for anomalies on...

Thank you! this one work perfectly. I will run a couple of checks on the report I require

I am newish to SQl. Is there a difference in using an alias...

• This reply was modified 2 years, 8 months ago by  masterelaichi.

Ah, thanks Jeff!

hi, just wanted to revisit this post. I have been sent another 100 odd files and have uploaded them manually which is really tiresome. Hope someone can suggest a better...

• This reply was modified 2 years, 9 months ago by  masterelaichi.

hmm.. for some reason it says that the last post by me but I can't see it

UPDATE: weird.. I could see only 3 pages and once I posted...