The Heap™ – Consultancy ©®

7:43 AM

Morning

2 hours later…

9:47 AM

Morning

10:06 AM

Morning

1 hour later…

Q: Help with a simple WHERE clause please?

11:24 AM

I'm trying to tailor a report on several variables. I'm no SQL programmer by any means so please bear with me. Can I ask please, what is wrong with this statement ? WHERE (Date = CONVERT(DATE, GETDATE())) OR (Date = CONVERT(DATE, GETDATE()-1) AND ShiftName = 'Nights') When using this statement...

yikes

it's raining 👋s

11:44 AM

@PeterVandivier Surprisingly there weren't any close votes on that question

"Too Localised" you figure?

Too localised, and unclear (It returns no data? Maybe, but we don't have sample data so maybe there just isn't any)

better close it quick before all the traffic makes it HNQ 😬

Vérace

12:18 PM

@a_horse_with_no_name "although I have never understood how a table name can possibly be secret" - CREATE TABLE donald_trumps_fave_targets_in_iran(t_name VARCHAR(50), t_lat DECIMAL, t_long DECIMAL, tweet_after_hit TEXT NOT NULL);`... :-)

12:31 PM

@PeterVandivier That thread is a mess

12:46 PM

@AndriyM Yeah, don't know where to start, additional information in 2 separate answers instead of the question, some "try this" "try this" answers

We should just delete the whole thing

Paul White Reinstate Monica

They've effectively made it look like a forum

1:26 PM

Aaron cleaned up most of the mess

1 hour later…

2:34 PM

@Vérace I don't think you can ping a_horse

2:59 PM

Horses are notoriously hard to ping

@AndriyM Maybe adding a comment to one of his answers or a recently commented question by him like this

@AndriyM The Equi-ping protocol isn't supported on SE Chat

I believe that requires a whole different level of inclusivity, for which SE isn't ready yet

We shouldn't discriminate against horses

@TomV-TeamMonica what could be the appropriate pronoun for a horse?

Q: Coding questions

I have a question, which i can't solve. Here are 2 tables: Customers: CityCode CustomerID AccountID תל אביב 1 1 ירושלים 2 1 באר שבע 1 2 תל אביב 3 2 ירושלים 4 3 הרצליה 5 4 Credit_Cards: Credit_card_ind Credit AccountID 0 (no card) 1000 1 1 (card) 5000 ...

code

I cannot edit the first table

3:16 PM

@McNets 🐴/ 🐎

@McNets There is a RTL character before the foreign language part

Maybe Solomon could fix it

code feels like it needs to be blacklisted

@McNets Somehow I managed to poke it in just the right way to get it to align

but it was a frustrating experience

| Credit_Card_ind | Credit | Account ID |
|-----------------|--------|:----------:|
| 1               | 1      | תל אביב    |
| 1               | 2      | ירושלים    |
| 2               | 1      | באר שבע    |
| 2               | 3      | תל אביב    |
| 3               | 4      | ירושלים    |
| 4               | 5      | הרצליה     |

@TomV-TeamMonica tablesgenerator.com/markdown_tables

Even though there is some extra space I think

@McNets I think the width of the (japanese?) characters is slightly different

3:27 PM

Hebrew, I think

Ah yes, google translate auto detect seems to agree with you

First one reads Tel Aviv

@PeterVandivier I wonder, if a horse has no name, can it has a pronoun?

Asking the real questions

3:44 PM

@PeterVandivier yep

ka-boom

@Taryn ?

twitter.com/StackStatus/status/1216748234598563841

Working

3:50 PM

@McNets don't jinx it!

the outage isn't over until twitter says it is

@PeterVandivier twitter.com/StackStatus/status/1216750263660269569

4:06 PM

@PeterVandivier BTW, did you enjoy the spanish experience?

@McNets thoroughly :D

ty :)