----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: ArunGL Message 1 in Discussion Hi friends, I have a table structure like this in SQL sever 2000. i want a stored procedure to transfer the data from "tblSurvey" table to "tblRespondent" table. Table - tblSurvey ---------------------------------------------------- columnHeading col1 col2 col3 col4 col5 | ---------------------------------------------------- Res1 12 11 13 111 888 | Res2 1A 1B 1c 1d 8E | -------------------------------------------------- I want to store this as a single column like this Table - tblRespondent ---------------------- Respondent QuesID ---------------------- Res1 12 Res1 11 Res1 13 Res1 111 Res1 888 Res2 1A Res2 1B Res2 1c Res2 Id Res2 8E ------------------ any method is there to split the row data into column through stored procedure we can do this using recordset operation but it is very slow because the table row has more than 300 columns, I hope u understand my problem.. thanks Arun ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
