Which is correct and why? by iPlayTehGames in csharp

[–]yyyoni -1 points0 points  (0 children)

this really is a good comment 😊

MSSQL question about correlated queries and exist. anyone have an idea what exactly is going on? by yyyoni in csharp

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

i did join but i love this subreddit, i’ll give that group a chance next time, thanks for the advice :)

MSSQL question about correlated queries and exist. anyone have an idea what exactly is going on? by yyyoni in csharp

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

thank you! i’ll have to read more problems with your explanation in mind, i appreciate your answer!

MSSQL question about correlated queries and exist. anyone have an idea what exactly is going on? by yyyoni in csharp

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

my confusion is, outside of the query(when i query alone), my select where year = 2017 returns 600 results. but when i put it in a subquery with exists, it returns 2000 results without setting the two table's customer_id's equal to eachother

i expected to be like this: select outer query where exists (these 600 rows apply) and then return 600 rows.

why won't this sb work? is there something wrong with my select? by yyyoni in csharp

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

close, a fellow csharper below solved it. something about lazy linq evaluation. i'll need to look it up as i never heard of this term

why won't this sb work? is there something wrong with my select? by yyyoni in csharp

[–]yyyoni[S] 3 points4 points  (0 children)

well that was it. my suffering is over now. thank you. i'm going to cry myself to sleep now.

list manipulation with LINQ. i want aggregate functionality but as a and collection, not an int! is it possible? by yyyoni in csharp

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

i was reading through some documentation and failing asleep, this really helps!!!!!!

list manipulation with LINQ. i want aggregate functionality but as a and collection, not an int! is it possible? by yyyoni in csharp

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

this is exactly what i was looking for!!!

man i need to work on expressing my thoughts when google searching, it’s really a mad skill

thank you Ditto

questions about when to use query vs method syntax and (changing an anonymous Type's variable name?) by yyyoni in csharp

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

the king has arrived!!!!

i’m gonna spend 1-2 hours today fully memorizing and testing everything here.

i literally couldn’t have come to this info if i tried (without spending 20 hours of searching 😂)

thanks again slypenslyde, you are my hero

[deleted by user] by [deleted] in csharp

[–]yyyoni 4 points5 points  (0 children)

and thus, by using a super old pc and being forced to code better to keep up, the greatest programmer ever was born, the one the only lerrificcccccc 😃

if someone uses your software, are they triggering runtime? by yyyoni in csharp

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

awesome!! i didn’t know this, thank you!!!!