Thanks all for valuable suggestion,Actually i want to install sql server 2000 first,than

my database and after that my application which is a exe file.All this i want from CD to...

Hi david,

thanks.

vijay

It will not work if table has duplicate row.

for example ,if candidate 1 has xml skill twice or more times in a table.any suggestion for this.because it is possible...

Hi david,

It works.

thanks

vijay

Hi david,

It works.

thanks

vijay

Hi david,

thanks for your asnwer.I am looking for universal query.It should satisfy any no of skill set.In query i can pass any...

I think u add one more column in your table with name like row_totalnull with initial value 0.At the time of insertion and updation of any col, just check the...