Using SQL Scripts at runtime

[Nitinkcv]

Hi,

Currently im using SQL queries in combination with ASP.NET..

I have currently only one table('Requests'), which has all the user info of name,id,studyrequested etc.. A person can request for any number of studies.

Now the prob is that from now on whenever a user requests for a new study not only should his details be stored in the Request table but also in a new Users table. In the Users table that particular users details must only be loaded once.. i.e. if the same user enrolls for another study his details should only be updated in the requests table and not in the Users table, since his details have already been loaded once in the Users Table..

While this works fine for new users, but what bout the old users already stored in the Requests table before the Users table existed.

Is there any way i could run a sql script only once at runtime, so that all the old legacy users are loaded once in to the Users Table.

Thanks,
Nitin

[iburyak]

Just do one time insert statement on the server side.
Why do you need to do it at run time?

[Nitinkcv]

Hi,

Please dont mind if what i ask is totally foolish, coz im totally a newbie to this..

When you mean just do insert statement at server side.. what do you actually mean by server side..

Thanks,
Nitin

[iburyak]

You can open SQL Query analyzer and write SQL statement that will find old users and insert them into a table. But it sounds you have little experience with SQL and you better ask your DBA to do it for you.


Thank you.