The Heap™ – Consultancy ©®

12:10 AM

@Taryn You'll be delighted to hear SQL Server 2017 CU5 is out.

Taryn

12:27 AM

@AaronBertrand Nooooooooo, I just patched!

Tweeted by onlybluefeet on March 20, 2018 at 9:23 PM in reply to AaronBertrand

We knew it was bound to happen.

Joe Obbish

CU5 is boring

that was the consensus of experts after careful testing and consideration

@Taryn Ah sorry haven't caught up on Twitter yet.

1:12 AM

Hey everyone it's me, Evan!

1:33 AM

oh what the crap did they give #TeamTyranny the ability to edit chat posts now!

Pretty soon everything I say just get rewritten. Find Paul White's DBA article on the best hack ever - add Trigram Indexes to inferior databases with sweat and blood!

... I SEE WHAT YOU DID THERE

@EvanCarroll Looks like spam!

Quick ban everyone.

Would save time in the long run

zomfg. Is the president firing Mueller?

it can't be.

why are Republicans hinting that it's going to happen

It's like I want to think he's not that stupid and it's just a malicious attempt to distract from more prominent issues. But.....

Ah, I see Trump told Republicans he's not going to fire to Meuller, and they're using this time to threaten him so people think Trump is under control.

Well that makes total sense.

2:22 AM

In my defense, this is a massive database that was supplied by someone else (probably a MS user). — Amanda 6 mins ago

"probably an MS user" I LOVE IT.

2:46 AM

I'm going to start to CRMing people that speak different languages, and filings their e-mail inquiries with their languages and seeing how many of them I can get to i18n for projects I'm passionate about. =)

Someone from Spain just messaged me, and my GF was wondering about a Spanish phrase. Seemed like I could toss one back. lol

4 hours later…

hot2use

6:53 AM

Morning

Morning

7:45 AM

Morning

Morning

Andy K

8:11 AM

Morning and Evening

8:26 AM

morning

Marian

8:41 AM

morning

mOrning

moRning

Mooning

9:23 AM

This might sound like a dumb question, but what's the easiest way, via SQL Server, of spitting an excel report out that uses a template? I want filtering enabled, currency formatting for a few columns etc. I normally just spit .csv files out, but the end-users for this aren't really computer literate

Q: T-SQL: Export to new Excel file

@Philᵀᴹ Depends on what your template is. If you recreate it in SSRS that would probably be easy

Or you could use openrowset, but if your template is complex that could get messy

This sort of mess

I have a script that does various things and the end result is one large table. I was wondering how I could export this final table to a new Excel file (with column headers as well). I would need to do this within the script.

If the excel template is really complex I'd probably do it in python or .NET (when using .NET use NPOI instead of the office object model, it's much faster)

@dezso, was that question rhetorical? serverfault.com/questions/240813/…

dezso

9:54 AM

@ypercubeᵀᴹ did you want to link Evan's answer?

sort of, yes

2 hours later…

11:57 AM

@ypercubeᵀᴹ That's one remarkably misplaced question (the one in your link).

Sorry about all the doinks

12:22 PM

@AndriyM you mean being in serverfault? yeah..

1:04 PM

Only null-condition is necessary for antijoin. — Kondybas 27 mins ago

Can someone decrypt Kondybas' (3) comments? I can't figure out what he is trying to say.

Seems like a language barrier between us

He is from Ukraine!

dezso

@ypercubeᵀᴹ now that my communication subsystems started working somewhat better, it was nudgical to make him removing the inaccurate assumptions based on the difference

2 hours later…

2:56 PM

@Philᵀᴹ I'm not sure I understand what you are looking for with your question, the approaches are basically documented in the blog post you linked to?

Philᵀᴹ

Different approaches that the original blog author hadn't considered

A: Get all dates from an interval that are missing from other intervals

I did that once many moons ago and went for the decimal approach, and it worked very well, the inserts/updates are lightweight, but it mainly worked so well because the application gave me easy in-memory access to the line numbers of the rows in the grid. Determining the "previous" and "next" row has to be done in the application or it will become tricky

the code basically did
newdataline.linenum = (grid.startat(newline).move(-1).linenumfromgrid + grid.startat(newline).move(1).linenumfromgrid) / 2
newdataline.insert

MDCCL

3:36 PM

If a hotel can never have overlapping seasonal periods, then it is possible to obtain the result as a list of intervals by direct matching of intervals using the method below. First you need to invert the seasonal period list, which means getting the list of gaps between the items of the list co...

Really like that answer

1 hour later…

4:47 PM

Thank you guys

sp_BlitzErik

5:28 PM

+1 good answer (even though it's mysql)

Max Vernon

5:39 PM

please tag your question with the DBMS you're using. Also 'null' <> NULL — Max Vernon 26 secs ago

although NULL <> NULL as well - I just don't want to confuse them even more than they already are.

5:50 PM

Actually we don't know if NULL <> NULL

Q: PostgreSQL select count with dynamic date range

It depends

Has postgres a getdate() function?

Firstly, I am new to this forum. I hope that someone can help or advise me on my issue. Given a User createdAt date and the current date. I would like to retrieve the sum of Friends records for the user with 10 linear time intervals between these dates. So if the createdAt was 30 days ago then...

postgresql postgresql-9.6

@McNets yes, assuming you meana function that returns the current date or the current timestamp ;)

@ypercubeᵀᴹ I thought it was current_date, current_timestamp

@McNets postgresql.org/docs/current/static/functions-datetime.html

@ypercubeᵀᴹ yes, I found it

I'm sorry, I've misread the question

6:11 PM

@ypercubeᵀᴹ I just scrolled up and saw this. I can see that his messages are already deleted. I understand everything is resolved now? Sorry I couldn't help you.

@AndriyM Yes, he replied with "sorry, my mistake" and deleted previous messages.

No worries

Very well

6:45 PM

On other news, we had an upgrade yesterday which failed miserably, after 7 hours of downtime ;)

f**cking ORMs