I really don't think he was concerned. I think he was trying to be a smartass.

I posted a simple question and got what I wanted. I went with the join with...

IRT Sergiy:

It's not the customer related info that gets deleted. It's a unique password to be used in the telephone switch.

You shouldn't be so sarcastic if you don't know...

Do you wipe out all records related to deleted instance before creating a new record with the same ID?

Yes, I do. It wouldn't let you otherwise.

IRT the ones telling me...

Why not just copy the data to a table with a larger identity column?

Because the ID's are actually real codes and they have a max length. I think I'm gonna...

Oh, you meant on the dataase... I meant in the report table...

I'll try having an image column in my databse table...

Thanks

Could you tell me how to do that?

Just use the view (after creating it as shown in the post above) as if it were a table like this:

select * from myview

You can use joins using regular tables and...

I found one.

Here it is FYI: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_0h2a.asp