Hello ScottPletcher. Thank you. I have a question.

I needed to change the clause ON to WHERE so that it runs.

However, with NOT EXISTS - I didn't have results, as you...

• This reply was modified 4 months, 2 weeks ago by  JeremyU.
• This reply was modified 4 months, 2 weeks ago by  JeremyU.
• This reply was modified 4 months, 2 weeks ago by  JeremyU.

Jonathan I may need to check again, but I think it works. Thank you!! I really appreciate your help.

Jeffrey not exactly. Query should check Voucher Num. If it has GL Posted then take 'GL Posted'. If it doesn't have 'GL Posted' take 'GL Accrual Reversed' and 'GL Accrual'....

It should check Voucher Num. If it has GL Posted then take 'GL Posted'. If it doesn't have 'GL Posted' take 'GL Accrual Reversed' and 'GL Acrual'

I was thinking smth...

It should check Voucher Num. If it has GL Posted then take 'GL Posted'. If it doesn't have 'GL Posted' take 'GL Accrual Reversed' and 'GL Acrual'

I was thinking smth...

It should check Voucher Num. If it has GL Posted then take 'GL Posted'. If it doesn't have 'GL Posted' take 'GL Accrual Reversed' and 'GL Acrual'

I was thinking smth...

Emperor100 thank you, but that's not what I am trying to achieve. I am not trying to remove NULLs. I very often time have the same row twice but one...

@jonathan-2 thank you, but I don't think I should delete records from the table, I think I should just not select them in a query, is that possible?

@Phil Parkin,  simply a query which removes them from the rows that are selected.

I don't have any CREATE statements. I am just selecting rows from CTE.  But the way how...

I cannot give DDL and sample data. Only that small part pretty much that I gave in the first message and yes, you are correct, I need to write COUNT...

Scott, it is good. Thank you!

Thanks everyone for your help. It worked for me.

Scott, your idea helped me a lot. Thanks!!

Thank you for your help.

Jonathan thank you for help. It was possible to insert ORDER BY in STUFF function but before XML part. I initially didn't understand it. Thanks for your willingness to help.

@jonathan-2 AC Roberts or anyone, do you know if there is a chance to ORDER BY in alphabetical order whatever is a column? Right now they are in...

• This reply was modified 1 year, 8 months ago by  JeremyU.
• This reply was modified 1 year, 8 months ago by  JeremyU.