Click here to Skip to main content
15,884,353 members
Home / Discussions / Database
   

Database

 
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 
AnswerRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 2:28
mveCHill605-Sep-22 2:28 
You could use a CTE to identify the records that match then count. Bit hard to help without sample data though. Example:
SQL
;with cte as 
(
	SELECT distinct
    p.project_no
    FROM @project p
    INNER JOIN @commission_summary cs ON cs.project_no = p.project_no             
    WHERE p.sales_no = @designerId 
    AND (p.status = 'construction' OR p.status = 'finished') 
    AND (cs.startup_check_date is NULL OR CONVERT(char(10), cs.startup_check_date, 120) = '1900-01-01' OR CONVERT(char(10), cs.startup_check_date, 120) >= '2021-01-01') 
    AND (cs.finished_check_date is NULL OR CONVERT(char(10), cs.finished_check_date, 120) = '1900-01-01' OR CONVERT(char(10), cs.finished_check_date, 120) >= DATEADD(month, -1, GETDATE()) )
)    
select COUNT(*)                            
from cte

I would question all those CONVERTs - surely commission_summary.startup_check_date is a date not a string?
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 
GeneralRe: Anyone here use Snowflake Pin
CHill601-Sep-22 3:25
mveCHill601-Sep-22 3:25 

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.