I sticked with a problem, that i do not know to go in which way.
I will explain in Step wise
I had an output which is retrieved from
and the output what i am getting is
So the problem is i need to create a table by taking column names and datatypes as above output with some size. Every thing should be done dynamically and i should save this logic in a procedure so that when i send any other procedure name as parameter it should create a table
Is the above scenario possible?Regards Bhuvan (Student On MS Technologies)
Are you sure you want to create a table based on the parameters? It seems a little weird to want to do that. Based on the columns of a result set, yes, I could understand - although that is, in itself, a bit of a world of pain.
Anyway, to do it from parameters (roughly):
answered Dec 01 '10 at 02:51 AM
Matt Whitfield ♦♦