Thanks for your response. I agree with you that transparency is paramount, but I want to make sure that I do not sound too limited. I never try to be...

This comment is very insulting.

"Perhaps the reason for my request for additional material is becoming clearer now.

The fact that accomplished professionals, who would usually be able to answer...

I completely disagree with the use of cursors. They are heavy and slow and anything that you can do in a cursor you can be accomplished in a loop and/or...

Simple enough Phil.... And I didn't need a unicycle 🙂

Please refrain from patronizing people. Not everyone is an expert and we are all trying to learn at our own pace....

Hi Phil,

Nice to see you again 🙂

I just need to know what the syntax is to include weekends based on a simple date range. Not sure why you would need...

Hi Phil,

Thanks for the tip. Didn't even notice the apostrophes 🙂

Thanks Alvin. I will try that. Happy New Year to you and thanks for your time 🙂

Thanks for your response.

My issue is that I am not able to get the correct values. The date range values are fine, but the times are off. I shouldn't see...

Thanks Luis, this actually worked. I really appreciate your help.

Luiz,

Pardon my angst today. I have been trying for weeks to get a simple PIVOT example and nothing is working. I have been on multiple posts, but cannot seem to...

I am not sure if I can create a simpler example than this...

Happy holidays!

I am having issues using PIVOT. I have never seemed to truly understand the syntax behind it...

Can someone help me please?????

Dude, I am asking for a simple PIVOT example. I am not sure why this is an issue? Please do not clog up my post with links. I am on...

Thanks very much!

I understand what you are saying, but I don't think that is my issue. I basically need to highlight some full rows. I cannot highlight the column names because the...