Click here to Skip to main content
15,883,127 members
Home / Discussions / Database
   

Database

 
QuestionMicrosoft reporting services Pin
berba17-Jul-12 0:44
berba17-Jul-12 0:44 
QuestionDeleting Data Using Job Scheduler Pin
ASPnoob16-Jul-12 22:59
ASPnoob16-Jul-12 22:59 
AnswerRe: Deleting Data Using Job Scheduler Pin
rimazuc17-Jul-12 0:00
rimazuc17-Jul-12 0:00 
AnswerRe: Deleting Data Using Job Scheduler Pin
Michael Potter17-Jul-12 3:38
Michael Potter17-Jul-12 3:38 
QuestionAn Iteration with renaming and avoiding duplicates Pin
SkyRunner16-Jul-12 8:37
SkyRunner16-Jul-12 8:37 
QuestionRe: An Iteration with renaming and avoiding duplicates Pin
Suvabrata Roy16-Jul-12 8:55
professionalSuvabrata Roy16-Jul-12 8:55 
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 
Use a cursor/while loop, probably easier with a cursor.
get the field to be renamed into a variable
test if it exists in the target
insert or ignore base on the test
Never underestimate the power of human stupidity
RAH

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 
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 

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.