Viewing 12 posts - 1 through 12 (of 12 total)
GilaMonster (5/25/2015)
sherm (5/25/2015)
and of course the SQL was Smarter than me.;-) it knows that June only has 30 days NOT 31.:-D
🙂
When doing date filters like this, always do a...
May 25, 2015 at 6:38 am
OK, found out what the problem was...;-)
SQL is smarter than me.... I was using the dates 2014-06-01 - 2014-06-31 SQL knows that June has 30 NOT 31:-D
As to the...
May 25, 2015 at 6:23 am
OK, i found out the problem....hehee
i was using the dates 2014-06-01 - 2014-06-31... hehehe
and of course the SQL was Smarter than me.;-) it knows that June only has...
May 25, 2015 at 6:16 am
There was nothing wrong, just that my fingers got in the way, and i did not notice that i had typed your line incorrectly.
if i just want the month, how...
May 25, 2015 at 6:02 am
Have also done this for a weekly Average....
select AVG(total_liters), AVG(total_dollars), AVG(price_a_liter)
from Petrol_Table
where FuelDate >= '2014-06-01' and fueldate <= '2014-06-07';
Many Thanks for you help.:cool:
May 25, 2015 at 5:34 am
hmmm, lets try that again... sorry about this...
column names are total_liters, price_a_liter, total_dollars
i have tried your select line and SQL do not like it heheeh(my mistake) just...
May 25, 2015 at 5:18 am
opps, 😉
the three columns contain ie... 138.1, 44.18, 66.49
have used the "AVG" before...
but have no idea how to use Groupby....
if you have the time, some code would help....
Thanks
May 25, 2015 at 4:58 am
spaghettidba (3/31/2015)
sherm (3/31/2015)
This is the type of answer i was hoping to get. 🙂if you had type this in the first place, then i would not have shouted... hehe
I would...
March 31, 2015 at 4:55 am
GilaMonster (3/31/2015)
I suggest changing the table definition because you're using a completely inappropriate data type for the column. The text data type is...
March 31, 2015 at 4:22 am
GilaMonster (3/31/2015)
Alter the table and set the column to...
March 31, 2015 at 3:50 am
Thanks for the tip. 🙂
March 30, 2015 at 5:36 am
Thank you for your reply...
i did the following:-
Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
myconnection.Open()
...
March 28, 2015 at 4:07 am
Viewing 12 posts - 1 through 12 (of 12 total)