Mar 29, 2023 · Aggregate functions that are used with CUBE, ROLLUP, or GROUPING SET queries must provide for the merging of subaggregates. To fix this problem, remove the aggregate function …

Nov 2, 2015 · Using SQL Server, how do I split a string so I can access item x? Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which should return …

Dec 8, 2019 · I need to search an SQL Server database for all mentions of a specific string. For example, I would like to search all tables, views, functions, stored procedures, ... for string …

SQL Server 2005 and later allow you to create your own custom aggregate functions, including for things like concatenation- see the sample at the bottom of the linked article.

SOLUTION The definition of optimal can vary, but here's how to concatenate strings from different rows using regular Transact SQL, which should work fine in Azure.

Possible Duplicates: Is there an Implode type function in SQL Server 2000? How can I group fields from multiple records in T-SQL by another field? I have a view which I'm querying that looks like t...

Jun 21, 2019 · It's not about SSMS, it's about SQL Server version. STRING_SPLIT() is starting with 2016, and TRIM() function starting with 2017, so you need SQL Server 2017 to use both. It doesn't …

Jul 3, 2012 · LEFT and RIGHT are SQL Server functions that do what LPAD / RPAD do. You may have a user-defined function in your DB, that would explain the slowdown.

In SQL Server 2017 and above, you can achieve proper case by combining STRING_SPLIT, a CTE with ROW_NUMBER to maintain word order, and STRING_AGG to reassemble the string.

Jul 14, 2016 · What is the difference between scalar-valued, table-valued, and aggregate functions in SQL server? And does calling them from a query need a different method, or do we call them in the …