Click here to Skip to main content
14,665,422 members
Home » Discussions » Database
   

Database

 
GeneralRe: SQL Interview Pin
Member 1417944312-Apr-19 22:36
MemberMember 1417944312-Apr-19 22:36 
GeneralRe: SQL Interview Pin
Richard MacCutchan12-Apr-19 23:20
mveRichard MacCutchan12-Apr-19 23:20 
GeneralRe: SQL Interview Pin
Eddy Vluggen16-Apr-19 2:54
professionalEddy Vluggen16-Apr-19 2:54 
AnswerRe: SQL Interview Pin
#realJSOP16-Apr-19 2:00
mva#realJSOP16-Apr-19 2:00 
QuestionQuerying from multiple tables at the same time - related to correlated subqueries Pin
User 141845817-Apr-19 5:12
MemberUser 141845817-Apr-19 5:12 
AnswerRe: Querying from multiple tables at the same time - related to correlated subqueries Pin
Mycroft Holmes7-Apr-19 12:08
professionalMycroft Holmes7-Apr-19 12:08 
AnswerRe: Querying from multiple tables at the same time - related to correlated subqueries Pin
Eddy Vluggen8-Apr-19 0:44
professionalEddy Vluggen8-Apr-19 0:44 
AnswerRe: Querying from multiple tables at the same time - related to correlated subqueries Pin
CHill6011-Apr-19 6:48
mveCHill6011-Apr-19 6:48 
It's always easier to help sort problems out if you also supply some sample data and expected results.

You are using the TEXT datatype for some key data items - this allows up to 2GB of text and is the wrong choice for things like names, emails etc. You also cannot compare or sort easily. Use Varchar instead e.g. VARCHAR(MAX) (Although that is also overkill, I usually use varchar(50))

You are using WHERE when you should be using CASE WHEN ... END
QuestionHELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 17:37
MemberBrunoPigeon4-Apr-19 17:37 
AnswerRe: HELP WITH SQL QUERY Pin
Mycroft Holmes4-Apr-19 20:38
professionalMycroft Holmes4-Apr-19 20:38 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 20:56
MemberBrunoPigeon4-Apr-19 20:56 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:06
professionalGuyThiebaut4-Apr-19 21:06 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 21:10
MemberBrunoPigeon4-Apr-19 21:10 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:20
professionalGuyThiebaut4-Apr-19 21:20 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:43
professionalGuyThiebaut4-Apr-19 21:43 
AnswerRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 20:56
professionalGuyThiebaut4-Apr-19 20:56 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 20:58
MemberBrunoPigeon4-Apr-19 20:58 
GeneralRe: HELP WITH SQL QUERY Pin
Mycroft Holmes4-Apr-19 21:16
professionalMycroft Holmes4-Apr-19 21:16 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:24
professionalGuyThiebaut4-Apr-19 21:24 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 0:13
MemberBrunoPigeon5-Apr-19 0:13 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:17
professionalGuyThiebaut4-Apr-19 21:17 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 0:11
MemberBrunoPigeon5-Apr-19 0:11 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut5-Apr-19 2:48
professionalGuyThiebaut5-Apr-19 2:48 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 4:22
MemberBrunoPigeon5-Apr-19 4:22 
QuestionIn Access: group of records and assign conditional group ? Pin
Member 245846726-Mar-19 22:18
MemberMember 245846726-Mar-19 22: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.