General Q&A

Hi TX Support, I wanna know how to implementing scalar function with COALESCE in TX ? Here i attach the function, could you please tell me how to do that ?   USE [QAD_DATA]GO/****** Object: UserDefinedFunction [dbo].[GetAliasesByWo1] Script Date: 03/20/2018 16:15:04 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[GetAliasesByWo1]( @item nvarchar(max), @length float, @catego nvarchar(max), @opt nvarchar(max))RETURNS varchar(max)ASBEGIN declare @output varchar(max) select @output = COALESCE(@output + ', ', '') + wo_lot + '=' + convert(nvarchar, wo_qty_ord) FROM wo_mstr_data where wo_part = @item and wo__dec01 = @length and wo__chr01 = @catego and RIGHT(wo_rmks,1) = @opt and wo_status = 'R' and SUBSTRING(wo_routing,1,6) = 'REWORK' return @outputEND

How can we configure TX to create non clusted indexes to  filegroup 1 and depending on the type of table create the table on filegroup 2, 3 or 4?We are running SQL 2008 R2 standard so we don't have the partitioning features.

Did anyone tried to rename or modify the source code on system fields from being 'customdata' based on the filename or business unit you are unloading a text or excel file? I would really love this as this source code is one of my primary keys and it's uniform irrespective of the business unit I unload the data becoz of excel docs being used.   https://support.timextender.com/hc/en-us/community/posts/205685383-Source-filename-for-Multiple-text-file-data-source  

Hello fellow TimeXtender users, We were wondering: is it worth upgrading from SQL 2014 to 2016 in the scenario where we use TX traditionally: stage - dw - cubes. Has anyone done it and have you seen performance improvements? Thanks! Wim CALM - Co