Thanks Ed, that help solved the problem.

Thanks, Clarence

Yes, I did that but it is still only trimming the GUID that I list in the

SET @ACTIVITY = N'updating records for GUID {121212-12121h-121233-dhf3}'

This is the only result I...

Craig,

Will this also work on a column and not just the cell?

Thanks Craig Farrell,

THe column is a (nvarchar(255),null)

The column read as: 'Update record GUID{1231jk-2322yy-2883487-dhe33}'

I can trim the left side giving me the result: '1231jk-2322yy-2883487-dhe33}'

But I need only the GUID: '1231jk-2322yy-2883487-dhe33'

Thanks,...

I just posted a reply not sure if it went through.

Thanks, that helped.

Scott ,

I hope I understood you correctly about the format. I attached an example excel of what I get now when I use my union and what I am...

Scott,

On second thought, you made me realize something about the guid appearing more than once. The GUID may appear more than once. My goal is to create...

Hello Scott,

No the guid will not appear more than once, but of course when I union the two in my script above I get the guid twice, a record...

Thanks for the reply. That was helpful, but it gave me results listing the value for max IN and max OUT. I am needing to see the acutally max...

LutzM,

Thanks for pointing me in the right direction. Sometimes just phasing the question in the correct way makes using google much easier to find the answers.

Thanks for posting, I...

Looks good, thanks for replying to my question. That help set off a light bulb lol. Now I can cross that one off my list, and move on to my...

After thinking about your question, I would need to caputure both new records and any updated records. There is a lastmodified column in the tables I need to copy, is...

Thanks for the repley rollercoaster, I am not able to have replication set up because I do not own the server. And the company that owns does not use...

Thanks Brandie Tarvin. I will give that a try. This has to be a stored proc because I do not have full access to the source server to run...