Thanks for the response. I am not sure this will work, because Parent1 and Parent2 need to be returned in the result set, and their order must not change regardless of...

Thanks for the advice.

What is a scale function, and what do I code to create it ?

CCB.

Perfect.

Thank you

CCB

Thanks for your help Noeld / Frank.

Much appreciated.

CCB

How would I do this? (I am new to this)

Thanks

CCB

Can I do this without the OpenRows set, as I am running it from PowerBuilder and I don't think it will like this.

Ideally I want it in a stored proc...

I need User-Defined columns because I am producing a generic core, and most customers also want to store a several other fields. Legislation will also dictate over time that several...

Thanks for the info.

I'll give it a go.

CCB

Hi,

what commands did you use ?

What set up program did you use ?

Thanks

CCB

Thanks for the response. I am quite new to SQLServer hence my ignorance in the setting up of it.

If I want to build the database into an InstallShield Installer, Can...

Perfect.

Thanks.

If I call this stored proc from my app, can any user run this stored proc provided they have been given access to it, or is it only the db...

David Burrows you are a star. It works perfectly. Not sure I really follow it but the main thing is it works. Thanks very much.

Thanks to mcneased also. It wasn't...