I executed the following command for getting XML result:
SELECT job_id, voyage_id FROM job FOR XML RAW
The result will be in a single column. I need this result to be stored either in a field of temporary table or in a string variable. Is it possible in SQL2000? I came to know it is possible in SQL2005, but giving error in SQL2000.