thank you

can you expline me how to use the simple query to achive this ?

thank you

how to convert comma seperated string to numeric ?

go to this link http://www.w3schools.com/SQL/sql_intro.asp

i am using the index hint like

select * from employeeDetails

inner join employee with (index =18) on

employee.id=employeeDetails.id

but i got the following error message :

" Query processor...

For simple query we can use index filter like

select * from employee WITH (INDEX = 2) WHERE colDate > '12/31/2007 23:59:59'

select * from employeeDetails WITH (INDEX =...