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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s