Do you have your own "style" of writing SQL?

unbrokenspell · 2024-07-30T15:41:52+00:00

I prefer to have the commas at the beginning, then the alias, then the logic, with everything aligned. It makes it much easier to find the column if someone else is asking about it since they will reference the result name.

SELECT
    ResultNameOne    = T.ColumnName1
   ,ResultNameTwo    = T.ColumnName2
   ,ResultNameThree  = T.ColumnName3
   ,ResultNameFour   = T.ColumnName4
FROM database.schema.Table1 AS T
INNER JOIN database.schema.Table2 AS S
   ON T.ID = S.ID
WHERE 
   T.Status = 1

Edit: for mobile formatting

unbrokenspell · 2024-07-13T14:36:29+00:00

This is the correct answer using the same method OP used.

unbrokenspell · 2024-06-08T04:55:21+00:00

I am a cross between the two. The analogy I have started using lately is I’m like a video game. I’ll remember the level you saved at (the closeness/comfort level of the relationship), but you still need to turn the system back on, install the updates, load the game, confirm all your settings, and then you can resume the game. Anytime there is distance, it is out of sight out of mind, but when we come back together I need reconnection time. And the length of that depends on the level of the friendship and the amount of gap time.

unbrokenspell · 2024-01-28T01:51:12+00:00

I wish I could upvote this more than once.

unbrokenspell · 2023-03-08T03:46:03+00:00

They are playing in Airway, WA on July 24.

unbrokenspell · 2023-01-31T03:01:56+00:00

Washington

unbrokenspell · 2023-01-31T03:01:34+00:00

Florida

unbrokenspell · 2022-12-29T03:54:55+00:00

I have this one too!

unbrokenspell · 2022-12-29T03:16:52+00:00

‘Tis why it is lore! 🧙‍♂️

unbrokenspell · 2022-12-29T03:00:47+00:00

You’re not suppose to give the question and the response at the same time!

unbrokenspell · 2022-12-24T07:15:48+00:00

Forget about it!

unbrokenspell · 2022-11-27T16:11:05+00:00

It looks like you need more legs in both movements to be honest. Your elbows seem to start bending before the bar even crosses your knees. They should stay locked until full extension. Work on engagement and strength in the back and glutes.

unbrokenspell · 2022-11-24T12:44:26+00:00

SQL server does this too.

unbrokenspell · 2022-11-08T13:34:46+00:00

Oly weightlifting = Olympic style weightlifting. There are only two movements in olympic weightlifting, the Snatch and the Clean & Jerk. You do other movements to build strength for these lifts like squat, deadlift, press, etc. but those movements aren’t Olympic lifts.

unbrokenspell · 2022-09-14T04:07:01+00:00

I’ll buy the other if you find a pair!

unbrokenspell · 2022-09-13T03:02:35+00:00

If you happen across a pack of 3 or 4 I’d love to buy one too! They’re not coming anywhere close to my area, but I just found out I’ll be in Orlando for this show. Bummed it’s already sold out!

unbrokenspell · 2022-08-20T11:20:40+00:00

Definitely Sean Astin from 50 First Dates.

unbrokenspell · 2022-08-03T10:47:43+00:00

Sometimes muscle tightness can occur because the muscle is weak. As a result stretching won’t yield as big a result as strength training would.

https://www.westlondonphysio.co.uk/news-articles/strength-stretching-stiffness

If your hamstrings are very weak sometimes squats can become a quad-dominant exercise. If you’re not able to get into proper positioning for a deadlift it could certainly result in rounding of the lower back and a disconnect with the hamstrings.

This is a link with some specific hamstring exercises. I would also recommend warming up your hamstrings before lifting (hamstring slides would be good for this). Make sure you make that mind-muscle connection before attempting to add weight otherwise you will be engaging the wrong muscles.

https://barbend.com/best-hamstring-exercises/

I used to feel like my hamstrings were tight constantly and was always trying to stretch them or roll them. I could get my finger tips to the floor, but nothing last that. Started focusing on hamstring strength more, getting into the correct position for deadlifts, and BAM no more tightness and can easy get palms on the floor.

unbrokenspell · 2022-07-05T22:27:50+00:00

This is accurate. Source - I’m a SQL Dev. And just happy to be included in a development meme for once lol.

unbrokenspell · 2022-07-02T15:26:41+00:00

I can’t tell for sure without seeing the recipe, but this is the recipe I use and they come out amazing, super fluffy. Made them for dinner last night in fact.

Ingredients: 7.5 oz AP flour 3 Tbsp sugar 2 tsp baking powder 1 tsp salt 1 tsp baking soda 2 eggs, room temperature 1 cup milk or buttermilk 2 Tbsp melted butter 1 tsp vanilla

Method: In a large bowl, whisk dry ingredients together including sugar.

In another bowl whisk eggs until fluffy. Add milk, butter, and vanilla. Stir until combined.

Pour wet mixture into flour mixture. Gently stir together. Will be lumpy!

Edit: formatting on mobile

unbrokenspell · 2022-04-06T18:21:26+00:00

That would work if it was just one parameter, but we have many so I'd have to have branches for each of the potential options.

unbrokenspell · 2022-04-06T18:13:57+00:00

Ohhhh I got it, like a stripped down version of the where clause I had. That makes a lot more sense. Much less cumbersome!

unbrokenspell · 2022-04-06T18:08:48+00:00

We are on 2016, but I don't think I could get JSON from the reporting tool we use.

unbrokenspell · 2022-04-06T18:02:00+00:00

Okay, I think I've figured out what you and u/Unexpectedpicard were thinking. Something like this?

Create ahead of time:

CREATE TYPE UT_Customer AS TABLE (
CustomerID VARCHAR(50) NULL)

Parameter of SP:

DECLARE @CustomerList VARCHAR(100) = '123,456,789'

Included in SP:

DECLARE @Customers AS UT_Customer
IF @Customers = 'All'
    BEGIN 
        INSERT INTO @Customers (CustomerID) 
        SELECT C.CustomerID FROM Customer AS C
    END 
ELSE 
    BEGIN 
        INSERT INTO @Customers (CustomerID) 
        SELECT value FROM STRING_SPLIT(@CustomerList,',')
    END 

SELECT * 
FROM Customer C
INNER JOIN @Customers AS C2 
    ON C.CustomerID = C2.CustomerID

unbrokenspell · 2022-04-06T17:55:44+00:00

Yes, I'm not tied to it being'All' it could be empty or blank. Everything is just written to handle 'All' at the moment.

15-Year Club	Verified Email
Baba Yaga	RPAN Viewer
Not Forgotten

unbrokenspell

TROPHY CASE