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….

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!

Yours Faithfully,
R3b3l G33k