SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• script to determine which database tables include both columns.

  Hi , script to determine which database tables include both columns. Any suggestions please.

  adisql

  1 replies

  2 years, 12 months ago

  By: DNA_DBA

• a good book on SQL

  Hello! Would someone please recommend a good book on SQL development? As an example, I consider "C#…

  nkat

  6 replies

  2 years, 12 months ago

  By: nkat

• Find Members who have lost eligibility for more than 3 years or more.........

  Find Members who have lost eligibility for more than 3 years or more and now returned in 2122. --I …

  dhanekulakalyan

  6 replies

  2 years, 12 months ago

  By: dhanekulakalyan

• How to change STRING_AGG to stuff xml to split feature value by pip?

  I work on sql server 2019 . i can't write query below with stuff for xml . so how to change STRING_…

  ahmed_elbarbary.2010

  13 replies

  3 years ago

  By: ahmed_elbarbary.2010

• 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

  3 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

  3 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

  3 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

  3 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

  3 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

  3 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

  3 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

  3 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

  3 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

  3 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

  3 years ago

  By: Anders Hansen