SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• How to rank the records

  I am trying to figure how to create rank column in my query with the below logic. I need to group b…

  Angela4eva

  6 replies

  4 years, 7 months ago

  By: Angela4eva

• Execution plan flips from "good" to "bad" at a certain threshold

  We've got a particular stored procedure that's been a perennial problem performance-wise since it w…

  julian.fletcher

  14 replies

  4 years, 7 months ago

  By: ScottPletcher

• spellchecker in Report Builder 3.0 or SQL SERVER 2016

  Hi, Can someone tell me how to integrate Microsoft Words Spell Checker in SQL SERVER REPORT BUILDER…

  raverman

  3 replies

  4 years, 7 months ago

  By: Mr. Brian Gale

• Using If exists trying to assign the value to a variable when it exists.

  Hello Hope you can help it seems easy but not for me I have the following table id             se…

  Mond

  9 replies

  4 years, 7 months ago

  By: Mond

• MERGE with (SERIALIZABLE) deadlocks occasionally

  I am occasionally getting a "Transaction (Process ID X) was deadlocked on lock" when running the fo…

  giga123

  11 replies

  4 years, 7 months ago

  By: Steve Collins

• PA 640 file

  Has anyone imported the file they received? It comes as a .rpt but I've changed it to a txt. How wo…

  smattiko83

  1 replies

  4 years, 7 months ago

  By: smattiko83

• Sequence not always returning number

  Hello, Recently I came across an issue in production where a sequence is not always returning a num…

  louie1487 78804

  4 replies

  4 years, 7 months ago

  By: louie1487 78804

• Daily Counts by Month based on Start/End date

  Hello, wondering if somebody might have the most efficient way of creating a query of Daily Counts …

  boehnc

  9 replies

  4 years, 7 months ago

  By: boehnc

• Different average duration for update with primary key

  Hi , we running  query bellow UPDATE MyOrders SET col1 = @P11, col2 = @P12, WHERE pk_col0 = @P3 -- …

  ebooklub

  3 replies

  4 years, 7 months ago

  By: Sergiy

• count occurrences/frequency in a multiple value column

  Hi every one, Wondering how to extract the number of occurrence in a multiple value column. See exa…

  rogernc777

  6 replies

  4 years, 7 months ago

  By: Jeffrey Williams

• API Newbee

  Hi Guys, I'm completely new to API's and i was wondering if there is a way of retrieving the data f…

  Zed

  4 replies

  4 years, 7 months ago

  By: Steve Collins

• SQL Full text query too slow

  I have some Full Text Catalogs and since some time ago, the query time really slow down, and the on…

  ruifrazao

  14 replies

  4 years, 7 months ago

  By: Jeff Moden

• How to Store Special Symbols in SQL DB Table

  Following symbols are often used in the BIO tech resource articles.  How can I store them in SQL DB…

  yyang5823

  1 replies

  4 years, 7 months ago

  By: yyang5823

• 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

  4 years, 7 months 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

  4 years, 7 months ago

  By: ScottPletcher