It will be really interesting to test the performance and to slice and dice the different versions proposed, and see which solution is better. I'm not an OOP expert developer so I'd love to have an expert explaining that here. Thanks! :-)...

I would have just one constructor and the code will look much simpler, like this: class VoteData { private int id = 0; private string user = string.Empty; private VoteType? vote = null; public int ID...

@dishdy I can see those results now. Sorry about confusion. Ignore my previous observations. Thanks!

@dishdy Same thing with "13 1" ("a z")...

@dishdy How come your result includes the tuple "3 1", which translated means "w c" or "w % c"? There is no phrase that contains combination of those 2 words in your testing data. I was just curios... I might be wrong and I just don't see it. Thanks!

If the keywords to be search are found multiple times in the phrase, do we expect to have duplicated tuples in the result? For example, in the phrase "Our technology is great because technology is our future" there are 2 occurrences of keywords ("Our tech

@dishdy, If that's the logic then it's clear for me now what the requirements are for this problem. I was confused because I couldn't realize how you can have multiple sales with the same ID, but BookingId is similar with ClientId so now everything makes

I forgot to add a negative sales row, so please add this line too. SELECT 3,'2010-01-01 16:00:01','S',-1 UNION ALL Thanks again!

Ok, so what should we expect as result from this input data? SELECT 3,'2010-01-01 19:00:01','S',100 UNION ALL SELECT 3,'2010-01-01 13:00:01','R',50 UNION ALL SELECT 3,'2010-01-01 11:00:01','S',0 UNION ALL SELECT 3,'2010-01-01 14:00:01','R',-20 UNION

Good point, Akmal. I'm still waiting for that clarification too, whether a specific BookingId can have more transaction type 'S' on the same day. Thanks!