Help Slow Query using User Defined Function
May 3, 2011 · Gert-Jan suggested that you don't use a user-defined function (UDF) for this purpose. Rather, you're better off using a JOIN to the base tables with a CASE expression to …
Financial function - social.msdn.microsoft.com
Jan 17, 2006 · Anyway, what is the reason for trying to implement the function in SQL Server? You can get the data from SQL Server into Excel easily and perform the computation there.
Sql query to get value after hypen - social.msdn.microsoft.com
Sep 27, 2011 · My requirement is get to the after second hypen value.For Example : ER-89-90 how to get 90 in sql server.
Index and table must user an equivalent partition function Errror
Feb 9, 2017 · It works great when I disable all other indexes I have on that table. If I rebuild the indexes I get the “ TRUNCATE TABLE statement failed. Index “IDX_table_name_1” is not …
Pass Datatable to Function of sql server - social.msdn.microsoft.com
Oct 7, 2021 · 2. From DataSet we will get xml data. 3. Then we pass the xml data to sql server. 4. In Sql server we create a table , then insert data from xml to table. 5. Then we can pass the …
Trimming text SSRS - social.msdn.microsoft.com
Sep 17, 2018 · Please can someone advise how to use LEFT and RIGHT (or some other function) to remove superfluous text either side of the data I want to output? I've tried a few …
STRING_SPLIT is not a recognized built-in function name
Oct 23, 2018 · The STRING_SPLIT function is available only under compatibility level 130 and above. If your database compatibility level is lower than 130, SQL Server will not be able to …
equivalent FORMAT () function in SSIS - social.msdn.microsoft.com
Sep 17, 2016 · The Format is used to format string or as a pattern of custom characters for dates and numeric values or format nvarchar argument specifying a culture.
OPENQUERY Error when calling usp - object has no columns or …
Nov 14, 2017 · To compile a query that uses OPENQUERY, SQL Server needs to know which columns it returns. To do this, it - or rather the OLE DB provider - runs the command with SET …
SSRS Total from sub-group to parent group
Jan 13, 2015 · Replace the expression from “=Fields!CustomerName.Value” to “SUM (Fields!Amount.Value)” and you will get the result as below: You can also repeat step1,step2 …