DECLARE-ing War!

When…

DECLARE @EndDate DATE;
DECLARE @StartDate DATE;

–SET @StartDate = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) – 1, 0);
–SET @EndDate = DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE()) – 1, -1);

SET @StartDate = ’01/01/2018′
SET @EndDate = ’12/31/2018′

——————————————————————————————————————————-

DECLARE @StartDate DateTime;
DECLARE @EndDate DateTime;

SET @StartDate = ‘You’re not working the way I want you to you stupid thing!’
SET @EndDate = ‘You’re not helping either!!’

…fails, the consensus is Report Builder Sucks! We will get you my pretty! And your little SET too! We just need a house and ruby slippers….

ruby

Thank goodness Thanksgiving is tomorrow! Four days off may just change the queries attitude. I know being stashed in a folder for four days would change mine! 🙂

On that note I leave you with these wise words…

May your stuffing be tasty
May your turkey be plump
May your potatoes and gravy
have nary a lump
May your yams be delicious
And your pies take the prize
And may your Thanksgiving dinner
Stay off your thighs!

Happy Thanksgiving all!!
May your day be filled with Family, Friends, and reasons to be Thankful!

Advertisements

Observations from Under the Desk

Finding random notes on your phone you don’t remember writing….

note

…can make a day quizzically entertaining. I mean, who is Kate/ Kate bush and what is she doing with a hill? Do I need a cipher to understand the rest?

Note: Screenshot is from today, but note details show I typed it at 3:32 am on 10/11/18. Sleep working, or sleep studying? I’ve yet to decide.

Observations From The Big Red Button

bigredbuttonDo Not Push!

The ability of non-techie people to associate every issue with IT never ceases to amaze me. When did IT become synonymous with, “Those who hold the knowledge to fix everything?” We’re a group of people who have a penchants for technology because we’ve read a book, taken a test, or spent time playing around with random technology. We’re geeks!

Our inability to solve every problem non-techie people (or norms as we’ve called them) have can cause some dissension. I have seen people scream in the face of IT support people. I have watch mature adults throw things at IT personnel. I have watched IT people walk away from an encounter crying…and quitting.

Peoples behavior toward IT goes a little like this….

**Random departments managers ink pen stops working. She can no longer write down notes she’s viewing on the computer. Calls IT….IT suggests getting a new pen, or trying a different one she may have nearby. Department manager yells, “Just get down here and fix it. It’s what you get paid to do.” **

**User printed a form from pdf and now cannot find the printed form. Calls IT….”The computer isn’t working. I printed a form and now I can’t find it.”

IT asks, “Do you remember where you saw it last?”

User, “Well yes, it is on my screen.”

IT, “Can you print another one?”

User, “Why would I print another one? I just need you to come find the one I printed. It’s from the computer, and that’s you’re area, right?” **

**Company-Big-Wig emails the whole IT department, along with all of the Company’s other Big-Wigs.

“I have attempted to call IT multiple times now and they never answer. I have a computer problem I need them to fix right now. They are never available. They never answer. Does anyone even work in IT? They all need to be fired and replaced with a competent team of people.”

Big-Wigs calls show abandoned before reaching call queue which means Big-Wig hung up before the phone could ring to be answered. Big-Wig no longer with company.**

**Upper Management Person’s report is not working the way they requested. Approaches IT person currently working to write said report. Starts yelling, cussing, and belittling IT member…because IT is lazy and doesn’t have a clue what they’re doing. Believes monkeys could do better and take less time, etc. IT person politely reminds Upper Management Person the report has not been put out there for testing, yet. She’s still running the old report which…is still broken. UM Person stomps off, no apologies.**

Never once does it cross peoples minds IT holds an amazing amount of power. All of the technology they use is controlled by IT. The majority of norms like IT….because they fix things! IT works to make life easier for everyone; even the rude and inconsiderate.

The list of things IT could do to make life hell for any individual…. well, it’s pretty long, and would be so much fun to do! But…IT generally just grumbles about such incidents in their meetings and go about their day.

People really need to thank their lucky stars that IT personnel are reserved and good natured…..generally…..but we do keep our hand on the red button just in case. 🙂

Note: The spark of insanity which leads some people to raise their voice toward any fellow employee is one I question. If this is ‘normal’ behavior for them then I feel for their family and friends. There is never an acceptable reason to yell, belittle, or cuss at anyone. A machine, code, or technology in general…as long as it is inanimate…is very acceptable; even if it is a bit unacceptable by the ‘norms.’  🙂