Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
GeneralRe: LONGTEXT not accepting large text! Pin
Richard Deeming12-Nov-14 10:40
mveRichard Deeming12-Nov-14 10:40 
GeneralRe: LONGTEXT not accepting large text! Pin
Jassim Rahma12-Nov-14 10:45
Jassim Rahma12-Nov-14 10:45 
QuestionDoes SQL require SSLv3? Pin
Richard Deeming12-Nov-14 4:51
mveRichard Deeming12-Nov-14 4:51 
SuggestionRe: Does SQL require SSLv3? Pin
Eddy Vluggen13-Nov-14 7:16
professionalEddy Vluggen13-Nov-14 7:16 
GeneralRe: Does SQL require SSLv3? Pin
Richard Deeming13-Nov-14 7:19
mveRichard Deeming13-Nov-14 7:19 
QuestionDatabase Mail not sending Emails Pin
Robymon11-Nov-14 2:19
Robymon11-Nov-14 2:19 
AnswerRe: Database Mail not sending Emails Pin
Richard Deeming11-Nov-14 2:53
mveRichard Deeming11-Nov-14 2:53 
QuestionLeft Join and double results where the join is complete Pin
jkirkerx7-Nov-14 10:36
professionaljkirkerx7-Nov-14 10:36 
I understand that this is what I asked for, but I'm trying to figure out how to just get 1 record of each item, instead of the 2 when the Join is valid.
DECLARE @CategoryID INT;
SET @CategoryID = 23;

SELECT *
FROM ProductInfo p
LEFT JOIN ProductInfo_Inventory pi ON p.ProductID = pi.ProductID
WHERE p.Category = @CategoryID

General[SORT OF SOLVED] Pin
jkirkerx7-Nov-14 11:17
professionaljkirkerx7-Nov-14 11:17 
AnswerRe: Left Join and double results where the join is complete Pin
rjdudley24-Nov-14 14:02
rjdudley24-Nov-14 14:02 
GeneralRe: Left Join and double results where the join is complete Pin
jkirkerx25-Nov-14 7:39
professionaljkirkerx25-Nov-14 7:39 
GeneralRe: Left Join and double results where the join is complete Pin
rjdudley25-Nov-14 8:24
rjdudley25-Nov-14 8:24 
GeneralRe: Left Join and double results where the join is complete Pin
jkirkerx25-Nov-14 9:28
professionaljkirkerx25-Nov-14 9:28 
Questionwhat is the equivalent linq query for the following sql query? Pin
Dhyanga7-Nov-14 5:42
Dhyanga7-Nov-14 5:42 
AnswerRe: what is the equivalent linq query for the following sql query? Pin
PIEBALDconsult7-Nov-14 5:52
mvePIEBALDconsult7-Nov-14 5:52 
GeneralRe: what is the equivalent linq query for the following sql query? Pin
Dhyanga7-Nov-14 5:57
Dhyanga7-Nov-14 5:57 
GeneralRe: what is the equivalent linq query for the following sql query? Pin
Dhyanga7-Nov-14 6:03
Dhyanga7-Nov-14 6:03 
GeneralRe: what is the equivalent linq query for the following sql query? Pin
PIEBALDconsult7-Nov-14 6:40
mvePIEBALDconsult7-Nov-14 6:40 
QuestionRe: what is the equivalent linq query for the following sql query? Pin
Eddy Vluggen7-Nov-14 7:31
professionalEddy Vluggen7-Nov-14 7:31 
AnswerRe: what is the equivalent linq query for the following sql query? Pin
Dhyanga7-Nov-14 7:44
Dhyanga7-Nov-14 7:44 
Questionmigrate a database in informix server to a local server mysql or postgree Pin
Ibrahim.elh6-Nov-14 3:48
Ibrahim.elh6-Nov-14 3:48 
AnswerRe: migrate a database in informix server to a local server mysql or postgree Pin
Eddy Vluggen7-Nov-14 7:33
professionalEddy Vluggen7-Nov-14 7:33 
QuestionSQL Left Outer Join Problem Pin
Vimalsoft(Pty) Ltd4-Nov-14 21:53
professionalVimalsoft(Pty) Ltd4-Nov-14 21:53 
AnswerRe: SQL Left Outer Join Problem Pin
Vimalsoft(Pty) Ltd4-Nov-14 22:11
professionalVimalsoft(Pty) Ltd4-Nov-14 22:11 
GeneralRe: SQL Left Outer Join Problem Pin
Mycroft Holmes4-Nov-14 22:33
professionalMycroft Holmes4-Nov-14 22:33 

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.