HI,

Ya its really weird as the sync DB database was online but in the scripts processing it cut out he ability of all databases to query themselves from any user...

yes, I cannot have the persId or the percentID duplicated for any record.

That fixed it thank you

Hi,

I have tried all of that, but nothing returns with the Top 1 clause, if I take that out I get records but it multiplies them cause of the many...

HI,

Sry its a datefield.

Hi,

it return multiple records on that side of the Join, but I only want the top record of that group, heres example

strSN ...

Sean,

thanks for the link to applys, wish I had know about these before could have saved me a lot of headaches. thank you

HI, I was only using it to try to get to 1 record, knew it did not work since I was still getting mutiple. Your change works to only...

Sorry hit return accidentally before I could post a result example.

134 John Doe John Doe.123245 2013/12/16 ...

Hi,

yes, I can see the trace, there is only one going, reading something about a defaut trace that runs on sql server, but whomever set up this server changed the...

ok,

decided to check everything and then logged out of SSMS, and logged back in and it gave me the same error.

HI,

I have public and Sysadmin checked,

HI, ok it says I do not have permissions to run the procedure. I logged intot he sql server as an admin and then ran SSMS as an admin,...

Hi Kurt,

Thanks for the info, I dont mind using cursors to do things as such. Until i found this forum (WAY BETTER and more expertise) I was given...

All,

Ok if you are saying a cursor is the best way to do this i'm on board, I know how to do them all quite well just getting tired of...