@PaulWhite not really an answer IMO, which is why I left a comment. Because OP says they don't want "any crazy loop" so unclear what they do want, or whether dynamic SQL is the answer, and you didn't provide any actual code (athough now you've added a link to someone else's)
@Zikato So long as the answer is an answer that offers some value without visiting the link, yes
On another note: someone really has it in for me with some serial voting, looks like it's mostly reversed now. Wonder what sort of penalty one gets for it
@Charlieface Of course it's an answer. It's exactly the answer I was thinking of while reading the question and encountering your not-a-comment answer. The link (also originally a comment!) is there as an addition. It is not the only content, such as a link-only answer would be.
argh ! thank you ! i assumed it would take any data file name and retrieve it's data. thanks. — Racer SQLyesterday
@Charlieface I can see who it is. Not someone I'm familiar with. Will check into it.
I've just read a post that's really mundane. It's one of those "just read the error message" type questions. There's an obvious, correct, and incredibly trivial answer I can respond with; but I'm not sure the original post is high-quality enough to deserve a full post in reply. So...
Is the comme...
@PaulWhite Thanks, will keep an eye out. Was kinda weird because that type of thing usually follows some sort of angry conversation somewhere, but can't think where that might have been recently.