Lynn,

Thanks for you help Lynn, you're awesome. Below is from your recommendation with minor change to get what I needed.

WHERE start_datetime >= dateadd(hour, -1, dateadd(day, datediff(day, 0, (getdate)), 0))...

The start_datetime for this example would be graveyard shift which starts at 11pm on 4/6/14.

Thank You

Thank You for your reply.

I need records for user selected date. In this example I'm using 4/7/14.

The shifts are;

grave = 11pm to 7am

day = 7am to 3pm

swing = 3pm...

I somewhat have it working by creating a SP on destination server to insert into local table the top 500 records from remote source table and running it as an...

Thanks for replying.

The destination database is a Standard 2008 SQL

I would like to create a sql agent job that would run every 10 minutes. The job would check for new...

I knew it couldn't be that easy. I thought I was doing something wrong in creating PK-FK. I'll do more reading. Thank you.

Thank you for being patient.

To create a FK so the query output would replace the value with the StatusName, from SMS;

On table1 right-click on Keys, select...

I tried the JOIN query separately and received the output that I needed but when I added it to the existing query, it failed.

I guess what I'm trying to ask...