SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• SP causing blocking

  I have a simple proc that I suspect is causing intermittent blocking.  It takes a customer ID (int)…

  John Deupree

  7 replies

  4 years, 10 months ago

  By: John Deupree

• T-SQL Unique Index - classification of unique - advice needed

  I have inherited a data warehouse with Type II SCD tables. Each row has an entity_identifier (not n…

  aaron.reese

  3 replies

  4 years, 10 months ago

  By: Thom A

• Help with code

  Hi, I have the following code which will give me a list of every fortnight between two dates howeve…

  g12consult

  5 replies

  4 years, 10 months ago

  By: g12consult

• sp_OAMethod to make rest api call

  Greetings, I have a need to call a rest api against a resource. It a POST and would like to send th…

  yosiasz

  3 replies

  4 years, 10 months ago

  By: Sandeep Kataria

• Placing a Case Statement with a varialble into a Where Clause

  I have the following statement in my stored procedure SELECT mpe.MeasuringPointEntryID FROM [locati…

  Weegee71

  3 replies

  4 years, 10 months ago

  By: Michael L John

• Update a table with inserted value of another table

  A good day to all the pros! I am trying to create a sproc to update the value of a table with the i…

  sqlislife

  3 replies

  4 years, 10 months ago

  By: sqlislife

• FOR JSON command adding carriage return to output

  I'm pretty new a creating JSON output form SQL server. I'm having trouble with carriage returns bei…

  fxferguson

  3 replies

  4 years, 10 months ago

  By: ArmandoRohan

• How to extract date from a long string

  Hi All, have a long string like below in my column and I need to extract only the date (2021-07-05)…

  Krish319

  3 replies

  4 years, 10 months ago

  By: TerryG

• Customers count on first of the month report

  Hi all! I'm a t-sql beginner and have to generate a report as it follows: First_of_Month | Customer…

  mario.it

  3 replies

  4 years, 10 months ago

  By: kaj

• Create New Table - Count Columns

  Hi all,   I am new to writing SQL code and am wondering the best way to create a new table fro…

  HenPBIPatron

  5 replies

  4 years, 10 months ago

  By: J Livingston SQL

• Trying to use rowversion (Timestamp) in SSIS as a for a high watermark

  Trying to use rowversion (Timestamp) in SSIS as a for a high watermark to extract changed data Fail…

  gjryan59

  9 replies

  4 years, 10 months ago

  By: alon_ze

• Help with UNPIVOT function with multiple conditions

  Hi Community, I have a table which needs to be unpivoted so, that I can have weekly sales & Vol…

  sqlguru1day

  5 replies

  4 years, 10 months ago

  By: pietlinden

• Incremental/Delta Import into SQL

  Hi Community, I need a solution for a problem. I have excel files which needs to be imported into a…

  sqlguru1day

  5 replies

  4 years, 10 months ago

  By: sqlguru1day

• Having sum(amount) = 0 returns negatives as well.

  Hello all, I'm trying to get a list of ID's that have a total sum of their amount column = to zero.…

  C-M-A

  5 replies

  4 years, 10 months ago

  By: jcelko212 32090

• Function not returning all data.

  I inherited this code. Written by a 3rd party. I have 3 servers, 1 publisher 2 subscribers. Thomson…

  David C Young

  5 replies

  4 years, 10 months ago

  By: David C Young