SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Azure SQL - Handling JSON column in the table

  Hi I want to convert table content which contain the json values in the columnin Azure SQL server. …

  mohankumar.trs

  6 replies

  5 years, 3 months ago

  By: sgmunson

• how to get total row count fastest?

  hello all I wrote this query and my goal is 0 sec for query Result. Declare @PrncplCompanyId int = …

  Li.Dia2020

  4 replies

  5 years, 3 months ago

  By: Mr. Brian Gale

• For XML Clause is slow

  Hello everyone, I am finding issue while running this query . WITH XMLNAMESPACES (DEFAULT 'http://e…

  Abhi kr

  11 replies

  5 years, 3 months ago

  By: sgmunson

• How to calculate a column recursively ?

  i have a data as below. Price = 25.0 Discount1=10 percentage Discount2=20 percentage Discount3=30 p…

  FKBEYS

  15 replies

  5 years, 3 months ago

  By: jcelko212 32090

• get top 5 max count for each month

  How do you return a list of the companies,  sales, and month for the top 5 sales for each month wit…

  michaelyarbrough1975

  9 replies

  5 years, 3 months ago

  By: sgmunson

• Cant figure out how to pull data from one table but get diffrent results

  I have an Employee table that has a primary key. This key is used in another table for both a Welde…

  RGSjjarrett

  6 replies

  5 years, 3 months ago

  By: pietlinden

• insert update help in sql server

  Hello All, I have a insert update procedure where I am getting data from 2 procedures and putting t…

  Krish319

  1 replies

  5 years, 3 months ago

  By: Mr. Brian Gale

• SSMS Generate Script Replaces Quoted Identifiers with Square Brackets

  I've been coming to this site for years. I've never registered, and I almost always find the answer…

  kmhelton1

  7 replies

  5 years, 3 months ago

  By: Jeff Moden

• How to Identify Slow Code

  In a specific Query, how can you easily identify how long each piece of code is taking? My query is…

  jakegordon1997

  4 replies

  5 years, 3 months ago

  By: Grant Fritchey

• DateDiff for only @p_start_date and @p_enddate

  So I am trying to get the datediff for parameters selected, even though the 2 dates could span 60 d…

  cbrammer1219

  5 replies

  5 years, 3 months ago

  By: kaj

• SQL Collation to match IBMi

  In SQL, these items sort this way INV175 INV190 INVB03 INVB04 On the IBM iSeries, they sort. INVB03…

  homebrew01

  2 replies

  5 years, 3 months ago

  By: EdVassie

• create view out of dynamic query from INFORMATION_SCHEMA.COLUMNS

  Hi, Is there a way to create a view out if this query below? DECLARE @query nvarchar(max) SELECT @…

  d_martins

  8 replies

  5 years, 3 months ago

  By: dkultasev

• Get multiple values out of xml

  Hi I have the following Syntax:   DECLARE @MyXMLString XML SET @MyXMLString = '<items> …

  GG_BI_GG

  6 replies

  5 years, 3 months ago

  By: DesNorton

• Change color scheme for Admin account in SSMS

  I was reading one of Brent Ozar's posts about SSMS, and he was talking about "never use the sa/admi…

  pietlinden

  11 replies

  5 years, 3 months ago

  By: Steve Jones - SSC Editor

• Logging (auditing) in the table vs. having a logging (auditing) table

  I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I'v…

  Rod at work

  7 replies

  5 years, 3 months ago

  By: Jeffrey Williams