Output from sp_exeutesql .. how ?

abdusalam · June 24th, 2004, 05:51 AM

Hi Vijay,

Quote:

quote:Select @newid = Max(col) From tbl where FK = 1
           /*code that Generates new id according to key spacifications of table
             i mean every table is bounded with spacific numeric values....
             i.e tbl_1 id allowed between 20 and 30 etc
             so here i check table and then check max existing id value
             and then generate new key ....
           */

I need to generate new id after checking number of range which is spacified for given table in string variable ...

hope it will help you more ... to help me ... :)

Stay Beautiful,

Abdul Salam

There is no moving creature on Earth whose sustenance is not provided by Allah. He knows its living and its resting place,
and all that is recorded in a glorious Book. (Al-Quran)

happygv · June 24th, 2004, 06:16 AM

I would like to see the code that you used to do that(if you can post here), so as to get a better picture than suggesting you on what I understand and not getting there still:)

Cheers!

_________________________
-Vijay G

Strive for Perfection

abdusalam · June 24th, 2004, 07:49 AM

I have mentioned already that code is different for each table according to id .... okay

Here is example of table and key cols

   tbls col_key_bound_between
----------------------------------------------------
   tbl1 1 to 30 'mean there are 30 types of orders
   tbl2 31 to 50 '
   ....
   ....
   ....

   actually i am not in office thats why have not code ... so if you got then okay otherwise i will send code 2maro ...

    Stay BeautiFul,
  Abdul Salam