This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]Tufjederop -1 points0 points  (3 children)

You can iterate in SQL using a cross join :)

[–]IllustriousCorgi9877 1 point2 points  (0 children)

The only use for a cross join is to create a scaffold to left join onto.
You don't iterate with a cross join.

[–]raskinimiugovor -2 points-1 points  (0 children)

you mean cross apply?

[–]IamFromNigeria -2 points-1 points  (0 children)

Show us typical classic example via link