ColdCoffee is so right; giving us the tools to help you is critical. with 180 posts, I'm sure you've seen the request more than once.

as a freebie, here's the CREATE...

times are now in the millisecond range:

2 rows selected it took 0.002 seconds. ...

not sure how you handle checking in on hte same day someone else checks out; if i leave on 05/07/2009, someone else presumably could check in on the same date,...

awesome that you posted the table structure and sample data; it made my creation of a possible solution and testing so easy. thank you!!!

The only way i see is you...

anthony when i tested, i was getting sub-second query times around 0.700 secs or so according to your page;

i guess we could help more if we saw the actual query...

ally this might get you started:

i made this script a long time ago for SQL 2000, so it does not take schemas into consideration;

it makes the following assumptions:

the PK of...

just syntax...there is no IF<condition>THEN<statement>, only IF <condition><statement>

IF EXISTS (SELECT DATEPART(hh, scheduledtime)

FROM intakesource_daily

...

ok that helps explain the logic, thanks.

is there a master table that has value like this?:

1 Gary

2 Terry

3 Bob

so we could lookup/compare the proper name that...

not enough info;

you have a table with salaries, what does it contain? do you mean a base rate of pay? is it an hourly rate, so $10 dollars an...

terry you'll need to explain the "rules" a bit clearer. I'm not sure why a unique index on the two columns does not do what you want.

i'm just guessing, but...

I'm venturing a guess that you might not be familiar with creating a join on more than one column...like you said, it's intuitive if you had a unique column.

what might...

The views will use the existing indexes that are already on the tables; no...

i had a little trouble reading what you wanted, but i think i got it.

1. you want to create a view for every table in the database, but exclude one...

but with Service Broker, you are sending emails and such, right? I thought the original poster was saying he wants a form to open up on everyone who is...

David with luck this will get you oriented.

you need to open SQL Server Management Studio, and get the object explorer on the left side opened up; once you have that...