You mentioned "visual foxpro" in your initial post.

Is your visual foxpro frontend accessing simple (DBF)

or compound "foxpro native" databases?

If you can get the xBase data to the server, then you could use OPENROWSET, OPENQUERY to directly read the DBF data in T-SQL.

I use T-SQL & COM to...

Could this help....

-- Make Test "Data"

Select 1 as Num, 'Abc' as Data into #Temp

UNION ALL SELECT 1, 'xyz'

UNION ALL SELECT 1, 'PQr'

UNION ALL SELECT 2,...

Create Procedure sp_B as

Insert into #Temp Select 1

go

Create Procedure sp_a as

Create Table #Temp (ANumber Int)

Exec sp_B -- puts a rec in #Temp...

Create a #Temp table in sp_A, then fill it up in sp_B.

Meiner Eltern sind von Hagen - Wetter (Ruhr). Ausgevandert in '58.

Ich wahr oefters in Deutchland auf urlaub und im fuenften Schulyahr.

My spelling's pretty bad however.

Herzliche Glueckwunch...

Ich habe gedacht das ist geheim ist

Something like...

Select trck#, Pol#

From [Table]

Group by trck#, Pol#

Having count(*) = 1

Is the result set you have in the initial post complete?

I do not get why "B-001-003, 001-111-11" IS in your result set while "B-001-111 112-124-05" is not.

Sorry about that, I did not take the time to make the sample table(s)....

anyway...

Select TheLatest.project_code, Previous.launch_date as Previous, TheLatest.launch_date as Latest

From (Select project_code, Max(launch_date) as launch_date ...

I do not completely understand

Please clarify.

Is there a way to create a single user, non logging database that can be used for "temp" operations?

Something like...

Declare @sql varchar(1000)

SET

What happens if you...

Select SUM( ROUND(TheFloatCol, 5) )....

Here is a quick (maybe inefficient) possibility...

Select TheLatest.project_code, Previous.launch_date , TheLatest.launch_date

From (Select project_code, Max(launch_date) as launch_date

from [Table] A Group by project_code) TheLatest

join (Select project_code,...

Best thing to do, is try it out yourself to gain understanding.

Couple things about cursors...

1. If you can accomplish task without a cursor, try to because a cursor...