WOW!!!

THANK YOU for you time and assistance!!!!!

thanks!

All together I should get 5 records because the order of the GS_DETAIL.Z_ID And the GS_STAFF.Z_ASSOC_ROW don't relate, but for 3354:12 the S_Name is 'Group Sales'

Create Table GS_BOOK

 (

 Booking int NOT NULL...

thanks for the reply. 

i just want to explain my dilema

i have three tables

BOOKING

bookId int uniqueidentifier

bookOp varchar(255)

BOOKING_DETAILS

bookid int

z_id nvarchar(255)

detail nvarchar(255)

BOOKING_STAFF

bookId int

staff nvarchar(255)

z_id_row.

I can create the relationship between

BOOKING.bookId = BOOKING_DETAILS.bookid

AND BOOKING.bookId...

i hate to be a pest, but i was wondering is there a way to sort the

...

UPDATE t

SET t.Z_Id = (t.row_Id - m.MinRowID) + 1

FROM #temp_details t

 INNER JOIN (SELECT Booking,MIN(row_Id)...

Thanks!!!  That worked!!!!