SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Sum days for fiscalyear

  I am trying to sum the values for each day of the month within a fiscal year, I am converting Oracl…

  cbrammer1219

  19 replies

  5 years, 4 months ago

  By: Jeff Moden

• Extracting a Date Properly from a String.

  If i have a string of the following format master_20200613220000.bak Then How do i display the Date…

  satnam.singh 44358

  1 replies

  5 years, 4 months ago

  By: frederico_fonseca

• New to SQL and need to write a query

  Hello all   I am new to using SQL and was asked to write a query. I was told what tables I nee…

  wheddingsjr

  2 replies

  5 years, 4 months ago

  By: Grant Fritchey

• Is SELECT a part of DML, DDL or something else?

  According to this post https://www.sqlservercentral.com/blogs/what-is-%e2%80%93-dml-ddl-dcl-and-tcl…

  michael.leach2015

  13 replies

  5 years, 5 months ago

  By: jcelko212 32090

• Is it acceptable to use the presence of a value in a NULLable column as a flag?

  I have a stored procedure that processes rows in a table. The stored procedure is called by an exte…

  edwardwill

  9 replies

  5 years, 5 months ago

  By: jcelko212 32090

• Json String to Multiple Rows

  Greetings, I have a json string in the following format and I need to split a small portion out to …

  Paul Stasny

  3 replies

  5 years, 5 months ago

  By: Paul Stasny

• Tab Delimited OPENROWSET layout issue

  Hello folks! I have a client trying to impor a tab delimited file which I need to perform some ETL …

  ibbo14

  3 replies

  5 years, 5 months ago

  By: frederico_fonseca

• T-SQL parsing query

  Hi Guys, I need help with the SQL query. I need help with parsing one field to 4 different fields. …

  rocky_498

  8 replies

  5 years, 5 months ago

  By: Jeffrey Williams

• Integer convert to percent

  Having trouble with the below formula. Technically I want to display it by a percentage with two d…

  nymets86

  11 replies

  5 years, 5 months ago

  By: Jeff Moden

• Date Join Issue

  I joined two tables together trying to get a field out of one and inserted into the other.  The fie…

  nymets86

  9 replies

  5 years, 5 months ago

  By: nymets86

• Data moth wise

  Hi All, I just trying to get data month wise, following is just sample table. I would like to get a…

  Saran

  7 replies

  5 years, 5 months ago

  By: Saran

• DB Design/Normalization Question

  Hello, I've read the posts on this site and elsewhere about normalization -- I have a scenario in a…

  EsquireDeveloper

  12 replies

  5 years, 5 months ago

  By: EsquireDeveloper

• Custom Pivot Table

  I have an old post about this but I did not do it correctly. So here is my attempt to follow the ru…

  SQL Espo

  11 replies

  5 years, 5 months ago

  By: Jeff Moden

• Get dates between previous month date and current month date

  BI have a requirement to write a query to get all the records between 21st of previous month to 20t…

  Raja Raman S

  1 replies

  5 years, 5 months ago

  By: Ken McKelvey

• DATEFIRST

  hi Is there a way to SET DATEFIRST server or database wide?  I need Saturday  be first day of the w…

  mo

  3 replies

  5 years, 5 months ago

  By: Jeff Moden