Viewing 15 posts - 1 through 15 (of 159 total)
I am trying to get the hours difference.
July 21, 2020 at 6:08 pm
When I use your code I get errors all over , states sum function requires 1 arg, and doesn't recognize OBSERV_DATE, yes I figured to let the report do the...
June 8, 2020 at 10:11 pm
I've attached a screen shot of the table definitions.
June 8, 2020 at 9:42 pm
The report is displaying the data like this. see attached..sorry
June 8, 2020 at 9:33 pm
So to get it to show them day 1 of each month, totals and day 2, day 3 do I need to group by something special within the report? because...
June 8, 2020 at 9:23 pm
The data returned doesn't look sum it properly from what I am seeing in the data, for example oct, nov dec, jan isn't showing data as in the attachment.
June 8, 2020 at 9:14 pm
We don't have a table for dates, this is a poorly designed database. I have to figure the fiscal year based off observ_date it goes oct through sept
June 8, 2020 at 9:08 pm
WHERE site_code = @p_site_code
AND datepart(month,observ_date) = @p_startmonth
AND DATEPART(YEAR,observ_date)= @p_startyear
AND DATEPART(MONTH,observ_date) <= @p_endmonth
AND DATEPART(YEAR,observ_date)= @p_endyear
April 29, 2020 at 4:06 pm
April 29, 2020 at 3:43 pm
I just have the .rdf file, no oracle on machine, no conversion tools, which is what I am looking for. An app that someone may have used to open them...
April 17, 2020 at 6:43 pm
I'm just curious are all of you always so rude? Of course I googled it, nah really I just jumped on and wanted someone else to do all the research.
April 17, 2020 at 6:14 pm
Yes they are, no calculations will be done on them.
March 31, 2020 at 8:15 pm
Here is some sample data, I have removed any data that had identifying information, phone numbers and faxs and names and addresses
March 31, 2020 at 7:57 pm
No it isn't and youre talking about the decimal fields correct?
March 31, 2020 at 7:40 pm
Original Table from AS400SELECT NOUSGE, /* NOUSGE CHARACTER(1) DO NOT USE FLAG */ MVEND, /* MVEND ...
March 31, 2020 at 7:30 pm