EPTOfficial 'what is Dota anymore' discussion - Page 9292
| Forum Index > Dota 2 General |
|
Sn0_Man
Tebellong44238 Posts
| ||
Nixer
2774 Posts
| ||
|
Gosi
Sweden9072 Posts
| ||
|
Sn0_Man
Tebellong44238 Posts
On February 01 2018 00:40 Nixer wrote: Canada in general? reminder TI's in canada this year | ||
|
Maverick_2009
Somewhere2002 Posts
On January 31 2018 22:16 Artisreal wrote: How the fuck can a company dare to offer 26k£ a year and demand 4+ years of experience for an engineering job in Edinburgh. What the fuck. Also it terribly annoys me that my phone won't learn to recognize me signing fuck on the keyboard and still always go for duck. Smh #BREXIT | ||
|
intotheheart
Canada33091 Posts
I'm guessing Vancouver? | ||
|
Nevuk
United States16280 Posts
| ||
|
Sn0_Man
Tebellong44238 Posts
On February 01 2018 02:47 Nevuk wrote: The final battle of the orc campaign in ToME is ridiculous. Pretty much the hardest thing in that game, which I've only beaten like times anyways. did u solve ur sql homework | ||
|
Nevuk
United States16280 Posts
Playing tome while I listen to the lecture from a year ago where my professor apparently went over it | ||
|
Sn0_Man
Tebellong44238 Posts
On February 01 2018 03:24 Nevuk wrote: Playing tome while I listen to the lecture from a year ago where my professor apparently went over it b-b-b-but i told u how to do it :p now that i have access to my work server i can test the query. you do have to subquery it. + Show Spoiler + SELECT SUM(sub.[sales]), sub.saleyear FROM(SELECT [sales], datepart(year, [dateofsale]) as saleyear FROM [tablename]) sub GROUP BY sub.saleyear //replace names inside [] with your table/column names. the idea behind the query is to create the data that you want to actually group by (the year rather than the entire date) then execute the query on that | ||
|
Nevuk
United States16280 Posts
On February 01 2018 04:19 Sn0_Man wrote: b-b-b-but i told u how to do it :p now that i have access to my work server i can test the query. you do have to subquery it. + Show Spoiler + SELECT SUM(sub.[sales]), sub.saleyear FROM(SELECT [sales], datepart(year, [dateofsale]) as saleyear FROM [tablename]) sub GROUP BY sub.saleyear //replace names inside [] with your table/column names. the idea behind the query is to create the data that you want to actually group by (the year rather than the entire date) then execute the query on that I just went with this and it worked. I feel like I was overcomplicating it. SELECT SUM(sales), TO_CHAR(stockdate, 'YYYY') FROM name_newbooks GROUP BY TO_CHAR(stockdate, 'YYYY'); No idea why I couldn't get anything to work last night. | ||
|
Artisreal
Germany9235 Posts
Idk... Should it not provoke a unsaturated market because everyone leaves? | ||
|
cecek
Czech Republic18921 Posts
https://www.reddit.com/r/hearthstone/comments/7ubv89/i_feel_the_need_to_highlight_the_fact_that_if_you/ | ||
|
intotheheart
Canada33091 Posts
| ||
|
Fleetfeet
Canada2845 Posts
Is this confirmed? Cause if it is i gotta get on not getting my passport somewhat soon. | ||
|
intotheheart
Canada33091 Posts
| ||
|
Sn0_Man
Tebellong44238 Posts
I still need to get on getting my passport renewed anyway because, well, it's hard to imagine living without one. | ||
|
intotheheart
Canada33091 Posts
| ||
|
Artisreal
Germany9235 Posts
You're in some sort of electrical engineering, was it? | ||
|
Atreides
United States2393 Posts
| ||
| ||
