I dont, i think its mad, but I didn't write the original system, nor can I change it unfortunately.

Lovely

Thank You

Many Thanks for all your help, I have created a temp table at the beginning of the stored proceedure now, which is doing the job perfect.

If I did it this way, would I then have to define all the columns headings/size etc ?

This is my actual stored proceedure

CREATE PROCEDURE dbo.SP_ListProjectSOAs

(

@PROJECTID BIGINT

)

AS

Declare @CountryID int

set @CountryID = (Select Countryid from Project where projectid = @projectid)

BEGIN

IF @CountryID...