SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

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

  By: dmbaker