Click here to Skip to main content
14,930,870 members
Home / Discussions / Database
   

Database

 
QuestionRe: IF then ? Pin
Richard MacCutchan19-Jul-17 21:51
mveRichard MacCutchan19-Jul-17 21:51 
AnswerRe: IF then ? Pin
patsq20-Jul-17 2:23
Memberpatsq20-Jul-17 2:23 
AnswerRe: IF then ? Pin
Richard Deeming20-Jul-17 1:36
mveRichard Deeming20-Jul-17 1:36 
GeneralRe: IF then ? Pin
Chris Quinn20-Jul-17 5:59
MemberChris Quinn20-Jul-17 5:59 
GeneralRe: IF then ? Pin
Richard Deeming20-Jul-17 6:50
mveRichard Deeming20-Jul-17 6:50 
GeneralRe: IF then ? Pin
Chris Quinn20-Jul-17 21:22
MemberChris Quinn20-Jul-17 21:22 
GeneralRe: IF then ? Pin
Richard Deeming21-Jul-17 0:15
mveRichard Deeming21-Jul-17 0:15 
AnswerRe: IF then ? Pin
Pradeep Magati11-Aug-17 2:58
MemberPradeep Magati11-Aug-17 2:58 
Hello,
Use REPLICATE() and RIGHT Functions,


SELECT RIGHT(REPLICATE(0,2)+CAST([EMPLOYEE].JOB_CODE AS NVARCHAR(200)),3) FROM YourTable



Regards,
Pradeep M
QuestionSetting values from a Pivot to 0? Pin
patsq18-Jul-17 4:55
Memberpatsq18-Jul-17 4:55 
AnswerRe: Setting values from a Pivot to 0? Pin
Chris Quinn18-Jul-17 5:01
MemberChris Quinn18-Jul-17 5:01 
GeneralRe: Setting values from a Pivot to 0? Pin
patsq18-Jul-17 5:08
Memberpatsq18-Jul-17 5:08 
GeneralRe: Setting values from a Pivot to 0? Pin
patsq18-Jul-17 5:24
Memberpatsq18-Jul-17 5:24 
QuestionPruning unused tables in a live database. Pin
mbb0113-Jul-17 2:43
Membermbb0113-Jul-17 2:43 
AnswerRe: Pruning unused tables in a live database. Pin
Mycroft Holmes13-Jul-17 13:31
professionalMycroft Holmes13-Jul-17 13:31 
AnswerRe: Pruning unused tables in a live database. Pin
Chris Quinn14-Jul-17 0:09
MemberChris Quinn14-Jul-17 0:09 
GeneralRe: Pruning unused tables in a live database. Pin
mbb0114-Jul-17 0:37
Membermbb0114-Jul-17 0:37 
GeneralRe: Pruning unused tables in a live database. Pin
Chris Quinn14-Jul-17 0:48
MemberChris Quinn14-Jul-17 0:48 
AnswerRe: Pruning unused tables in a live database. Pin
Eddy Vluggen14-Jul-17 2:39
professionalEddy Vluggen14-Jul-17 2:39 
AnswerRe: Pruning unused tables in a live database. Pin
Tim Carmichael14-Jul-17 8:57
MemberTim Carmichael14-Jul-17 8:57 
AnswerRe: Pruning unused tables in a live database. Pin
jschell15-Jul-17 9:33
Memberjschell15-Jul-17 9:33 
AnswerRe: Pruning unused tables in a live database. Pin
Mycroft Holmes15-Jul-17 14:43
professionalMycroft Holmes15-Jul-17 14:43 
GeneralRe: Pruning unused tables in a live database. Pin
Jörgen Andersson17-Jul-17 10:28
professionalJörgen Andersson17-Jul-17 10:28 
Questionhow to rertrieve only 3 columns out of 7 columns using queryForObject in jDBCTmplate????am unable use correct syntax to retrieve only 3 columns in JdbcStudentDAO Pin
LOKENDRA YADAV12-Jul-17 21:09
MemberLOKENDRA YADAV12-Jul-17 21:09 
SuggestionRe: how to rertrieve only 3 columns out of 7 columns using queryForObject in jDBCTmplate????am unable use correct syntax to retrieve only 3 columns in JdbcStudentDAO Pin
Richard Deeming13-Jul-17 7:57
mveRichard Deeming13-Jul-17 7:57 
QuestionWant to Import Data from Salesforce into SQL Server using SSIS Pin
indian14312-Jul-17 10:35
Memberindian14312-Jul-17 10:35 

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.