To Lynn Pettis:

Noted. 😉

Thanks.

Thank you everyone and hope to hear more from you.

Warm regards,

Mark Squall

To all:

Thank you for the added information. 😀

I will take note of your ideas, tips and suggestions for better construction of my stored procedures. :satisfied:

Warm regards,

Mark Squall

To Thomas Stringer and Lynn Pettis:

Thank you very much as always. It worked like a charm. 😀

yahoo...

To dwain.c:

Thank you for another alternative. I am sure I will use...

To Sir Thomas Stringer and Sir Lynn Pettis:

Thank you very much brothers. It works. :w00t: ... 😀 ... :kiss:

Perfect combination...

QUESTION: why [font="Courier New"]SCOPE_IDENTITY()[/font] was used? Is it...

I understand, but is there other way to erase the previous one? I can no longer change the title of my previous post (I sent a "request" to administrators...

Sir Grant,

Is interim table same as derived table?

Please help me Sir finalize my table. Based from your advice, are these the tables that I will create?

[font="Courier New"]PERSON (column:...

Sir Grant,

Thank you very much for the opinion you gave about my data design (not my original idea so the credit is not to me, just an instruction from a...

To Sir Grant Fritchey and Sir Mark Tassin:

You two have mentioned something about cache. I have certain things to know abut this cache and I hope it is okay...

Dear Ms. Gail Shaw and Sir Mark Tassin,

Hello, thank you for the information and the links you have given to me. I will read them for another added knowledge...