you cannot combine the two....

one way of doing this would be to save the results of your stored procedure query in a file (could be .txt, excel etc...) and then...

I'm not sure I understand exactly what you want to do but exec stored procedure and insert into are 2 separate statements....

Your stored procedure only selects....can you modify it so...

I would if I could (bend the Law ie...) -

Health & Education - the 2 most important things - & both systems so expensive and unaffordable....

Thanks for all the...

You should look up ROWGUIDCOL on BOL....good starting point!

You could do something like this:

select * from sysobjects

where xtype = 'PK' and parent_obj =

(select id from sysobjects where name = 'TableName')

Not any more Remi - if noel can steal it, so can I!

Mike...my dad was never a citizen so that avenue is closed - as for "whistling up a stick"...so...

And here's my .02 for the day....

HTH!!!

True - actually the # of women is limited and then within that the # of aggressive women is almost non-existent...<;-)

Yelena - are you saying you WANT to see an aggressive post by a gal or that you're looking for one that someone else has referred to ?!

well - you can use a while loop with cursors but then you'll have the wrath of many at scc.com visited upon you! <:-)

If you post the DDLs you're (almost)...

Yes - it all depends on whether there's a shiftID linking those 3 tables - then you can use what Gabor suggested -

...though it's still much neater and tidier...

Once again - we deviate from the original post and meander along to another subject altogether....amazing how this happens almost every single time!!!

Rich - could you post the DDLs of the tables ?!

All you psychiatrists!!!

...well - got what I deserved for calling Remi schizophrenic!

Mike - the very nature of being female gives me the prerogative to vacillate between bloodthirsty and peaceloving...surely you've...

Whoa Remi - as noel advised you in one of the posts - "boy, slow down.." - remember - if you answer aggression with aggression then it spawns violence...that's how...