SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Max of 2 columns gets sent to the third column (SQL)

  Hello everyone, I am trying to combine two columns (Current last receipt) and (Historic last receip…

  JeremyU

  9 replies

  4 years, 1 months ago

  By: Jeff Moden

• Inserting a substring value into an already existing entry

  currently I have a database with the following parameters and entry:   Now I want to fill the…

  JJM50

  1 replies

  4 years, 1 months ago

  By: Mr. Brian Gale

• Extracting a Median Date out of a Group of Records using a Query with NTILE

  Hi there I have a table of data readings which I am able to use NTILE to sucessfully extract the Mi…

  Weegee71

  7 replies

  4 years, 1 months ago

  By: Steve Collins

• Non-clustered Index

  I have a blog. To log in, I request a User Name. Should I have a non-clustered index on that column…

  dc4444

  13 replies

  4 years, 1 months ago

  By: dc4444

• Calculate count of credit decision (One or multiple custom sql)

  Hello All, Hope you guys are doing good. I have a requirement to take a count of decisions in the b…

  pradeep_as400

  3 replies

  4 years, 1 months ago

  By: Steve Collins

• Issue with joining the tables correctly

  I have such a difficulty. I want every record every record in WHSIBLM where IBONHD is not 0. But I …

  JeremyU

  1 replies

  4 years, 1 months ago

  By: ratbak

• Calculating Min, Max and Average values from pre-determined groups of data

  Hi there I have a table of readings which can vary in the number of records which can be anything f…

  Weegee71

  2 replies

  4 years, 1 months ago

  By: Weegee71

• View or Stored Procedure?

  To create an output like this: Do i create a stored procedure or view that would allow this end re…

  yrstruly

  7 replies

  4 years, 1 months ago

  By: Jeff Moden

• 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months ago

  By: jschmidt 17654