Days since I last had to look up the T-SQL PIVOT syntax = 0 - ThreadSky

cathrinew.net • 87 days ago

Days since I last had to look up the T-SQL PIVOT syntax = 0

Comments

I don't think I'll ever be able to do that without looking it up... I'm already proud of being able to do window functions without having to check 😂😎

spaghettidba.bsky.social•87 days ago

Surprisingly enough, I remember this perfectly but I forget people's names and faces. Not sure what this says about myself...

tw33tzr4kidz.bsky.social•86 days ago

Yah, you just earned a follow for this post.

kilgor3trout.bsky.social•87 days ago

I've used pivot twice I think... I tend to just write a metric butt pile of outer applies makes the SQL easier to write, but the query a lot longer... It might impact performance, I'll let others weigh in on that.

notursriram.bsky.social•87 days ago

I mean… who doesn’t… every single time 😂

dhma.ch•87 days ago

PIVOT and UNPIVOT are syntactically dumb and hard to remember. I will always just build my own T-SQL variant instead.

sqlgene.com•87 days ago

I thought this is what we invented LLMs for

buckwoodymsft.bsky.social•87 days ago

Well, that and RegEx/Vi

sqlgene.com•87 days ago

I'm not going to argue with Mark Russinovich
https://bsky.app/profile/markrussinovich.bsky.social/post/3lc6o5vch4g2x

dhma.ch•87 days ago

We’ve reached singularity.

bweissman.bsky.social•87 days ago

x! also works…

buckwoodymsft.bsky.social•87 days ago

I mean, what more do you need. Once you can exit VI, the simulation stops

wizardjosh.bsky.social•87 days ago

Maybe a macro?

tarynpivots.bsky.social•87 days ago

How dare you have to look it up???

sqlgene.com•87 days ago

True T-SQL devs can recite the 4 XML modes from memory.

codykonior.bsky.social•87 days ago

Rudolf… Prancer… Dancer… oops wait wrong ones.

sqlgene.com•87 days ago

The most famous reindeer of all, XML RAW!

mikasutinen.bsky.social•87 days ago

Hahah, this is so true 😅 created myself a template just for this one.

sqlwaldorf.bsky.social•87 days ago

The first thing I teach my students in the T-SQL class is F1 (no @spaghettidba.bsky.social , not the sports, the key)

spaghettidba.bsky.social•87 days ago

LOL

jamesmward.bsky.social•87 days ago

EVERY.SINGLE.TIME

Posting Rules

Be respectful to others
No spam or self-promotion
Stay on topic
Follow Bluesky's terms of service

Comments

Posting Rules

Reply