SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Hello I need help to improove the following query with many joins

  Hello I have this query   SELECT ISNULL(sta5.AttributeValue, rdd5.Value) as 'Manufacturer Code…

  Mond

  7 replies

  5 years ago

  By: Mond

• Need help to form query to get missing month data

  I want to know what are the customers having missing month data based on the following data pattern…

  anuxps

  16 replies

  5 years ago

  By: ScottPletcher

• SQL Pivot?

  Hi, I have this special requirement as a query result, and I wonder if SQL PIVOT can be used to ach…

  ErwinB

  10 replies

  5 years ago

  By: frederico_fonseca

• Getting the top unique value by group

  . This topic was modified 5 years ago by David.Toews 95002. Reason: Would like topic remove…

  David.Toews 95002

  3 replies

  5 years ago

  By: jcelko212 32090

• db size for all db's across servers from cms

  how do I calculate db sizes of all databases across all servers from cms declare @dbsizes TABLE (se…

  mtz676

  6 replies

  5 years ago

  By: david.edwards 76768

• Code to auto-update tables on set date

  I am in a project where information is being pulled from a database then put into a web page in a m…

  thetubageek

  33 replies

  5 years ago

  By: ScottPletcher

• Joining 2 select results into a single row

  select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus …

  mtz676

  20 replies

  5 years ago

  By: sgmunson

• query

  Hi i have 3 table that need to find out which id missing two tables TABLES: Main,table1 and table2 …

  sankaripr

  5 replies

  5 years ago

  By: jcelko212 32090

• Other methods of getting the true length of UTF8 String?

  Something I've been playing around with lately is the UTF8 functionality in 2019, and it dawned on …

  Thom A

  15 replies

  5 years ago

  By: Thom A

• How to get these description from XML into the table?

    I want all these description in different row. TIA Example descriptions 0|Home 1|Office|Fals…

  NewDBA201

  4 replies

  5 years ago

  By: Jeff Moden

• case statement issue

  SELECT CASE WHEN EXISTS ( SELECT name,enabled FROM msdb.dbo.sysjobs WHERE name = 'Myjob' ) THEN 'Ex…

  mtz676

  2 replies

  5 years ago

  By: jcelko212 32090

• SQL Agent and Windows Task Scheduler

  Hi Guys, Has anyone used windows task scheduler with SQL Agent? I have a FTP which needs to be impo…

  Zed

  5 replies

  5 years ago

  By: phegedusich

• Date time diff

  Hello all, trying to return the time in minutes between the Date1 and Time1 columns and the Date2 a…

  boehnc

  3 replies

  5 years ago

  By: Michael L John

• \'DBMS_DATA_MINING\' is not a recognized CURSOR option

  Is DBMS_DATA_MINING available in SQL Server 2019? This is error: 'DBMS_DATA_MINING' is not a recogn…

  mtl20144102

  1 replies

  5 years, 1 month ago

  By: frederico_fonseca

• SQL Server - Issues with Update When Summing Source + Target Columns in Batches

  Hi guys, I am trying to update a large table in small batches. Within the update statement, I am se…

  milkycow

  2 replies

  5 years, 1 month ago

  By: milkycow