• A with Z, B with Y, C with X …so on 2) Similarly replace numbers – 0 with 9, 1 with 8, 2 with 7, 3 with 6, 4 with 5, 5 with 4, 6 with 3, 7 with 2, 8 with 1 & 9 with 0 3). All characters other than alphabets & numbers and having ASCII code less than 128 should be replaced by corresponding Extended ASCII characters. (Extended code = ASCII code of current character + 128)

Q)a stored procedure that will accept two input string parameters and will encrypt the data as explained below –

First parameter should be the message to encrypt and second parameter should be the key for encryption. The encryption key must be min. 6 to 8 characters mix of alphabets & numbers. Procedure should perform encryption by adding the key to message. In addition to this, the procedure should also decrypt back the message using same key.

I’ve used this methodology before… very nice! Quick question – how would I add in the ID field to the CSV output field. Ex: CSV column output = Row 1: 1,A,B,C…. Row 2: 2,A,B,C,D,E…. etc. I can get it in my CSV output, but it repeats like so: 1,A,1,B,1,C…

Its very difficult to find an article u r searching for in this blog. I searched Group By , it gave me 81 pages of results. 2 years back this was my favorite SQL site, I used to suggest to my friends about this site,I searched for 30 min in 81 pages then I had no patience I moved on to another SQL site. This is really unexpected from SQL authority site.

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.