SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Migrating DB to new DB schema

  Hello everyone, I am rather new to SQL-Server and got a problem to which I cannot find a solution. …

  YoloJoeYolo

  14 replies

  1 year, 10 months ago

  By: frederico_fonseca

• Need help with the query

  How do I add 0 in the beginning but the length of the value cannot exceed 5 digit. For example, for…

  LearningDBA

  3 replies

  1 year, 10 months ago

  By: Ed B

• Inventory Query Help for linking Purchase order to transactions

  Hello Experts, I'm currently attempting to create an inventory report using data from inventory tra…

  Jondoe

  10 replies

  1 year, 10 months ago

  By: Zidar

• AI Tools

  Not quite sure where to post this or how quite to ask as its early stage I am looking for two type …

  plycons

  1 replies

  1 year, 10 months ago

  By: Grant Fritchey

• Openrowset & removing unwanted characters...

  Folks I'm wondering can you help me here. I have inherited a system that populates a table from Exc…

  jellybean

  3 replies

  1 year, 10 months ago

  By: Phil Parkin

• Pivot data without aggregating

  Greetings, I have a table of ID's and activities like the following and I need to pivot the data as…

  Paul Stasny

  10 replies

  1 year, 10 months ago

  By: Jeff Moden

• How to copy from one to another almost identical db

  I have inherited a demo db  called demo_1 and a live db with +300 tables. They are almost identical…

  Edvard Korsbæk

  3 replies

  1 year, 10 months ago

  By: Steve Jones - SSC Editor

• Split json column

  I have a column which has the following data in it for example {"changedAttributes":[{"logicalName"…

  forumlogger

  3 replies

  1 year, 10 months ago

  By: Phil Parkin

• Replacing last few characters with another value.

  I'm hoping for a bit of assistance, I know this is probably easy but just having a hard time solvin…

  Tava

  19 replies

  1 year, 10 months ago

  By: Jeff Moden

• Insert records based on value

  I have a query that returns how many weeks between 2 dates and would like to insert a record for ev…

  bob_kudulis

  1 replies

  1 year, 10 months ago

  By: Steve Collins

• Time Tally Table

  I'm attempting to create a time tally table but it is not working as expected. I just need a start …

  dougsto

  5 replies

  1 year, 11 months ago

  By: Jeff Moden

• Query column in table where column may have two values

  I currently have a table such as: id code 1 1 2 10,2 3 40 4 29,9 I have another table that con…

  DotNetCoder

  10 replies

  1 year, 11 months ago

  By: pietlinden

• Result of executing SQLCMD from command prompt differs from batch file

  I have the following to find the failed logins from yesterday from the server logs. sqlcmd -b -d ma…

  lan2022nguyen

  9 replies

  1 year, 11 months ago

  By: lan2022nguyen

• Powershell script executes locally but not after deploy to Server

  Hi, I have a package with a Execute Process Task object that executes a PowerShell script that down…

  BradWilk

  5 replies

  1 year, 11 months ago

  By: Phil Parkin

• how to reverse comma seprated values.

  hi, i have coma separated vales in a table. what i want to reverse it like 'CLP,CAD,GBP' pls tell m…

  rajemessage 14195

  5 replies

  1 year, 11 months ago

  By: Jeff Moden