Click here to Skip to main content
15,901,426 members
Home / Discussions / Database
   

Database

 
AnswerRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 2:36
SkyRunner17-Jul-12 2:36 
AnswerRe: An Iteration with renaming and avoiding duplicates Pin
Mycroft Holmes16-Jul-12 12:58
professionalMycroft Holmes16-Jul-12 12:58 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 2:39
SkyRunner17-Jul-12 2:39 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Mycroft Holmes17-Jul-12 2:59
professionalMycroft Holmes17-Jul-12 2:59 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 3:08
SkyRunner17-Jul-12 3:08 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 3:44
SkyRunner17-Jul-12 3:44 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Michael Potter17-Jul-12 3:52
Michael Potter17-Jul-12 3:52 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 4:11
SkyRunner17-Jul-12 4:11 
we are making/filling a new table and after filling that with the desired table, the previous table is a subject to delete, so will not do anything regarding the duplicates ( They stay to be deleted )
Do you know how can I use Select / Insert here to accomplish this task and bring all the columns data with a condition checking about preventing the insertion of future-probable-duplicates ?

There are about 180,000 rows which we will not move about 10,000 of it,
The database is generated by code, and everything was based on decision and observation.
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Michael Potter17-Jul-12 4:51
Michael Potter17-Jul-12 4:51 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 23:24
SkyRunner17-Jul-12 23:24 
GeneralIncorrect Reporting Service instance name during SQL server 2005 SP3 installation Pin
Vipul Mehta15-Jul-12 22:55
Vipul Mehta15-Jul-12 22:55 
Questionlogin page Pin
Dinesh kumar tomer15-Jul-12 18:44
Dinesh kumar tomer15-Jul-12 18:44 
AnswerRe: login page Pin
ManishaSCode15-Jul-12 19:25
ManishaSCode15-Jul-12 19:25 
AnswerRe: login page Pin
Paul Conrad16-Jul-12 10:55
professionalPaul Conrad16-Jul-12 10:55 
QuestionCan a SQL login have more than one user Pin
yousefshokati14-Jul-12 19:53
yousefshokati14-Jul-12 19:53 
AnswerRe: Can a SQL login have more than one user Pin
Mycroft Holmes14-Jul-12 20:27
professionalMycroft Holmes14-Jul-12 20:27 
GeneralRe: Can a SQL login have more than one user Pin
yousefshokati14-Jul-12 20:50
yousefshokati14-Jul-12 20:50 
GeneralRe: Can a SQL login have more than one user Pin
Mycroft Holmes14-Jul-12 22:28
professionalMycroft Holmes14-Jul-12 22:28 
AnswerRe: Can a SQL login have more than one user Pin
ManishaSCode15-Jul-12 3:34
ManishaSCode15-Jul-12 3:34 
GeneralRe: Can a SQL login have more than one user Pin
Jan Steyn16-Jul-12 0:34
Jan Steyn16-Jul-12 0:34 
AnswerRe: Can a SQL login have more than one user Pin
rimazuc17-Jul-12 0:07
rimazuc17-Jul-12 0:07 
QuestionSql query that sorts data by top quantity per category Pin
Hardz13-Jul-12 16:49
Hardz13-Jul-12 16:49 
GeneralRe: Sql query that sorts data by top quantity per category Pin
PIEBALDconsult13-Jul-12 19:00
mvePIEBALDconsult13-Jul-12 19:00 
AnswerRe: Sql query that sorts data by top quantity per category Pin
__TR__15-Jul-12 0:49
__TR__15-Jul-12 0:49 
GeneralRe: Sql query that sorts data by top quantity per category Pin
Hardz15-Jul-12 15:18
Hardz15-Jul-12 15:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.