On 03/09/2011 13:54, trskopo wrote:
>> Hi all,
>>
>> Here is the problem, when I issued Select SQL statement, sometime, not
>> all records fetched, but this was not always happen, sometime, all
>> records fetched ok.
Check your dataset in c++, maybe it set to retrieve in only x of amount
of record
t sometimes I could not open the
database when switching between 32/64. To date I could not found out
why, as I use no UDF's and standard supperserver installations. So I
would recommen
>I have 2 (and more) tables with identical structure:
>
>Simplified structure and data:
>CODE VARCHAR(15)
>QUAN INTEGER
>
>Table A
>Item1, 50
>Item1, 40
>Item2, 70
>
>Table B
>Item1, 50
>Item2, 100
>Item2, 30
>
>I need to get the sum(QUAN) for all the rows in all the tables group
>>> I have query which extract the sales per day from a table
>
> >>>
> >>> Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT)
> AS DAYNO, SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
> >>>
> >>> It works 100%, but only returns the dates with sales, I need it to
> also in
Hi
I am not sure if it is really "legal" and if it will always work, but
this works for me for now.
Period = dateadd(minute, datediff(minute, Start_Date, End_Date),
cast('30.12.1899 00:00' as Timestamp))
will change the Period to Integer and save the DateDiff(minute ...) in
it, when I have