SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• OT: Azure/Transact SQL Tutorials, not w3schools

  I have four or five years of experience writing various kinds SQL.  My colleague has very rudimenta…

  trent1967b

  3 replies

  4 years ago

  By: aaron.reese

• How to get Key based on type and sub type

  I Have sample data that looks like below. We have similar data like below for ton's of different ke…

  mcfarlandparkway

  5 replies

  4 years ago

  By: ScottPletcher

• Unable to extract DACPAC from D365 on-premises Sql database

  Hi, We have several database (Visual Studio) projects that all reference our organisation MSCRM ins…

  Kaine

  2 replies

  4 years ago

  By: Kaine

• IMPLICIT TRANSACTION and Recursive Stored Procedure

  I think I'm losing my mind! I have a stored procedure which needs to update a number of tables and …

  aaron.reese

  1 replies

  4 years ago

  By: aaron.reese

• IMPLICIT TRANSACTION and Recursive Stored Procedure

  I think I'm losing my mind! I have a stored procedure which needs to update a number of tables and …

  aaron.reese

  1 replies

  4 years ago

  By: aaron.reese

• Pivot columns to get 0 /1 flag columns

  Hi, I have a dataset of employees with different "Paytypes" in a single column. I am trying to pivo…

  masterelaichi

  22 replies

  4 years ago

  By: frederico_fonseca

• get column names and values in each row in SQL Server

  I Have ask from my vendor to send csv file with label and data in each row for the columns data i s…

  dhanekulakalyan

  9 replies

  4 years ago

  By: Jeff Moden

• How do I query to exclude the "first position of a 3 digit number"

  How do I set up a query for the following example (where "HOTEL_A" is the table, and ROOM_NUMBER is…

  bkufleitner

  32 replies

  4 years ago

  By: ScottPletcher

• query take long time when execute it so how to solve issue ?

  I work on sql server 2019 i face issue i can't reduce high cost of sort it reach to 86 percent so H…

  ahmed_elbarbary.2010

  12 replies

  4 years ago

  By: Jonathan AC Roberts

• Convert Excel formulas to SQL language automatically

  Is it possible convert Excel formula to SQL? I mean like this site for convert VB.NET to C#. I have…

  niksirat

  2 replies

  4 years ago

  By: aaron.reese

• FullText Search on PDF files

  Hi We have an existing solution where we store documents in the database in FileStream tables. The …

  Anders Hansen

  4 replies

  4 years ago

  By: Anders Hansen

• Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)

  Beginner here and trying to solve a problem from which I cannot find any clear solutions. I am supp…

  joJo4146

  7 replies

  4 years ago

  By: Jeff Moden

• Renaming JUST THE EXTENSION OF multiple files in a folder using SSIS

  Hi, I have three files in a folder - SourceFolder ABC.edifact DEF.edifact NJF.edifact I need to ren…

  ntreelevel

  3 replies

  4 years ago

  By: Ed B

• Problem : Passing a Variable is not working in Dynamic Query

  Hi all, I am not able to pass the table name as a constant in Dynamic Query: The logic is to loop t…

  oneteabag

  4 replies

  4 years ago

  By: oneteabag

• Convert Mysql to TSQL

  I am trying to correct the following code in SQL Server, please assist?   -- SQLINES LICENSE F…

  yrstruly

  12 replies

  4 years ago

  By: Ed B