user import

[Lost User]

What does 'user' mean here ? Are they database users or your application users (stored in something like Users table) ? And what database do you use ?

[loyal ginger]

Good point! The question did not describe that clearly.

[David Mujica]

Check these referencs out ... Logins http://msdn.microsoft.com/en-us/library/ms189751.aspx[^] Users http://msdn.microsoft.com/en-us/library/ms173463.aspx[^]

[AndyInUK]

Sql server 2008. i have already imported the excel spreadsheet with all the users info to database. Now for instance there are different table for address field, different table for name field , differnt table for email etc. So my question is do i have to use curser so that i can insert the users value from this temp table to all the necessary table. if yes then how or if not then what's the best way ? Thank You. Andyyy

[AndyInUK]

Sql server 2008. i have already imported the excel spreadsheet with all the users info to database. Now for instance there are different table for address field, different table for name field , differnt table for email etc. So my question is do i have to use curser so that i can insert the users value from this temp table to all the necessary table. if yes then how or if not then what's the best way ? Thank You. Andyyy Reply·

[AndyInUK]

Sql server 2008. i have already imported the excel spreadsheet with all the users info to database. Now for instance there are different table for address field, different table for name field , differnt table for email etc. So my question is do i have to use curser so that i can insert the users value from this temp table to all the necessary table. if yes then how or if not then what's the best way ? Thank You. Andyyy Reply·

[loyal ginger]

In this case all you need to do is to create these "other tables", and then use "INSERT...SELECT..." query to pull out the necessary fields from the temp table and insert the records to the new tables. You can also create the tables and insert the records in one step by using the "SELECT...INTO..." statement. Good luck!

[Lost User]

If your database is properly designed and normalized, then simple update statements will work, otherwise you may have to use cursors.

[AndyInUK]

simple update statement works to enter one record by manually writing the details that i need to update but how to go to the next row in the table, get all the details and enter it to specific tables. So i am not interested in this manual process. Looking for something automatic - say cursor ? but not getting how to use that.

[Lost User]

The INSERT and UPDATE statements have a syntax that can be used to update multiple rows in the destination table from values in one or more source tables. The syntax is different for each database. These are examples for SQL Server:

INSERT INTO EmployeeMaster (FirstName, LastName, EmpID)
SELECT EmpFirstName, EmpLastName, EmpID
FROM EmployeeTemp
WHERE (...........)

UPDATE EmployeeMaster
SET EmployeeMaster.FirstName = EmployeeTemp.EmpFirstName,
EmployeeMaster.LastName = EmployeeTemp.EmpLastName,
EmployeeMaster.EmpID = EmployeeTemp.EmpID
FROM EmployeeTemp T INNER JOIN EmployeeMaster M ON T.EmpID = M.EmpID
WHERE (...........)