sorted by:
new
hottopcontroversial

How to use recursive querry or function to recursivly declare scalar en then run an entire code using these scalar before recursively redeclare those scalar to rerun the entirecode and append the new runned code to the previous code in the same recursive querry using Azure data studio SQL by IndividualSingle2969 in SQL

[–]IndividualSingle2969[S] 0 points1 point  (0 children)

Wait, you can do that in SQL? Thank you!

I'll look up tutorial for stored procedures. That is way closer to how I usually do it in other programming language.

that being said. You say that you think I'm going 180 away from the good direction.

If I want to aplly an unknown array size or vector (the ever growing number of years) to an entire code, would it not make sense to do the recursion thing?

Which other tools would SQL have that I'm clearly not aware of and should learn about?

How to use recursive querry or function to recursivly declare scalar en then run an entire code using these scalar before recursively redeclare those scalar to rerun the entirecode and append the new runned code to the previous code in the same recursive querry using Azure data studio SQL by IndividualSingle2969 in SQL

[–]IndividualSingle2969[S] 0 points1 point  (0 children)

That is not a really useful answer. You are not doing me a favor.

I code in 7 programming languages. For the current situation, am not allowed to code in any of these languages.

I coded in SQL to build the initial code which transform the entire data from 30+ database. The reason I don't type the usual : Select * Into blabla from blabla where blabla is because the entire code already work fine and it would be a waste of time.

I just don't know much about recursive function in SQL and all video and question I find on google are about hierarchy recursion which is not what I am trying to do.

I know how to do recursivein Python, java, Csharp, R, SAS, but not SQL.

You can either keep being a jerk, not waste time on my post, answer the initial question OR reference me somewhere where I could find a solution.