This query works, but still returns 9 results. =(

Thank you Jayanth and OPC. The merge looks to be just what I need. I am relatively new to SQL, I took a few database courses throughout college that included...

Okay, that worked perfect. What was my issue? Was it because I wasn't joining the tables or did I need to alias each table or both? Would the following have...

but what would I join on? I need to use the like operator to compare the two strings and pull the rows that match.

-Danny

but what would I join on? I need to use the like operator to compare the two strings and pull the rows that match.

-Danny

Thanks, I am looking for more of a how-to for all the tasks a DBA may be doing so I think the book you contributed to would be a better...

That worked perfectly. Sorry for my lack of experience and thank you again for your help and patience!

I tried this code but recieved the following:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'seed'.

Sorry, Ive added the field, but how do I populate it with autoincremented values?

Thanks!

THank you all for your help!

Sure,

When I changed the field to datetime in the GUI in SSMS, it gave a warning that there may be some data loss but allowed me to proceed. I then...

Thanks, I got it!