There will probably be around 20 a day.

Currently I'm looking at wrapping BCP commands ? The client wants to build a 'customer take on' process and what I'm thinking is...

Think I've sorted it now -

I can't put the SQL up as I'm working with MySQL (I know, I normally work with SQL but on this job I have to...

Thank you very much.

I knew there was a pivot in there somehwere but hadn't thought of dynamic sql 🙂

Thanks again

Steve

you could try something along the lines of:

SELECT SPIDEN_ID

FROM SPRIDEN

WHERE SPRIDEN_ID IN ( SELECT ID FROM IDTABLE)

the inner select is the list of IDs and can be in the...

Thanks for your replies guys - I think we have a workable schema for both problems.

Thanks again

Steve

Cheers - this is what I was heading for but need to justify it's benefit over a tree based approach preferred by some of the other developers.

The problem we're going...

Thanks for the replies guys - we are in a design phase at the minute and the meeting kind of split into 2 camps - tree based and relational. I'll...

what ?

The question is too boring to read or you simply don't know the answer ? If you don't know or have nothing to contribute please don't post.

I've used this...

my bad. it was a bracketting problem. doh.

I'll knock up and equiv query.

In the meantime I may have resolved it - there was inconsistent bracketting of restrictions so I think that was producing some funky joins ...

You could try replacing the WHERE IN with WHERE EXISTS (look it up in BOL) as I read the EXISTS is generally much faster than IN as it uses a...

many thanks, i've changed it so that SCOPE_IDENTITY is used as the insert.

i (mistakenly) thought that @@identity was session, once again thanks for pointing me in the right direction ...

so...

many thanks,

i have added extra catches to get the errors in the other inserts ...

about the scope ...

wouldn't the transaction run only within the scope of the stored procedure ?...

am i 'billy nomates' ?

Thanks,

Unfortunately my boss won't buy anything we could write and so we're going down the SQL-DMO route ...

Nice to do some programming again though 🙂

Steve