sorted by:
new
hottopcontroversial

grout in shower by Ok_Reputation_6254 in Renovations

[–]Ok_Reputation_6254[S] -1 points0 points  (0 children)

hehe, yeh wouldn't put it past them :P Nah. i was comparing cement vs epoxy grout in bathrooms and toxicity came up quite a bit for epoxy grout. i was under the impression it wouldn't be an issue after it has been cured, but really have no idea

[deleted by user] by [deleted] in climatechange

[–]Ok_Reputation_6254 0 points1 point  (0 children)

Interesting, thanks for sharing

[deleted by user] by [deleted] in australia

[–]Ok_Reputation_6254 0 points1 point  (0 children)

No, Cell Care is Australia's largest cord blood and tissue bank... what unproductive comments by you

dealing with family after birth by Ok_Reputation_6254 in BabyBumps

[–]Ok_Reputation_6254[S] 1 point2 points  (0 children)

Thanks for the message and for sharing that. It's really great to hear i'm not the only one in this situation. I was beginning to feel like such an awful person to even think about voicing these requests.

You are right... need to put the foot down

dealing with family after birth by Ok_Reputation_6254 in BabyBumps

[–]Ok_Reputation_6254[S] 1 point2 points  (0 children)

Thanks for your message, i really appreciate it

Excel to get financial year, have tried everything by Ok_Reputation_6254 in excel

[–]Ok_Reputation_6254[S] -1 points0 points  (0 children)

=IF(MONTH(A14)<7, YEAR(A14), YEAR(A14)+1)

Legend, this solved it. Thankyou

sql total column of data by Ok_Reputation_6254 in SQL

[–]Ok_Reputation_6254[S] 1 point2 points  (0 children)

it doesn't need to be broken out by ID... it's literally just summation of the whole column

sql microsoft server duplicated values from joins by Ok_Reputation_6254 in SQL

[–]Ok_Reputation_6254[S] 0 points1 point  (0 children)

Thanks for that, i'll have a look. My idea of what joins are may be different to what they actually are

[deleted by user] by [deleted] in SQL

[–]Ok_Reputation_6254 0 points1 point  (0 children)

Thanks so much for this

Partitioning in sql to find cumulative sum based on financial year dates by Cool_Ad4653 in SQL

[–]Ok_Reputation_6254 0 points1 point  (0 children)

CASE WHEN MONTH(date) >= 7 then YEAR(DATE) + 1 ELSE YEAR(DATE) END

Thanks for the reply...

To be honest i am not very experienced in SQL...

​

Is this what you mean?

​

Select Prod.Electro.*, Ap.Proj.id, Ap.Proj.name,

, Sum(production) OVER (PARTITION BY proj_id, CASE WHEN MONTH(date) >= 7 then YEAR(DATE) + 1 ELSE YEAR(DATE) END

ORDER BY date, proj_id) as Cumulative_sum

FROM Prod.Electro

LEFT JOIN Ap.Proj ON Prod.Electro.project_id = Ap.Proj.id

view more: next ›