Yes, and I haven't yet thanked you for the help. I see now that I was clumsily trying to create a datalength function, which I didn't know about. That's what...

I'm starting to get the hang of using these tally tables, but I'm a little foggy on the sequence of events (my experience up 'till now is in purely procedural...

Yes, that worked fine. And it looks (almost) exactly like what I'd tried earlier. I can't imagine what I did wrong, but... oh well.

Anyway, it looks like I just have...

It took me some time to figure out what you were doing there, but it looks like a very clever way to solve the original problem in this discussion. Unfortunately,...

I think I may have found the missing link. Cursors. As I mentioned, I'm very new to TSQL and there's nothing quite like Cursors in any of the languages I've...

I'm afraid it doesn't. I'd already looked through the BOL extensively, but in all of the examples I could find, data was sent to multistatement table valued user-defined functions via an explicit string. That doesn't...

I hope someone can give me a clue here. I'm very new to T-SQL, so this will probably be a stupid question, but I'm obviously missing something fundamental here - I...