By all means. I wouldn't dream of going into production with that kind of password.

Thanks for the feedback Gail

I got it right, using the update statement:

OPEN Symmetric Key HRSecureSymmetricKey

Decryption By Password = N'HRTestPassword'

UPDATE Encrypt_SAL

SET SalEncrypt = ENcryptByKey(Key_GUID('HRSecureSymmetricKey'),CAST(TotalPack AS VARCHAR(50)));

So now I gonna implement....

I use the code below and I get the command which was used to modify, the time, the hostname from where the command was issued and the loggin name (Or...

basicaly what happens here is that when I run this query I get the results below. When you look at those results, you will realise that the four lines below...

Thanks Chris thas exactly what I needed

Hi! Thanks for your feedback. I haven't had a chance to review my original query based on your suggestion.

However this is how I temporarily resolved the ad-hoc-

Step 1 ---->

CREATE VIEW...

Thanks a lot Franky that is exactly what I needed and more. Actually with that help you have now opened up the posibility of a dashboard for me.

Your help is...

Thanks for the replay I will give it a try and let you know

Hi! the structure is like this.....

Table relations.

Headcountdec -- Contains headcount info. eg. Staffno, callname, surname and branchdetails

Positions -- Contains position details but for this query it has a field called...

Thanks. That's exactly what I was looking for. Thanks everyone for your input

OK.

I have a table IRchair which has columns staffno and clusterid. I am going to add to this table a clumn named period. So I need to bring into...

I did and its working fine.

Thanks

Thanks a lot.

That was helpfull, I was looking for the average tenure for each branch not individuals.

Thanks again

Thank you it is what I wanted.

Thank you very much. It works. And it's fast again