Cheers Jonathan,

I can build use this as a basis for my queries.

ta, yogi

Hi Gabor,

thanks bud, i think i'll stick to the "SELECT subquery" version.

cheers,

yogiberr

Cheers Jonathan,

It seems that it's better to write insert queries the way you've done it.Was the way I was doing it an older style?

Ta,

yogi

Hi, sorry for late reply.

i eneded up buiding the sql as text, as opposed to a stored proc.

So, I did something like:

dim sSql as string

sSql ="SELECT * FROM " &tableName

and...

Nice one,

thanks for the replies folks.

yogi

Hi folks,

Stax, worked like a charm.I'd say the junior dba is in good hands :-),

the stephen forte weblog in the link is also an eye opener.

cheers.

yogi

Hi folks,

Thanks for all the replies.I am working my way thru them at the minute.(my post was a bit contrived, for the sake of clarity and simplicity)I'll post my...

Hi Jmasden,

Cheers for the reply.

I see that this example works for a pre-determined number of columns.

In my example, a product will have a variable number of corresponding attribute columns,...

Hi Phil,

Thanks bud, I'll look into it.

yogiberr

Hi folks,

Thanks for the replies.

So, I assume then that it must be a major hassle to seriously protect code in sql server?I thought I was on to a good...

thanks Chris.

looks like "database dictionary" will save me a good bit of time.

Magic.

yogiberr

thanks Jonathan.

yogi

Morning Frank,

This has opened up quite a few avenues for me, thanks man.

btw are you a stuttgart or a bayern fan?

yogiberr(glasgow)

hi Bill,

Many thanks for the advice.I appreciate it.

yogiberr.

Hi Bill,

cheers for the reply.

In my scenario I do not presently need the transaction log.(but I will need it in the future for 'point-in-time' recovery.)

so, I have now backed...