Click here to Skip to main content
15,849,907 members
Home / Discussions / Database
   

Database

 
QuestionAdvice on Perfomance Turning of the Query Pin
Vimalsoft(Pty) Ltd28-Oct-14 8:27
professionalVimalsoft(Pty) Ltd28-Oct-14 8:27 
GeneralRe: Advice on Perfomance Turning of the Query Pin
PIEBALDconsult28-Oct-14 9:04
mvePIEBALDconsult28-Oct-14 9:04 
AnswerRe: Advice on Perfomance Turning of the Query Pin
Eddy Vluggen28-Oct-14 9:59
professionalEddy Vluggen28-Oct-14 9:59 
AnswerRe: Advice on Perfomance Turning of the Query Pin
Mycroft Holmes28-Oct-14 13:59
professionalMycroft Holmes28-Oct-14 13:59 
GeneralRe: Advice on Perfomance Turning of the Query Pin
Vimalsoft(Pty) Ltd4-Nov-14 22:56
professionalVimalsoft(Pty) Ltd4-Nov-14 22:56 
QuestionCombine results from 2 foxpro DBF files using union Pin
jkirkerx27-Oct-14 13:30
professionaljkirkerx27-Oct-14 13:30 
AnswerMakes no sense how it works Pin
jkirkerx27-Oct-14 14:01
professionaljkirkerx27-Oct-14 14:01 
QuestionSelect count on 2 DBF files Pin
jkirkerx27-Oct-14 12:11
professionaljkirkerx27-Oct-14 12:11 
Sort of a dumb question here, I have 2 DBF files, fox-pro DBF files that are identical, in which I want to union all and get the count of the FITEMNO, which there is 1 in the first file and 1 in the 2nd file, so I get a count of 2.

Is this normal behavior or did I construct the statement wrong below?

SELECT COUNT(FITEMNO) AS hCount
 FROM
   ( 
     SELECT
     FITEMNO
     FROM ARTRS01H.dbf
     WHERE
     FSHIPDATE >= @startDate AND FSHIPDATE <= @stopDate
     AND
     FCUSTNO = @FCUSTNO
     AND
     FITEMNO = @FITEMNO
   	GROUP BY FITEMNO
   	UNION ALL
    SELECT
	FITEMNO
    FROM ARTRS01H.dbf
    WHERE
    FSHIPDATE >= @startDate AND FSHIPDATE <= @stopDate
    AND
    FCUSTNO = @FCUSTNO
    AND
    FITEMNO = @FITEMNO
    GROUP BY FITEMNO
 ) 

GeneralRe: Select count on 2 DBF files Pin
PIEBALDconsult27-Oct-14 12:25
mvePIEBALDconsult27-Oct-14 12:25 
GeneralRe: Select count on 2 DBF files Pin
jkirkerx27-Oct-14 13:23
professionaljkirkerx27-Oct-14 13:23 
QuestionRewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 1:00
Ambertje21-Oct-14 1:00 
AnswerRe: Rewrit a Scalar function to a table valued function Pin
Mycroft Holmes21-Oct-14 1:25
professionalMycroft Holmes21-Oct-14 1:25 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 2:40
Ambertje21-Oct-14 2:40 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Richard Deeming21-Oct-14 3:00
mveRichard Deeming21-Oct-14 3:00 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Ambertje21-Oct-14 3:25
Ambertje21-Oct-14 3:25 
GeneralRe: Rewrit a Scalar function to a table valued function Pin
Mycroft Holmes21-Oct-14 13:52
professionalMycroft Holmes21-Oct-14 13:52 
SuggestionRe: Rewrit a Scalar function to a table valued function Pin
Richard Deeming21-Oct-14 2:55
mveRichard Deeming21-Oct-14 2:55 
AnswerRe: Rewrit a Scalar function to a table valued function Pin
Eddy Vluggen21-Oct-14 3:33
professionalEddy Vluggen21-Oct-14 3:33 
QuestionStored Procedure for Item Allotment Pin
avisharma@sharma19-Oct-14 21:01
avisharma@sharma19-Oct-14 21:01 
QuestionRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson19-Oct-14 22:22
professionalJörgen Andersson19-Oct-14 22:22 
AnswerRe: Stored Procedure for Item Allotment Pin
avisharma@sharma20-Oct-14 0:04
avisharma@sharma20-Oct-14 0:04 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra20-Oct-14 3:24
professionalShweta N Mishra20-Oct-14 3:24 
GeneralRe: Stored Procedure for Item Allotment Pin
avisharma@sharma27-Oct-14 3:42
avisharma@sharma27-Oct-14 3:42 
GeneralRe: Stored Procedure for Item Allotment Pin
Shweta N Mishra27-Oct-14 4:37
professionalShweta N Mishra27-Oct-14 4:37 
GeneralRe: Stored Procedure for Item Allotment Pin
Jörgen Andersson20-Oct-14 5:53
professionalJörgen Andersson20-Oct-14 5:53 

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.