SSRS Newbie (8/10/2015)
Any help is appreciated. Thanks.
Can't help but wonder why you want to use CHECKSUM... perhaps the combination of Linked Server and ENCRYPTION is going to cause this INSERT to take a while? Are there any other constraints? Also, I noticed that you are inserting a Name field as well as inserting it Encrypted. Not sure why you would do that unless you are planning on some form of column security on the unencrypted one. In any case, CHECKSUM_AGG() appears to be what you need, or possibly just CHECKSUM(), but the latter only operates at the row level. What do you hope CHECKSUM will do for you?