No announcements
Found 2341351 threads
-
2 VotesPowerQuery - Web - Create function of function on multiple tables
First though I need to create a function of the first tidy to implement on the subsequent tables and then save the code and then merge the ...Answered | 3 Replies | 806 Views | Created by SaythJ - Sunday, November 1, 2015 9:50 AM | Last reply by Mike Honey - Manga Solutions - Monday, November 2, 2015 1:29 AM
-
2 Votes
PowerQuery - Pivot function
"}, "Sex", "Value", List.Sum) in Pivoted There is currently no UI for the pivot function.Answered | 4 Replies | 1395 Views | Created by Bruno Basto - Wednesday, October 30, 2013 11:43 PM | Last reply by circledchicken - Saturday, November 2, 2013 11:24 AM -
1 Votes
IF function in PowerQuery
Hi I have a table with 3 columns and I am trying to create another but I am having a bit of difficulty getting the right ...Answered | 1 Replies | 11895 Views | Created by Ishan86 - Thursday, January 4, 2018 10:05 PM | Last reply by MarcelBeug - Friday, January 5, 2018 2:34 AM -
0 Votes
Max function on tables
MangalAnswered | 2 Replies | 3592 Views | Created by signature2008 - Thursday, July 9, 2009 8:08 AM | Last reply by Mangal Pardeshi - Thursday, July 9, 2009 8:22 AM -
0 Votes
create function
have a negative impact on performance. If you have queries that use this function that seem to perform badly one way to improve performance at the expense ...Answered | 3 Replies | 6446 Views | Created by luisdanielurea - Friday, March 9, 2007 3:25 PM | Last reply by Kent Waldrop _ - Friday, March 9, 2007 3:35 PM -
0 Votes
function Table.TransformColumns for nested tables
;})}), ending with error: "Expression.Error: Cannot convert a value of type Function to type ...Answered | 2 Replies | 1928 Views | Created by hobbitalex - Sunday, June 15, 2014 11:52 AM | Last reply by hobbitalex - Monday, June 16, 2014 4:39 PM -
0 Votes
Create Function
Hi Rick, So the end result that we want to get is space information about drives on the server. In order to do that we should create a STORED PROCEDURE rather than ...Answered | 5 Replies | 6540 Views | Created by RickPeoples - Tuesday, May 10, 2011 5:31 PM | Last reply by Stephanie Lv - Thursday, May 12, 2011 3:23 AM -
0 Votes
Create CLR Function instead of Table value function
performance point of view , No I was asked to create a CLR Function instead of above scalar value function. I have ...Proposed | 2 Replies | 366 Views | Created by Vipin jha - Thursday, February 8, 2018 10:18 AM | Last reply by Olaf Helper - Thursday, February 8, 2018 11:26 AM -
0 Votes
Create view of inline function
create a view of a table function, unless you want the view results somehow filtered or different than the function ...Answered | 7 Replies | 5474 Views | Created by isorox - Wednesday, September 12, 2007 4:26 PM | Last reply by SQL-PRO - Wednesday, September 12, 2007 7:06 PM -
2 Votes
Granting Create Function Permissions
Taken from BOL: Requires CREATE FUNCTION permission in the database and ALTER permission on the schema in which the function is being created. If ...Answered | 4 Replies | 13070 Views | Created by Abercrombie07 - Tuesday, November 10, 2009 7:23 PM | Last reply by Abercrombie07 - Thursday, November 12, 2009 8:01 AM -
1 Votes
Function query different tables depending on input?
I'm trying to create a function that, depending upon the input variable, will query different tables. I know this is unorthodox, but the tables are ...Answered | 3 Replies | 4594 Views | Created by Tekito - Wednesday, August 19, 2009 4:30 PM | Last reply by Tekito - Wednesday, August 19, 2009 6:41 PM -
1 Votes
system tables function
is the function of system table? 2. can I delete them all? My database runs really slow sometimes (once or twice a day) and I found out i have numerous index ...Answered | 1 Replies | 3908 Views | Created by JayNoob - Thursday, April 26, 2012 11:53 PM | Last reply by Dan Guzman - Friday, April 27, 2012 1:23 AM -
0 Votes
Create Function query timeout
I kind of solved this for now by doing this. But not sure how did it work. 1. Dropped and recreated the assembly on which CLR function is ...Answered | 4 Replies | 822 Views | Created by Suman85 - Friday, September 2, 2016 1:47 PM | Last reply by Suman85 - Wednesday, September 14, 2016 3:20 PM -
0 Votes
Can't Create Recursive Function
. In the function, there is of course a recursive call to itself - GetUrParentCertNum. However, when I try to run the CREATE FUNCTION script, I get the ...Answered | 2 Replies | 5550 Views | Created by will f - Wednesday, August 1, 2007 4:45 PM | Last reply by will f - Wednesday, August 1, 2007 6:02 PM -
0 Votes
TSQL Create Function Help
It is not legal SQL to directly have a CREATE FUNCTION command as parf of an IF statement. The CREATE must be the first executable statement of a ...Answered | 4 Replies | 4866 Views | Created by ryager - Monday, October 26, 2009 12:15 PM | Last reply by ryager - Monday, October 26, 2009 1:34 PM -
0 Votes
Create Function
')) DROP PROCEDURE [dbo].[SP_TOOLPENFORADDM_DETAILS] GO SET ANSI_NULLS ...Answered | 1 Replies | 206 Views | Created by SR_MCTS - Wednesday, April 26, 2017 1:46 AM | Last reply by SR_MCTS - Wednesday, April 26, 2017 4:16 AM -
0 Votes
Multiple arguments for Function
Hello All, Greeting. I'm working on script to bulk update any attribute of the AD User. Created the script, but have a ...Unanswered | 5 Replies | 365 Views | Created by Karthic gujar - Friday, April 28, 2017 10:41 AM | Last reply by jrv - Friday, April 28, 2017 3:14 PM -
2 Votes
Create Function error
I am trying to create a UDF with the code below but I get an error of 'Invalid use of a side-effecting operator 'Crypt_Gen_Random' within a function.' Answered | 6 Replies | 2666 Views | Created by dlchase89 - Tuesday, December 31, 2013 5:29 PM | Last reply by Naomi N - Tuesday, December 31, 2013 9:33 PM -
0 Votes
Upload Multiple Pictures function
Hello, I recently upgraded from WSS 2.0 to 3.0. Just fooling around with 3.0, I noticed that the 'upload multiple pictures' function does not work properly. IUnanswered | 0 Replies | 7925 Views | Created by Lester Sconyers - Friday, September 14, 2007 4:44 PM | Last reply by Lester Sconyers - Friday, September 14, 2007 4:44 PM -
0 Votes
Create Scalar function
Hello, Instead of calling the function you can do it in the before calling itself ... SELECT CASE WHEN CONVERT(NVARHAR,@Start,101) = ...Answered | 6 Replies | 4569 Views | Created by EssCee - Monday, May 17, 2010 9:29 AM | Last reply by PavanKokkula - Monday, May 17, 2010 9:56 AM - Items 1 to 20 of 2341351 Next ›
No announcements
