Question: I need to find only unique cell arrays within a set of cell arrays. For example, if this is my input:

```
I = {{'a' 'b' 'c' 'd' 'e'} ...
     {'a' 'b' 'c'} ...
     {'d' 'e'} ...
     {'a' 'b' 'c' 'd' 'e'} ...
     {'a' 'b' 'c' 'd' 'e'} ...
     {'a' 'c' 'e'}};

```

Then I would want my output to look like this:

```
I_unique = {{'a' 'b' 'c' 'd' 'e'} ...
            {'a' 'b' 'c'} ...
            {'d' 'e'} ...
            {'a' 'c' 'e'}};

```

Do you have any idea how to do this? The order of elements in the output doesn't matter, but efficiency does since the cell array `I` could be very large.

Answer: 
Remove the DROP TABLE #Workflow1; from your query.  

I believe it's dropping the table before the SP returns the data.
Okay i figured it out. Although the procedure should work fine, in fact Pervasive recommends something like this. use SELECT INTO

```
CREATE PROCEDURE "Connect_Workflow"(
     :StartDate DATETIME, :EndDate DATETIME)
     RETURNS(Patient varchar(100) , 
        AccessionNo varchar(25)  
        );
BEGIN
    SELECT 
        rtrim(p.LastName),--+ '^' + rtrim(p.FirstName) + isnull('^' + rtrim(p.Initial), ''),
        v.VisitID   -- equiv to EncounterID
    FROM visit v
    INTO #Workflow1
    join patient p on v.patientnumber = p.patientnumber
    WHERE v.VisitYY = '99'
    );
    SELECT * FROM #WorkFlow1;
END

```