SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Fax/Phone Area code Substring

  Hello, For the below SQL, why the column "Phone_Country_Code" Code is showing "0" instead of Empty …

  getsaby

  2 replies

  4 days, 18 hours ago

  By: getsaby

• SQL 2017 server keeps locking up

  I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows Server 2019, whi…

  karenhallard

  2 replies

  1 week, 6 days ago

  By: jasona.work

• Splitting Text based on certain phrases in string

  I have a text string that contains something similar to below : [{"ChannelName":"LOT4 - Telephone",…

  carlmeads1975

  10 replies

  2 weeks, 5 days ago

  By: carlmeads1975

• Fuzzy logic between two columns

  Hello, I have tried various methods to accomplish this using functions like PATINDEX, DIFFERENCE,…

  getsaby

  6 replies

  1 month ago

  By: getsaby

• Execution Timeout Expired Error while executing an SQL query

  Following error comes while executing an SQL query. Execution Timeout Expired. The timeout period e…

  IT researcher

  17 replies

  1 month, 1 week ago

  By: Lisa Slater Nicholls

• How to convert run_date and run_time columns to datetime from SQL Agent systable

  Hello SSC, Hope you are all having a great Monday! I am trying to get the run_date and run_time  i…

  Lord Slaagh

  3 replies

  1 month, 1 week ago

  By: SoCal_DBD

• Sum case nulls and 1900-01-01 00:00:00.000

  Hi Guys. I have the following as part of my statement and it counts the '1900-01-01 00:00:00.000' f…

  craig.jenkins

  7 replies

  1 month, 3 weeks ago

  By: vgailesen

• Symmetric Key EncryptByKey returns NULL value

  I haven't used column level encryption because usually the vendors I deal with have .dlls to do tha…

  Brandie Tarvin

  6 replies

  2 months ago

  By: Brandie Tarvin

• Send results of a SQL query in Outlook email body

  Hello SSC! I hope everyone had a great holiday! Happy New Year to all! Issue: I am currently using …

  Lord Slaagh

  11 replies

  2 months, 1 week ago

  By: Audionova

• Database Archive missing FK

  Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger la bas…

  abdalah.mehdoini

  2 replies

  2 months, 3 weeks ago

  By: Jeff Moden

• Testing whether TRY_CONVERT is losing precision

  Hello All, I am using TRY_CONVERT to parse character data into a decimal column. I want to generate…

  Chrissy321

  2 replies

  2 months, 3 weeks ago

  By: Chrissy321

• Timeout Error while executing a TSQL statement in Sql server Express Edition

  I am getting the below error when I execute a SQL command in SQL Server 2017 Express Edition Execut…

  IT researcher

  1 replies

  3 months ago

  By: IT researcher

• Timeout Error while executing a TSQL statement in Sql server Express Edition

  I am getting the below error when I execute a SQL command in SQL Server 2017 Express Edition Execut…

  IT researcher

  2 replies

  3 months ago

  By: ScottPletcher

• Pivot Help

  Hi Guys I need help pivoting the following SELECT [ID],[code_name],,[retail_price] FROM products 1 …

  mashispano

  5 replies

  4 months ago

  By: kaj

• Deduplicating rows by choosing the row with the shortest string

  Hello T-SQL experts I have a table containing team codes and descriptions. Unfortunately, many of t…

  Mark Dalley

  8 replies

  4 months, 2 weeks ago

  By: Eirikur Eiriksson