Thank you so much @Ant-Green

You're absolutely right. I think I need a coffee....(still sleeping here)

Got it Phil. Next time I won't forget to do it.

And, about the issue itself, my question ...

"I've already test it and it seems working. May I have your opinions?"

Hello @scottpletcher and @SSC Guru

I am really sorry to say but don't even know how to do it and also, I really thought that the way I've explained,...

Sure Phil. Don't worry about it. I will look into it.

Thank you so much

Hi Phil

Thank you for the answer.

Any specific video/course that you suggest for me to learn this? Because there's a lot of them

Hi Phil

It let me do it

The thing is: I even don't know what I've done with this script. I don't have enough knowledge you know? I've spent...

Phil,

I can't create table (nor store procedures for example or views) because I don't have any other database access except for reading. Normally I import data and start working from...

Hi Scott

Thank you for answer and although this issue is already solved, let me just tell you that this table (and all of them) I get it only by importing....

Hi Phil

Yes this time (like you've ask me) I add all the SQL except the FROM which I believe it was not important. I've also add an image of the...

I'm so sorry guys, wrong CASE

(CASE

WHEN CAST(DH.OPENING_HOUR_H AS INT) BETWEEN 10 AND 16 THEN 'Lunch'

WHEN CAST(DH.OPENING_HOUR_H AS INT) BETWEEN 16 AND 19 THEN 'Snack'

ELSE 'Dinner'

END) AS 'Meal Type

This one is...

You're absolutely right Phil. Next time I will add the SQL.

Thank you for letting me know.

Thanks a lot ScottPletcher

Most helpful

Thank you so much for your help Phil

I'm sorry. I don't even know what that means. Can you give an example?

What I want is a column name with text and field name like my example above

Hi Ken

Thank you for your message.

In this case, we don't have the columns "debit" or "credit". We just have the column value and the other column "Nature".  So,

IF Nature =...