SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

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

  By: Jeff Moden

• Invalid length parameter passed to the LEFT or SUBSTRING function.

  HI, I am using the below query to fetch a data from SQL server. But the query returned Invalid leng…

  susheelbharadwaj

  4 replies

  5 years, 1 month ago

  By: Jonathan AC Roberts

• Find Space occupied by a Row

  Hi All, Do we have any way to find out the space occupied by individual records in a table? My obje…

  T.Ashish

  5 replies

  5 years, 1 month ago

  By: Jeff Moden

• syntax error on insert

  Hi, I am brand new to SQL.  I'm using postgres with PopSQL interface. I am trying to run the follow…

  CodeCaptain

  2 replies

  5 years, 1 month ago

  By: CodeCaptain

• Week Ending Thursday, can some one tweek my code?

  What I have missed from this code? I'm trying to show the DateTimeRaised field as a week ending Sun…

  bark01

  1 replies

  5 years, 1 month ago

  By: Mr. Brian Gale

• Nested Json Parsing issue

  Greetings, I am having issues parsing the following Json string using openjson. I am having problem…

  Paul Stasny

  2 replies

  5 years, 1 month ago

  By: Paul Stasny

• How to use stored procedure result set into a script task in SSIS

  Hello, guys! I created a SSIS package in Visual Studio Community 2019: Everything is working fine,…

  eduardoalmeidabr

  2 replies

  5 years, 1 month ago

  By: dmbaker

• Are there application developers in here? Where are you doing your SQL?

  Hi, Are there app developers in this forum? Where does your app's SQL live? I'm out with a new vers…

  bbsimonbb

  2 replies

  5 years, 1 month ago

  By: bbsimonbb

• Python in SQL Server 2019

  Hi I am working a lot with SQL Server and Python and after updating the SQL Server from 2017 to 201…

  peter-661823

  3 replies

  5 years, 1 month ago

  By: Mr. Brian Gale

• Subqueries that return one value vs. multiple values

  I am testing two examples in which a WHERE clause is compared to the results of a subquery. SELEC…

  michael.leach2015

  5 replies

  5 years, 1 month ago

  By: Jeff Moden