I dont map it...

When going to Edit Mappings, I have ignore next ID

I tried both ways checking and unchecking that box and it still failed on me...

Thanks guys, I tried using this (CTE) and it seems to come back with expected results!

I have go back and check the business rules regarding this to confirm this...

No I am not familiar with CTE's...I have never worked with them!

Guys,

This has gotten overblown...

When I first posted that sample code stuff and realized it wasnt formatted once I finished posting, I remembered that there was a specific way yall like...

Yeah no offense but my view is much larger than that, and i was trying to dumb it down...

I have tried using the MAX function, but it does not work...

I apologize, I forgot the formatting does not reflect how it was typed in the message...

I remember now that you have to create custom code to reflect what I am...

Here is a sample result set:

InvoiceID DueDate GroupID SubscriberID

101 ...

Yes I have but just adding MAX to invoice id column does not work...

Yes GSquared showed how I can use the derived tables to get what I was needing! Didnt even think to use those...

Thank you all for your input and like I...

I apologize for the way I presented my question...I do realize you all are just volunteers and I appreciate everyones work on the website...I have been helped many times from...

I understand your point of view...Give me a lil bit and I will revisit this!

Not sure what else you want...

I gave you my expected result set, the query I was using, and the result set it gave back...

Does it look like what is exactly...

Apparently I need a crash course on encryption...This gets really confusing...

I am not sure how I will move forward but I will somehow someway! lol

Thanks to all that have responded...

seth delconte (5/30/2012)

---

This statement simply encrypts EXISTING SSNs:

OPEN SYMMETRIC KEY Key_01

DECRYPTION BY CERTIFICATE DatabaseA01

UPDATE dbo.TableA

SET SSN = ENCRYPTBYKEY(KEY_GUID('Key_01'), SSN)

CLOSE SYMMETRIC KEY Key_01

If new records are being encrypted as they are...