great,

I'll look into "oltp" and the "inventory transaction table"

thanks Jonathan.

Hi David,

Ta for the reply.

you asked:

<<

Q) Are regions and/or areas defined by a company, or independently of a company? 

A) BY A COMPANY

Q) Does the database need to keep...

Righto,

I'd say I've a bit of upgrading to do on my dev process.

Ta,

yogi

Hi Gary.

It's certainly a lot less hassle to simply add constraints to a ready populated table than it is to build one from scratch.Cheers for the tip

aye folks,

that's great.Though I am surprised that there isn't an easy way to do it all thru t-sql..probably why i couldn't find it.

ta,...

Hi,

I also wanted to use Preeshi's script as a solution, as it offers other functionality based on the arguments that his script is called with.

I contacted regarding the use...

Hi Kevin,

ta for the reply.It works nicely if i substitute the tablenames with the names of 2 UDF's that contain the queries from which I want to retrieve the result...

Hi,

I am trying both suggestions.

I have tried:

<CODE>

January 20, 2004 at 8:29 am