Aug 7, 2013 · There are a few ways to skin this cat, but I would replace the scalar function with a table function that accepts either a comma separated list of arguments or a table valued parameter.

Apr 16, 2009 · 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.

Jul 30, 2010 · If possible you should use the new ranking function added to SQL in SQL 2005. These functions are row_number (), rank (), danse_rank () and NTile (). But if you want ranks using SSRS …

May 31, 2016 · The way to convert Agent Tokens to T-SQL is to convert the ESCAPE_SQUOTE macro into T-SQL code. You can use parameters and insert the correct value to the parameter.

Jun 14, 2019 · I am looking for help on how to return a table of key/value pairs from a CLR function in SQL Server. I have this code. It doesn't work ATM. Still reading posts and watching videos, but they …

Nov 15, 2010 · The expression for the SQL is part of the GetSQL function: (simplified) Public Function GenSQL (SSN as String) as String Dim SQL as String SQL="select * from members R, …

Oct 1, 2012 · I am pretty sure that works for Functions as well. Please check and let me know, I was able to create a scalar valued function in master and mark them as system objects both in SQL 2005 …

Dec 21, 2017 · I have the below code works perfectly other than we have NULL for the record in db.

Apr 16, 2015 · I have a table of records with a column with a list separated by commas. I want to split this list and have a row for each however I don't have access to create functions myself. Is there any …

Jan 15, 2012 · Question 0 Sign in to vote is there any TOOL,function,stored procedure to convert sql code to SQLCMD like i put my code and it convert and print the code in format "SQLCMD" instead i …