@PeterVandivier the evidence is clear.

@JoshDarnell Gandalf the Grey becomes Gandalf the White

Paul has always been White of course!

Morning

Morning

morning

Morning all

Good morning

m

Morning

Morning

select CASE WHEN DATEPART(HH, GETDATE()) >= 0 AND DATEPART(HH, GETDATE())<12 THEN 'Morning' ELSE 'AFTERNOON' END as Heap_Greeting ;

@Philᵀᴹ there should a special greeting when HH is less than 0 :p

You'd better hope Aaron doesn't see that HH sqlblog.org/2011/09/20/…

@Philᵀᴹ select CASE WHEN DATEPART(HH, GETDATE()) >= 0 AND DATEPART(HH, GETDATE())<12 THEN 'Morning' ELSE 'Morning' END as Heap_Greeting ;

Fixed that for you

SELECT DATEPART(THEHEAPGREETING, GETDATE());

DATEPART(THEHEAPGREETING, ...) is the only variation of the DATEPART function that is deterministic, because it returns a constant value.

@AndriyM hahahaha

@PeterVandivier that's an interesting point you've raised. I hadn't considered DBATools powershell could be here.

I would potentially argue that his question is less about DBATools functionality and more about Powershell semantics though

because effectively what he's saying is "The DBATools functionality has worked - how can I double check it with the file system" which isn't really to do with DBATools itself

but then AGAIN, the premise of the question itself still pertains to DBA's directly.

I've just flip flopped twice in my own head on that.

It’s not a good question imo

The root of it is “why is my powershell breaking”

But the asker hasn’t quite figured that out and hasn’t tidied the question up to a point where it’s easily answerable

But it’s not gonna get a good answer on SO

The slack channel is their best bet for productive help

@PeterVandivier I'm not sure that should be a reason not to migrate it?

But yeah it's not a well formed question at all

i believe the probability curve of "this-question-becomes-good" has a higher median value on dba.se than on SO

@PeterVandivier I bloody well hope so. Leafing through SO is like descending the circles of hell

in the "if-this-question-were-good-it-would-belong-at" curve, SO wins

I suppose ultimately it could sit in either site quite happily

but i don't have the motivation rn to lovingly curate it, and i think the biggest "help-for-effort" return is to dump it on slack

Yeah their slack is usually very helpful

@George.Palacios is the question happy?

it does not spark joy for me

@PeterVandivier Well I'm certainly not

lol

It'll probably just fizzle into the DBA.SE oblivion regardless

Morning

☝️this guy gets it

@PeterVandivier or just got up late

Nah, it's a bug in the altered query above 😂

it's not a bug, it's a feature

@PeterVandivier Closed - By Design

☝️this guy gets it

The code now actually just looks like this

--select CASE WHEN DATEPART(HH, GETDATE()) >= 0 AND DATEPART(HH, GETDATE())<12 THEN 'Morning' ELSE 'AFTERNOON' END as Heap_Greeting ;

Print 'Morning'

/* TODO: FIX THIS */

hahahaha

love that

HAHAHA

brilliant.

You can do multiline code by clicking the fixed font button.

twitter.com/DBAReactions/status/931893334490087425

RIP twitter one-boxing

@JoshDarnell Ooh interesting thanks

I want to start a website called SQ-HELL which will be solely for submitting terrible, terrible code

Finally the internet will have a page where we can sit and laugh at other peoples bad ideas.... Wait a minute that's just the entire internet

@George.Palacios "Bad habits to laugh at"?