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

Database

 
GeneralRe: Simple Unique Identity Value Pin
Richard Andrew x646-Oct-22 2:01
professionalRichard Andrew x646-Oct-22 2:01 
Questionibtogo64.dll error Pin
Dhyanga25-Sep-22 6:06
Dhyanga25-Sep-22 6:06 
AnswerRe: ibtogo64.dll error Pin
Richard MacCutchan25-Sep-22 6:51
mveRichard MacCutchan25-Sep-22 6:51 
GeneralRe: ibtogo64.dll error Pin
Dhyanga25-Sep-22 7:52
Dhyanga25-Sep-22 7:52 
GeneralRe: ibtogo64.dll error Pin
Richard MacCutchan25-Sep-22 8:03
mveRichard MacCutchan25-Sep-22 8:03 
GeneralRe: ibtogo64.dll error Pin
Dhyanga25-Sep-22 8:15
Dhyanga25-Sep-22 8:15 
GeneralRe: ibtogo64.dll error Pin
Richard Deeming25-Sep-22 21:45
mveRichard Deeming25-Sep-22 21:45 
QuestionJust trying to get the count that meets the criteria Pin
jkirkerx4-Sep-22 13:58
professionaljkirkerx4-Sep-22 13:58 
I struggled with this in the past, like 10 years ago, and it's been quite awhile since I've needed something like this. I'm trying to get the count, the number of records that meet this criteria. But I get an array of records because of the JOIN.I searched the internet, but didn't really see anything that came close, or the examples were very simple. I don't really need anything in SELECT, except the count. $designerId is PHP 8
SELECT
    project.project_no,
    COUNT(commission_summary.project_no)                            
    FROM project 
    INNER JOIN commission_summary ON commission_summary.project_no = project.project_no             
    WHERE project.sales_no = '$designerId' 
    AND (project.status = 'construction' OR project.status = 'finished') 
    AND (commission_summary.startup_check_date is NULL OR CONVERT(char(10), commission_summary.startup_check_date, 120) = '1900-01-01' OR CONVERT(char(10), commission_summary.startup_check_date, 120) >= '2021-01-01') 
    AND (commission_summary.finished_check_date is NULL OR CONVERT(char(10), commission_summary.finished_check_date, 120) = '1900-01-01' OR CONVERT(char(10), commission_summary.finished_check_date, 120) >= DATEADD(month, -1, GETDATE()) )
    GROUP BY project.project_no
If it ain't broke don't fix it
Discover my world at jkirkerx.com

AnswerRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 2:28
mveCHill605-Sep-22 2:28 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx5-Sep-22 8:11
professionaljkirkerx5-Sep-22 8:11 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx5-Sep-22 8:41
professionaljkirkerx5-Sep-22 8:41 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 21:05
mveCHill605-Sep-22 21:05 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 21:07
mveCHill605-Sep-22 21:07 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx6-Sep-22 5:37
professionaljkirkerx6-Sep-22 5:37 
GeneralRe: Just trying to get the count that meets the criteria Pin
Richard Deeming6-Sep-22 21:23
mveRichard Deeming6-Sep-22 21:23 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx7-Sep-22 6:22
professionaljkirkerx7-Sep-22 6:22 
GeneralRe: Just trying to get the count that meets the criteria Pin
CHill607-Sep-22 23:59
mveCHill607-Sep-22 23:59 
QuestionMSSQL select values in one row by group Pin
Sergey Makarov 20222-Sep-22 5:45
Sergey Makarov 20222-Sep-22 5:45 
AnswerRe: MSSQL select values in one row by group Pin
OriginalGriff2-Sep-22 5:47
mveOriginalGriff2-Sep-22 5:47 
GeneralRe: MSSQL select values in one row by group Pin
Sergey Makarov 20222-Sep-22 5:49
Sergey Makarov 20222-Sep-22 5:49 
QuestionAzure Synapse Data Flow Linked Data Set table not populating Pin
j11codep2-Sep-22 2:38
j11codep2-Sep-22 2:38 
GeneralAnyone here use Snowflake Pin
Mike Ahrens30-Aug-22 9:37
professionalMike Ahrens30-Aug-22 9:37 
GeneralRe: Anyone here use Snowflake Pin
PIEBALDconsult30-Aug-22 12:57
mvePIEBALDconsult30-Aug-22 12:57 
GeneralRe: Anyone here use Snowflake Pin
Mycroft Holmes30-Aug-22 12:59
professionalMycroft Holmes30-Aug-22 12:59 
GeneralRe: Anyone here use Snowflake Pin
PIEBALDconsult30-Aug-22 13:22
mvePIEBALDconsult30-Aug-22 13:22 

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.