Re: create/using type dynamically

"hitchhikar" <reachsonu_at_gmail.com> wrote in message news:1141418779.293361.261830_at_t39g2000cwt.googlegroups.com...
> Ok Morgan..the busines case is like i hav gt 100 key. Each key has one
> or more value. Each key is associated with its own table.
> Now i am looping thru the keys in a proc .Now for a key, based on the
> keytablename ,i want to create a type and then iteriatin thru all the
> values of that key want to use dynamic SQL and FORALL to update that
> table ..and thn go on fr scnd key n so on.
> I dun want to hardcode the types as tomoro i can add more keys OR
> rename a key's table name, which means ill hav to update my sql code
> also (the proc is gettin an XML which contains all info of the keys).
>
> So i think u get the idea now
>

Drop the IM speak or I'll resort to using Latin.

If you are renaming tables then you have a bigger problem. You didn't state the business case you stated the solution. In engineering the hardest part is identifying the problem with sufficient detail to work towards a solution. Please state the business case or business problem you are trying to solve. (not the engineering solution). Jim Received on Fri Mar 03 2006 - 18:51:18 CST