Shared stored procedure with very complicated input - So, the basics of what I want to accomplish is simple...I have a stored procedure that has some really complex...
Selective change tracking in a column - Hi, I have to count how many times a record changed from group 2 to group 1 or 3 per ID...
Trying to speed up this 'GetWorkingDays' function. - I'm trying to redesign one of our working days functions. The idea is to calculate weekends (easy enough) but holidays...
How to get columns which has null's - Hi Experts, Need some tsql help. I wanted all the column names from all below 3 tables which has nulls. i.e....
Having trouble displaying a date in a certain format... - Select Invoice_Exceptions.Invoice_Number, Invoice_Exceptions.ItemNum, Inventory.ItemName, Invoice_Exceptions.Amount, Invoice_Exceptions.Quantity, Invoice_Exceptions.Reason_Code, Invoice_Exceptions.LineNum, Invoice_Exceptions.EmpName, Invoice_Exceptions.DateTime AS Day_Voided, Invoice_Totals.Payment_Method From Invoice_Exception
MS SQL 2012 with 2 nodes Cluster - Hi, I have a question regarding sql 2012 cluster 2 nodes OS: Windows 2012 with AD SQL: MS SQL Server 2012 Cluster: 2 nodes First...
Connection Encryption - Protocols not showing the certficiate - Following https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine to setup SSL connections. Have got through to the part when you need to enable the certificate in the...
OPEN TEXTFILE FROM T-SQL - Hai Friends, I have this TXT FILE And I want to create Stored Procedure to insert to TEMP TABLE With each name of...
Performance Optimization: Can a varchar(max) be "SPLIT" into 8K chunks at the nearest delimiter AND quickly? - I've got a scenario where it might be almost impossible to change a data type for an existing stored procedure...
Handling string column with dates - I imported a csv file that has a column with dates. The column is a varchar type and it has...
SQL versus program - Hi all, I'm posting my question in this 2008 forum because we're running SQLServer 2008R2, but it is more a general...
Data in a row is being updated somewhere else during a stored procedure - Hi all, I have code in a stored procedure that is like this: IF EXISTS(SELECT * FROM table_a WHERE ID=@ID AND StatusID = 1)...
django (not the movie) - Does anyone have any experience with django and how it works with databases in development? I am getting thrown in to...
Argument "" for option "maxconcurrent" is not valid. The command line parameters are invalid. - Hello We have a strange problem, using SQL Server 2016, project development model. High level, the flow is as follows: Generate a...
Need help creating offline SSAS cube (2012) using Excel 2016 - I have an OLAP cube that I can display data from using an Excel Pivot Table and there seems to...
Table Index - I have a potential table CREATE TABLE dbo.Preferences ( EmailAddress VARCHAR(100) NOT NULL, ChannelID INTEGER NOT NULL, ContactTypeID INTEGER NOT NULL, AllowContact BIT NOT NULL, GDPR...
Extreme slowness - The site is extremely slow. It's taking as long as 2-3 minutes for a link to work.
Data row does not have a matching index row in the index - Hello, I have this problem. At monday found this, so drop and recreate index, then execute dbcc check and without problem. Today...
Using Windows Task Scheduler to detect SSIS package failure - I'm using Windows Task Scheduler with 32 bit dtexec.exe to execute an SSIS package and I was wondering how I...
Potential presentation idea: SQL Server for absolute beginners - So, I took today off from work to prepare and travel to SQL Saturday #517, and something occurred to me...
