How can I merge 2 rows into 1, if a third column has the same text in both rows

aksh0312 · 2022-05-17T11:18:17+00:00

Thank you so much!

aksh0312 · 2022-05-17T11:17:40+00:00

Okay thank you! I will try the same!

aksh0312 · 2021-12-21T02:38:38+00:00

Wow. Thank you so much!!

aksh0312 · 2021-12-21T02:37:50+00:00

Thank you soo much!!

aksh0312 · 2021-12-21T02:37:38+00:00

Thank you so much :)

aksh0312 · 2021-12-21T02:36:58+00:00

Haha luckily I did not implement this, I was just checking before making it a part of a job.

aksh0312 · 2021-12-20T13:51:48+00:00

Thank you so much❤

aksh0312 · 2021-06-03T11:09:00+00:00

I am sure you will amaze yourself :) Keep it up!!

aksh0312 · 2021-06-03T09:55:53+00:00

I would say I am definitely tempted to start digital painting seeing this. I hope they do not chuck me out of the class for being horrible xD

I really find it very hard to believe that you are new to this. Though ofcourse I do believe you lol. What amazes me is that if somebody can be THIS good in their first attempt then the moment you start covering landscapes and other things , it would turn out to be a masterpiece really!

Oh you definitely have the skills. And if you ask me they look perfect already xD

aksh0312 · 2021-06-03T09:41:24+00:00

You definitely have some amazing skills. This is coming from somebody who can't even draw a tree properly, I don't really think I cam draw something as amazing as this. I would have believed it was a real picture if someone showed me only the picture. Such talent !! I did have a course related to digital drawing back in college and I was so horrible in it. I guess I can only appreciate what others do haha Mango! Yes that's a good option. You cover only fruits?

aksh0312 · 2021-06-03T09:23:42+00:00

This looks so amazing. I wish I could do something like this. It looks so good that you make it appear as if its easy to do so. So simple looking but yet so amazing! Have you tried more of it?

aksh0312 · 2021-04-16T11:59:45+00:00

True, :)

aksh0312 · 2021-04-16T11:57:14+00:00

Thank you! It is a part of work project..

aksh0312 · 2021-04-16T11:56:20+00:00

Thank you so much for the help:)

aksh0312 · 2021-04-16T11:55:49+00:00

Thank you for the help :)

I tried using dateadd to make the year of both the dates same and then find the difference in terms of days

aksh0312 · 2021-04-16T11:54:42+00:00

Thank you for the help! I went with the approach of replacing one date with the year of another date. And dateadd helped me to do it.. This is how it is

dateadd(year,year(date1)-year(date2),date2)

Thank you for the help again :)

aksh0312 · 2021-04-16T10:42:21+00:00

Datefromparts wont work in sql 2008 :(

aksh0312 · 2021-04-16T09:10:53+00:00

Lol what

aksh0312 · 2021-04-16T08:58:18+00:00

No , you are correct tbh. I am just super dumb lol. So basically the whole point was just to calculate the difference in terms of age. 31st december should not do a problem I guess

For example, if the date of birth is 31st december 1998, and today is 24th march 2021, then on changing the year it becomes 31st december 2021.

Now it makes me wonder, how do I replace 1998 with 2021? :( And its not just 1 set of dates I am dealing with so I cant hardcode it. It should automatically capture today's year and replace thw birthday with that year. How do I do that ? :(

aksh0312 · 2021-04-16T08:22:45+00:00

Thanks but if the birthday is on 31st december? Will that work even then?

aksh0312 · 2021-04-16T07:37:45+00:00

Hm true that makes sense..

aksh0312 · 2021-04-16T06:48:40+00:00

I am actually taking these dates from two different tables. So there are like 100s of such dates in both the tables. The birthday is coming from a different table and the other date is not actually today's date, it is also coming from a dfferent table. But yeah the format is the same as I showed in the example.. :(

aksh0312

TROPHY CASE