Click here to Skip to main content
11,567,539 members (43,818 online)
   

Database

 
GeneralRe: oltp vs olap Pin
a.fatemeh2-Dec-12 13:41
membera.fatemeh2-Dec-12 13:41 
GeneralSQL instance name when using network group Pin
Aamir Saleem2-Dec-12 10:32
memberAamir Saleem2-Dec-12 10:32 
GeneralRe: SQL instance name when using network group Pin
Mycroft Holmes2-Dec-12 11:43
memberMycroft Holmes2-Dec-12 11:43 
QuestionACL vs SQL for fuzzy matching Pin
Ben Dessau29-Nov-12 4:15
memberBen Dessau29-Nov-12 4:15 
AnswerRe: ACL vs SQL for fuzzy matching Pin
Pete O'Hanlon29-Nov-12 5:07
protectorPete O'Hanlon29-Nov-12 5:07 
GeneralRe: ACL vs SQL for fuzzy matching Pin
Ben Dessau29-Nov-12 6:43
memberBen Dessau29-Nov-12 6:43 
GeneralRe: ACL vs SQL for fuzzy matching Pin
Pete O'Hanlon29-Nov-12 6:50
protectorPete O'Hanlon29-Nov-12 6:50 
QuestionSQL Query Pin
berba29-Nov-12 2:22
memberberba29-Nov-12 2:22 
I have the following query:


select CASE when EA.Address1 <> '' and EA.Address2 <> '' and EA.Address3 <> '' then Replace(EA.Address2, ',' , ' ') + '' + Replace(EA.Address3, ',' , ' ')

else EA.Address1 end as employeeaddress

from EmployeeAdress EA


However employeeaddress should hold a maximum of 35 characters irrespective the number of characters in columns Address1, Address2, Address3.

Any advice how to do this?

Thanks
Berba Smile | :)
AnswerRe: SQL Query Pin
Richard Deeming29-Nov-12 2:50
memberRichard Deeming29-Nov-12 2:50 
GeneralRe: SQL Query Pin
berba2-Dec-12 18:30
memberberba2-Dec-12 18:30 
QuestionSQL Server windows authentication Pin
zead28-Nov-12 23:49
memberzead28-Nov-12 23:49 
AnswerRe: SQL Server windows authentication Pin
Garth J Lancaster28-Nov-12 23:59
memberGarth J Lancaster28-Nov-12 23:59 
AnswerRe: SQL Server windows authentication Pin
jschell29-Nov-12 8:09
memberjschell29-Nov-12 8:09 
GeneralRe: SQL Server windows authentication Pin
Chris Meech30-Nov-12 3:45
memberChris Meech30-Nov-12 3:45 
QuestionNeed help with a tricky MS SQL Query Pin
muya mwansa27-Nov-12 6:46
membermuya mwansa27-Nov-12 6:46 
AnswerRe: Need help with a tricky MS SQL Query Pin
Eddy Vluggen27-Nov-12 13:31
memberEddy Vluggen27-Nov-12 13:31 
GeneralRe: Need help with a tricky MS SQL Query Pin
jschell28-Nov-12 8:43
memberjschell28-Nov-12 8:43 
AnswerRe: Need help with a tricky MS SQL Query Pin
Deepak Kumar1128-Nov-12 1:03
memberDeepak Kumar1128-Nov-12 1:03 
QuestionBest Approach For Designing Database Pin
AmbiguousName27-Nov-12 3:59
memberAmbiguousName27-Nov-12 3:59 
AnswerRe: Best Approach For Designing Database Pin
jschell27-Nov-12 13:13
memberjschell27-Nov-12 13:13 
AnswerRe: Best Approach For Designing Database Pin
Mycroft Holmes27-Nov-12 13:14
memberMycroft Holmes27-Nov-12 13:14 
AnswerRe: Best Approach For Designing Database Pin
Eddy Vluggen27-Nov-12 13:23
memberEddy Vluggen27-Nov-12 13:23 
AnswerRe: Best Approach For Designing Database Pin
Krishna Kumar Soni3-Dec-12 1:04
memberKrishna Kumar Soni3-Dec-12 1:04 
QuestionEXEC sp_helptext Pin
jojoba201126-Nov-12 22:43
memberjojoba201126-Nov-12 22:43 
AnswerRe: EXEC sp_helptext Pin
Mycroft Holmes26-Nov-12 23:30
memberMycroft Holmes26-Nov-12 23:30 

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

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


Advertise | Privacy | Mobile
Web04 | 2.8.150624.2 | Last Updated 29 Jun 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid