2022.01.28 19:26 NewsElfForEnterprise I Was Ready to Perform Live. Then Omicron Hit.
|submitted by NewsElfForEnterprise to News_Entertainment [link] [comments]|
2022.01.28 19:26 pseudoMcLovin Dennis Brown ~ Say What You Say ~ Dubwise
|submitted by pseudoMcLovin to reggae [link] [comments]|
2022.01.28 19:26 Yangoose Elegant way of modifying counts based on other criteria?
I want to know how many red and blue cars I sold using a transaction record. Sometimes we can sell more than one car per transaction in this example but only if the cars are identical.
SELECT SUM(Units) FROM Cars_Sold WHERE Color in ('Red','Blue')
But now my boss says that red cars only count as one unit no matter how many we sell in a given transaction.
I could do this:
SELECT (SUM(Units) FROM Cars_Sold WHERE Color in ('Blue')) + (COUNT(Units) FROM Cars_Sold WHERE Color in ('Red'))
but that is obviously very cumbersome.
Any ideas on a more elegant way of doing this?
submitted by Yangoose to SQL [link] [comments]
2022.01.28 19:26 Dapper_Investment395 LOOKING BLACK GUY FOR FLEX RN
We are looking for a fifth guy to play flex now. Add me ActualHumanTrash. PLease be black (you dont need to be black, but it would it be preferable
submitted by Dapper_Investment395 to LeagueOfDerp [link] [comments]
2022.01.28 19:26 FriendEducational173 upvote me please
2022.01.28 19:26 kennyfromSP69 Stay close to the ground so when you fall it doesn't that much -Unknown
2022.01.28 19:26 AyyeS_ QUIN PLAYS A FEMALE CHAMPION AND HE IS TILTED AS SOON AS THE GAME START.
2022.01.28 19:26 yoda_does_ketamine Lawyers of reddit: what’s the most awkward case you have worked on/encountered?
2022.01.28 19:26 Dyani-LAika wanneer hanwe een reddit video plaatst
submitted by Dyani-LAika to Hanwe [link] [comments]
2022.01.28 19:26 lolita-cake Idk if I look hot or cute today. What do you think? ❤️ (23)
|submitted by lolita-cake to amihot [link] [comments]|
2022.01.28 19:26 tylwylz Trust the science right?
|submitted by tylwylz to WhitePeopleTwitter [link] [comments]|
2022.01.28 19:26 ruizscar UKgov Nudge Unit ‘used grossly unethical tactics to scare public into Covid compliance’
|submitted by ruizscar to DarkFuturology [link] [comments]|
2022.01.28 19:26 cosmobarfuss Januar - Indoor - meine Füsse
|submitted by cosmobarfuss to barfuss [link] [comments]|
2022.01.28 19:26 Pokemanic33 "Converting" a Swep's hands?
Please bear with me if my questions are stupid or noob-ish; I have no experience with Gmod development.
My question, in short, is this: is there a way to take a SWEP that doesn't use playermodel viewmodel hands, and make it use them?
The longer version: there's a Swep pack I really like, but it uses custom hands. I found SWEP.usehands, but it didn't work. Digging into the addon more, I found that the hands were included in the weapon model themselves. That says to me that the hands are "hard-coded" so to speak, but is there anything that can be done to change it besides rebuilding the sweps basically from scratch?
submitted by Pokemanic33 to gmod [link] [comments]
2022.01.28 19:26 hsishekheos Dm me asap no questions
|submitted by hsishekheos to sendmeanything [link] [comments]|
2022.01.28 19:26 UltraRover2529 What is a matchup you'd like to see as an episode of Death Battle, despite the characters having no theme?
More specifically, they have neither any connections or legacy yet you still want to see it as an episode.
For example, I kinda want to see Android 18 vs Terroriser (Dragon Ball vs YouTube) as an episode, even if they have no connections/legacy whatsoever.
submitted by UltraRover2529 to DeathBattleMatchups [link] [comments]
2022.01.28 19:26 HairlessApe Biden Seen Looking At Paint Color Swatches To Choose Next Supreme Court Justice
|submitted by HairlessApe to World_Politics [link] [comments]|
2022.01.28 19:26 crasyostrich It’s confusing, it hurts and I don’t know what to do. I’m trying to better so I can make our relationship better.
It really feels like my partner always backhandedly apologizes to me… Whenever they really hurt me and make me feel bad or let me down, I try to tell them, but then they always say things like ‘I’m sorry I made you feel that way’ or ‘let’s just talk tomorrow when you’re feeling better.. I can tell you need space’
But it kind of makes me feel even worse, as if my feelings are just silly and it’s my fault for feeling this way. What would you do in this situation or what are your experiences of this in a relationship?
I’m so worried if I say something they will say I’m not mentally well or I’m being negative and dramatic again and I will lose them as I know I am the awful one in the relationship… So I don’t have the right to cause a fuss, right?
submitted by crasyostrich to relationship_advice [link] [comments]
2022.01.28 19:26 HelmutKruger The Generals Best
|submitted by HelmutKruger to HiTMAN_CONTRACTS [link] [comments]|
2022.01.28 19:26 wodnesse master of cremations; cw self-endangerment, cw self-harm
2022.01.28 19:26 SatisfactionSimple19 If kirito was transported to our world how do you think he’d react to seeing his life basically televised for our enjoyment
2022.01.28 19:26 NewsElfForEnterprise Beverly D'Angelo to Guest Star on 'Law & Order: SVU' as ADA Carisi's Mother
|submitted by NewsElfForEnterprise to NewsfeedForWork [link] [comments]|
2022.01.28 19:26 Aggressive_Sea_8206 What movie do you enjoy watching from a genre you usually don't care much for?
2022.01.28 19:26 _Selling_Nudes_ https://discord.gg/5daHK7ZQ
2022.01.28 19:26 cheetahgirl-17 if you’re going to billies sf show pls don’t skip
okay soo basically me and some others are doing a fan project where we hold up blue paper over our flashlights during male fantasy. dm me if ur interested :))) we need all the help we can get!!
submitted by cheetahgirl-17 to billieeilish [link] [comments]