SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Asking for suggestions for our SQL database/table architecture

  Hello everyone, my team and I are working on an application server for a forum site and try to setu…

  sqltobi

  3 replies

  4 years ago

  By: ScottPletcher

• Using CONVERT(...)

  I'm reading over stored procedures that have been written and came across this: CONVERT(NVARCHAR(32…

  ram302

  3 replies

  4 years ago

  By: Jeff Moden

• Index design on large and "wide" tables

  We have a database of some statistical measures for some entities per day. I can't share the full s…

  siggemannen

  9 replies

  4 years ago

  By: Jonathan AC Roberts

• Results-To-Text , Programatically

  I sometimes run queries against an IBM DB2 database, using an  old Navigator tool that has limited …

  homebrew01

  3 replies

  4 years ago

  By: Jeff Moden

• How to return a range value based on the first day of year and the value of row

  Hello, i have a table called Events, the value of that table like as bellow : create table Events (…

  IdealPR

  7 replies

  4 years ago

  By: Steve Collins

• Issue with the change of the column precision to be 2 decimal places

  Hello, I need to  change the % sales vs forecast column precision to be 2 decimal places instead of…

  JeremyU

  1 replies

  4 years ago

  By: Adi Cohn

• Issue with the SUM function

  Hello friends, I have one question. It may be a little bit hard to explain but I will try my best. …

  JeremyU

  10 replies

  4 years ago

  By: jschmidt 17654

• Using (or not) query HINTS to speed up slow statement

  The following statement returns 9000 rows in about 5 minutes on both SQL Server 2014 and SQL Server…

  cmartel 20772

  22 replies

  4 years ago

  By: cmartel 20772

• Problem with SUM and GROUP BY clause connection

  Hello friends, I have an issue with not understanding what happens when I sum and group the fields.…

  JeremyU

  4 replies

  4 years ago

  By: sgmunson

• SELECT CONTAINS is limited to 4000 characters

  In c# I use a function that generates Sql code that is executed through the SqlCommand.ExecuteReade…

  zequion

  1 replies

  4 years ago

  By: Grant Fritchey

• Automatic INSERT-INTO

  I have a view in my database where data is stored, it has 2 columns (ID and value) and 3 rows (ID1,…

  LD3060

  2 replies

  4 years ago

  By: ratbak

• SQL join based on column value

  I am trying to join two tables based on the condition. Table1: ID         Portfolio  3        Depar…

  learner0

  1 replies

  4 years ago

  By: frederico_fonseca

• ADD Values from a table to an another table

  I am working with Microsoft SQL Server MANAGMENT STUDIO 18  and i Have 2 Tables , i want to insert …

  LD3060

  2 replies

  4 years ago

  By: Zidar

• Conditional Where

  Hi, I have a where clause in my query that looks like this: WHERE items.UserNumber_02 IS NULL …

  ArnolddG

  5 replies

  4 years ago

  By: ArnolddG

• Issue with adjusting CAST in a calculation (precision)

  Hello friends, I believe it should be an easy fix for someone who is good at casting. I appreciate …

  JeremyU

  1 replies

  4 years ago

  By: frederico_fonseca