Executing dynamic query and storing resultset

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Executing dynamic query and storing resultset

Author

Topic

Praveen_Kadam
Starting Member

2 Posts

Posted - 2007-04-13 : 05:48:07

Hi All,

I am really in a great trouble. My requirement is quite complex, as I feel, it may be quite simple for some of you.
Here is my problem -
Actually I am doing a project, where client has a specific requirement. i.e. he want's to build a query on runtime for selecting particular record he wants, so that we have provided a user interface where he can select any datasource e.g. SQL, Oracle, Excel etc. He also specifies the database name. He is displayed all the tables and columns under those tables. He selects columns from those table boxes and write the query he wants, with where clause, if required.
I am saving these query in a table, storing column names in another table where we map those oringinal column names with columns of another table, wehre we want to store actual result set of the prepared query by the user.
for examaple ..
if user preapare query like - 'SELECT CUST_ID, CUST_NAME FROM CUSTOMER
WHERE CUST_ID = 10'
In case of above query I will store CUST_ID in column COL1 of table TAB1 and CUST_NAME in COL2 of table TAB1, like that we have such fifty columns in that table. Now question is here every thing is dynamic data provider, database, tables, columns and where clause, then how can get the result set out of those queries and store that query output in the that storage table with columns col1, col2 and so on, upto 50 columns.
Please help me on this, as it is so urgent.
I will be very much thankful to you people.

Thanks & regards,

Praveen Kadam

Thanks & regards,

Praveen Kadam

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-13 : 05:52:21

in short, you will need to use Dynamic SQL. Read this first. http://www.sommarskog.se/dynamic_sql.html

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-04-13 : 06:02:55

If you pass queries as parameters, then would you like users to send these?

Delete from tablename
Drop table tablename
Drop database dbname

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources