Try as below select c.id , c.bereichsname , STRING_AGG( CAST(j.oberbereich as nvarchar(MAX)),’,’) oberBereiches from stellenangebote_archiv j join bereiche c on j.bereich_id = c.id group by c.id, c.bereichsname So the problem is the length of the concatenated string is exceeding the character limit of the result column. So we are setting the limit to max by … Read more
As you’ve noticed, the WHERE clause doesn’t allow you to use aggregates in it. That’s what the HAVING clause is for. HAVING t1.field3=MAX(t1.field3)
After doing even MORE research, I think I have the answer to my question. Paul Stovell had this slightly edited response to a similar question on the DDD messageboard. Substitute “Customer” for “Employee”, and “Order” for “Violation” and you get the idea. Just because Customer references Order doesn’t necessarily mean Order falls within the Customer … Read more
How to read: This article is rather long. If you want to know about both aggregates and PODs (Plain Old Data) take time and read it. If you are interested just in aggregates, read only the first part. If you are interested only in PODs then you must first read the definition, implications, and examples … Read more
To concatenate a list of strings, use the string.Join method. The Aggregate function doesn’t work with empty collections. It requires a binary accumulate function and it needs an item in the collection to pass to the binary function as a seed value. However, there is an overload of Aggregate: public static TResult Aggregate<TSource, TAccumulate, TResult>( … Read more
Yes, because it’s an aggregate and returns zero. Unless you add GROUP BY in which case no result because there is no group… MAX/SUM etc would return NULL unless you add GROUP BY then no rows. Only COUNT returns a number for no results Edit, a bit late: SUM would return NULL like MAX Edit, … Read more
Note: My computer is running .Net 4.5 RC, so it’s possible that my results are affected by this. Measuring the time it takes to execute a method just once is usually not very useful. It can be easily dominated by things like JIT compilation, which are not actual bottlenecks in real code. Because of this, … Read more
According to the C++ 20 Standard (9.3.1 Aggregates. p. #3) (3.1) — If the initializer list is a designated-initializer-list, the aggregate shall be of class type, the identifier in each designator shall name a direct non-static data member of the class, and the explicitly initialized elements of the aggregate are the elements that are, or … Read more
You need to call Handle on the inner exceptions. From MSDN’s documentation on Handle: Each invocation of the predicate returns true or false to indicate whether the Exception was handled. After all invocations, if any exceptions went unhandled, all unhandled exceptions will be put into a new AggregateException which will be thrown. Otherwise, the Handle … Read more