Hi

Thanks for your replay..

If you run my submitted code you will find decryption data is showing as NULL.

mean Data is encrypted but decryption is not happening

thanks,

Pritesh ...

Hi All,

Got Solution

DECLARE @Candidate table(

id INT IDENTITY(1,1),[Name] nvarchar(200), [Location] nvarchar(200),

Exp decimal)

insert into @Candidate

Select 'Pritesh Patel','Bangalor',2 union all

Select 'Balaji','Bangalor',4 union all

Select 'IRIN','Mumbai',2 union all

Select 'Manju','Bangalor',3 union ...

Hi,

i can use "inner join" or "subquery"

I use Subquery. there is no purpose to use specialy subquery.

thanks

Pritesh

DECLARE @Candidate table(

id INT IDENTITY(1,1),[Name] nvarchar(200), [Location] nvarchar(200),

Exp decimal)

insert into @Candidate

Select 'Pritesh Patel','Bangalor',2 union all

Select 'Balaji','Bangalor',4 union all

Select 'IRIN','Mumbai',2 union all

Select 'Manju','Bangalor',3 union all

Select 'Rajesh','Mumbai',2...

Hi Chris,

My above posted query is wroking fine. I have problem with order by Status.

I wand distinct CandidateIDs from Candidate and CandidateProject table where i want to give priority...

Hi paul

If i create index on same table is there any thing wrong.. insted of view index.

Regards,

Pritesh

thanks Wayne,

I corrected my mistake..