Thank you. I will try tomorrow.

Finally everything is working..

Thank you very much for your replies..

Error is sloved but not it is going infinity loop

INSERT INTO prizes_seeds (seed_time,seed_time_encrypt)

SELECT distinct tvseed_time,tvencrypt_date from @tableseed_time order by tvseed_time

...

this is a stored procedure..

i am inserting prizes_seeds table from table variable

so that pk value is inserted into prizes_seeds table

INSERT INTO prizes_seeds (seed_time,seed_time_encrypt)

SELECT distinct tvseed_time,tvencrypt_date from @tableseed_time order by...

declare @pass varchar(50)

SET @pass = 'WOhPorN5VIKZl$Eqcz4CR104O'

declare @pass_seed varchar(50)

declare @vai1 int

declare @val int

while (select count(vai1) from testvai )>0

begin

select @vai1=vai1 from testvai order by vai1,vai2

set @pass_seed...

Thank you very much..

It is wokring fine now..

Thank you!

THank you very much..

i got the same result in a simpler way..

select right(vai2, len(vai2) - charindex(',',vai2)) from testvai where vai1=2

Thankq for the quick reply..

i got the expected result by following query...

select substring(vai2,charindex(',',vai2)+1,len(vai2)- convert(int,(charindex(',',vai2)))) from testvai where vai1=2

is ther any simpler way..

Please help me..

can you please send me link

i tried with cast also.. but its not giving the same value..

please help me on this

i want to compare the encrypted_seed_time value with compare_date. How should i write the DATEDIFF with the encrypted_seed_time (when seed_time is in seconds).

Below is the query where the seed_time is...

Thanks for the reply.

SELECT seed_time,seed_encrypt,

CONVERT(int,DecryptByPassphrase(@pass, seed_encrypt)) AS Decrypt_Seedtime

FROM TestTable

if the seed_time column data type is integer, i'm not getting the exact value of seed_time when i decrypt. how to...

i created a stored procedure

in order to display decrypted value..as below

declare @pass VARCHAR(50)

SET @pass = 'WOhPorN5VIKZl$Eqcz4CR104O'

SELECT seed_time,seed_encrypt,

CONVERT(VARCHAR(50),DecryptByPassphrase(@pass, encrypt_time)) AS Decrypt_time

FROM TestTable

i dont know how...

Thank you very much for the reply. we do not want to implement encritpiton through .net (using external way). We want to implement encrytping this time field value through sql2005....