How are you feeling, Barry?

Having reread the last part of your last post: Yes, you did, Elliott. 🙂

I saw your opening line about not really suggesting it and thought your entire...

declare @yourdate datetime

set @yourdate = GETDATE()

select @yourdate

-- here is the syntax for the most efficient execution (avoids converting to char and back)

select DATEADD(DAY,DATEDIFF(day,0,@yourdate),0)

--...

This seems a little clunky, but I think it does what you want.

declare @array table (value int primary key)

insert into @array

select 1 union all

select 2 union all

select 4 union...

No problem. Good luck to you.

I think I must be misunderstanding your last post. The "hardcoded" names were just used to create some sample data. Any query that results in three...

You're welcome Regina. To understand what is happening, I suggest you walk through it one step at a time to see the outputs from the CTEs, what...

This was another fun problem, and a great morning warm-up. The trick here was to use ROW_NUMBER() to provide a sequence number so that you could have unique...

Most of the credit goes to Jeff. He taught me everything I know about Tally tables.

Do you understand why the ORDER BY compels the execution of a full table scan? The only way I think you could improve on that would be the...

Quite likely.... and in the end, she solves her own problem. 😛

Regina, do you just require the names of the contacts, or do you need email address, phone numbers, etc?

In a word: Doh! :w00t:

Man, I am really off my game.

We're on the same server right? I was thinking you'd just create the view in the SAME db as the tables, and grant access only to that...

In a word: Yes.