ATTN: Spagbog shatpistons

Walk SQL??

Like this??

With Family As
(
Select s.ID, s.ParentSeriesId, 0 as Depth
From Series s
Where ID = @ParentID
Union All
Select s2.ID, s2.ParentSeriesId, Depth + 1
From Series s2
    Join Family
        On Family.ID = s2.ParentSeriesId
)
Select *
From Family

Or am I no where close to getting that done

you'd have to be using an SQL engine that supports WITH -- it's non standard

I'd be asking them to do it in pure sql. Also I'd be asking them to do it on the spot without googling lolol

 

[Shin]

Walk SQL??

Like this??

How to self JOIN recursively in SQL?

 

[Superfluous]

they all suck

 

[Sephiroth]

you'd have to be using an SQL engine that supports WITH -- it's non standard

I'd be asking them to do it in pure sql. Also I'd be asking them to do it on the spot without googling lolol

DONT GOOGLE MY GOOGLE you nub

Nonetheless I know a bit of MySQL but not on that level. Learning experience

I will research pure sql on for real though.

 

How to self JOIN recursively in SQL?

you need to do a finite depth self join

 

[SuF]

If I ever hire (more) programmers I will quiz them on how they would walk a tree in SQL

can confirm, would fail. my like maybe 20 hours of sql experience would fail me. also can convert also can confirm would learn quickly but not had a reason to yet

 

[Shin]

you need to do a finite depth self join

I'm saying that's the source of where he knabbed the code. Lol.

 

[SuF]

I'm saying that's the source of where he knabbed the code. Lol.

ban him for plagarism plz

 

[Shin]

ban him for plagarism plz

He's too stupid to plagiarize when it comes to programming. LEL

 

[JayiARTS]

#3 boiz

 

I don't really like any of them

 

I don't really like any of them

 

[Shin]

Bump

 

hi

 

[Shin]

hi

yes yes yes

 

[Aklan]

not #3 because i was recently scammed for it

 

[Shin]

Poképedia has been added

http://img.sythe.org/miniranks/ratipedia.png

 

we'll be doing something with this tomorrow tm

 

[JayiARTS]

we'll be doing something with this tomorrow tm

dis shiz is gon be lit.

So if we were to dice away all our 5 starter Pokemons, how do we obtain more?

 

[Shin]

dis shiz is gon be lit.

So if we were to dice away all our 5 starter Pokemons, how do we obtain more?

moar shitposting!!!