Click here to Skip to main content
15,561,958 members
Home / Discussions / Database
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 4:10
cofounderChris Maunder16-Jul-09 4:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 17:30
cofounderChris Maunder10-Nov-05 17:30 
QuestionQuestion On SQL Query Result Pin
crmfghtr20-Jan-23 6:13
crmfghtr20-Jan-23 6:13 
AnswerRe: Question On SQL Query Result Pin
Richard Deeming20-Jan-23 6:33
mveRichard Deeming20-Jan-23 6:33 
PraiseRe: Question On SQL Query Result Pin
crmfghtr20-Jan-23 6:41
crmfghtr20-Jan-23 6:41 
AnswerRe: Question On SQL Query Result Pin
Mycroft Holmes20-Jan-23 12:34
professionalMycroft Holmes20-Jan-23 12:34 
GeneralRe: Question On SQL Query Result Pin
crmfghtr20-Jan-23 13:41
crmfghtr20-Jan-23 13:41 
QuestionEF Core 6 Exclude Columns Pin
Kevin Marois19-Dec-22 9:47
professionalKevin Marois19-Dec-22 9:47 
AnswerRe: EF Core 6 Exclude Columns Pin
Dave Kreskowiak19-Dec-22 16:47
mveDave Kreskowiak19-Dec-22 16:47 
GeneralRe: EF Core 6 Exclude Columns Pin
Kevin Marois23-Dec-22 8:36
professionalKevin Marois23-Dec-22 8:36 
QuestionUsing SQL Native Backup URL, multiple databases to Azure Blob Storage Pin
Jaime Maccou9-Dec-22 2:00
Jaime Maccou9-Dec-22 2:00 
AnswerRe: Using SQL Native Backup URL, multiple databases to Azure Blob Storage Pin
jschell12-Dec-22 11:33
jschell12-Dec-22 11:33 
QuestionEntity Framework Core 6 VARCHAR(MAX) Pin
Kevin Marois8-Dec-22 13:54
professionalKevin Marois8-Dec-22 13:54 
AnswerRe: Entity Framework Core 6 VARCHAR(MAX) Pin
Victor Nijegorodov8-Dec-22 19:24
Victor Nijegorodov8-Dec-22 19:24 
GeneralRe: Entity Framework Core 6 VARCHAR(MAX) Pin
Kevin Marois9-Dec-22 12:47
professionalKevin Marois9-Dec-22 12:47 
GeneralRe: Entity Framework Core 6 VARCHAR(MAX) Pin
jschell12-Dec-22 11:35
jschell12-Dec-22 11:35 
QuestionSOLVED - Pivot a result set Pin
Richard Andrew x6428-Nov-22 6:46
professionalRichard Andrew x6428-Nov-22 6:46 
AnswerRe: SOLVED - Pivot a result set Pin
Richard Deeming28-Nov-22 22:24
mveRichard Deeming28-Nov-22 22:24 
QuestionTSQL - JOIN cancels out my date filter Pin
jkirkerx27-Nov-22 14:53
professionaljkirkerx27-Nov-22 14:53 
AnswerRe: TSQL - JOIN cancels out my date filter Pin
Graham Breach27-Nov-22 22:38
Graham Breach27-Nov-22 22:38 
GeneralRe: TSQL - JOIN cancels out my date filter Pin
jkirkerx28-Nov-22 7:32
professionaljkirkerx28-Nov-22 7:32 
GeneralRe: TSQL - JOIN cancels out my date filter Pin
jschell28-Nov-22 11:44
jschell28-Nov-22 11:44 
QuestionTSQL - Create a JOIN, knowing that it may not exist, but show the initial records at least instead of nothing [bad idea] - abandoned it Pin
jkirkerx21-Nov-22 10:15
professionaljkirkerx21-Nov-22 10:15 
That was hard to describe.

Because of some bad business logic, or dealing with say vendors that retire or go out of business after 20 years, the question of what to do with them remains.

I'm thinking it's best to ask for the vendor anyways, and join any task if it exists. If it doesn't exist, then at least give me the vendor info, and the rest can be blank. So if I can get the VendorID, CompanyName and Vendor DeleteFlag even if the JOIN can't JOIN or the JOIN request doesn't exists, that would solve some issues for me.

I don't know what this is called, and the keywords I'm using don't bring up much except for NOT EXIST. I'm just looking for a point in the right direction or no it can't be done.

SELECT
vendor.Vendor_ID,
vendor.Company_Name,
vendor.DELETE_FLAG,
proj_cost.cost,
proj_cost.pref_vendor
FROM vendor
LEFT OUTER JOIN proj_cost ON proj_cost.Vend_ID = vendor.Vendor_ID
WHERE proj_cost.proj_id = '4077'
AND proj_cost.proj_stage = 'construction'
AND proj_cost.vers_id = '8'
AND proj_cost.task_Oper = '6'
AND proj_cost.vend_id = '54'
AND proj_cost.task_id = 'TK_EX_044'
If it ain't broke don't fix it
Discover my world at jkirkerx.com


modified 21-Nov-22 15:36pm.

AnswerMaybe this is a bad idea, so I abandoned it. Did a work around instead. Pin
jkirkerx21-Nov-22 10:35
professionaljkirkerx21-Nov-22 10:35 
AnswerRe: TSQL - Create a JOIN, knowing that it may not exist, but show the initial records at least instead of nothing [bad idea] - abandoned it Pin
Graham Breach21-Nov-22 11:29
Graham Breach21-Nov-22 11:29 

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.