SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• How do I connect to a SQL 2019 instance, from another computer?

  I'm working on an ASP.NET MVC app, following along a tutorial in CODE magazine. I'm doing this tuto…

  Doctor Who 2

  3 replies

  4 years ago

  By: Doctor Who 2

• JOIN with CASE statement (multiple columns)

  I read a couple of explanations online, but it is still hard for me to understand how to join two t…

  JeremyU

  2 replies

  4 years ago

  By: frederico_fonseca

• Help need structuring a query

  I need some help structuring q query. In my database, I have two tables: Entity: columns are Entit…

  Gerry Roston

  1 replies

  4 years ago

  By: Gerry Roston

• Closest to date within 3 days

  I think I'm close but not close enough...and preferably, I'd like to use something different than a…

  boehnc

  4 replies

  4 years ago

  By: Phil Parkin

• convert easting/northing to longitude and latitude

  I have the following geometry datafield that seems to be in easting/northing format and I would lik…

  HildaJ

  2 replies

  4 years ago

  By: RamonS

• Extraction of mean, max, min and sd extraction inside 5-95 quantiles

  I'd like to extraction the mean, max, min and sd extraction inside 5-95 quantiles for the variables…

  leprechault

  5 replies

  4 years ago

  By: jschmidt 17654

• ETL Best Practice - Need help and possible part time gig available

  Hi, we've been working with consultant (who we may terminate) within our organization to come up wi…

  mrpaulytx

  6 replies

  4 years ago

  By: Jeff Moden

• SQL StoredProcedure for data validation using REGEX in SSIS

  hi, I have a requirement where we get data from Oracle source and destination is also Oracle db. On…

  komal145

  3 replies

  4 years ago

  By: komal145

• 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 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 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 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 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 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 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 ago

  By: Weegee71