Here's my obvious, brute force answer. Sure seems slow though

DECLARE @Tally TABLE ( Number int)

DECLARE @ThisNum int

SET @ThisNum = 0

WHILE @ThisNum < 10000 BEGIN

INSERT INTO @Tally(Number) VALUES(@ThisNum)

SET @ThisNum = @ThisNum...

Getting back to the design thing though. I'm still not crazy about the "ProctorSlot" table. I guess the first thing that scares me is duplicates. Is there a way to...

That works marvelously! Thanks again!

That makes good sense. I guess I'm paranoid about times, and I tend to over analyze. Seems like times always come back to bite me.

Thanks!

One more thing on this one. I also have a "Holiday" table. Yea, I know it's redundant, I'm working on getting rid of it in favor of the "Blackouts" table,...

OK, maybe this is silly, but here's what I came up with. If I understand correctly, this would encapsulate the entire range of the holiday, right down to the millisecond...

That's probably where I'll end up going. My issue with that is that I have to spin up a new Azure service who's only job in life is to fire...

Thanks Lutz! That will definitely get me over the hump!

I think I see where you're going with the calendar table. Here's what I have so far. I hope this is enough code for you to see what I'm doing.

--*...

Below is the official Microsoft doc on limitations. It seems like every which way I turn, I bump up against SOME limitation. Then there's the lack of tooling. R2 FINALLY...

I suppose the on premis SQL Agent is as good as anything. I'm sure I'll find other uses for that scenario anyway. Thanks!

Thanks MM.

Bit by Azure again. Man, I really need to talk my company off SQL Azure. It is just too limited right now. Anyone out there looking to move to...

Although, I guess I'm still stuck with the same basic problem. How do I start the sproc? Without a SQL Agent, I don't have a way to kick it off.

Anybody...

Perfect, that looks like exactly what I need. The fact that it exists must mean that it's not THAT bad an idea. 🙂

Thanks!

Got it GSquared. Sorry my fault. I don't see the original post when I write my reply and Crazy 8 just stuck in my head. 🙂

I completely agree with you...