SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• I have never seen an insert statement with -= tablename in place of values

  We have a third part software and looking at some of their SQL we found this INSERT INTO tblSoftwar…

  lee.hopkins

  6 replies

  1 year ago

  By: lee.hopkins

• is this query correct and optimize?

  hello friends   update mkf set mkf.Score= mkf.score - ( select sum(pp.ScoreInScale) from…

  reza.asali

  2 replies

  1 year ago

  By: MMartin1

• I'm asking for guidance on how to best discover PK-FK relationships

  Last night I spent 45 minutes composing a complicated question here. When I finished I started the …

  Rod at work

  4 replies

  1 year ago

  By: Rod at work

• Split concatenated column data into separate rows

  My table1 has a column that has the following in it: (2)Joystick,(3)Candies,(6)Wires I want to writ…

  JP789

  6 replies

  1 year ago

  By: JP789

• divided by zero error in SQL please provide solution

  divided by zero error in SQL please provide solution

  kbhanu15

  3 replies

  1 year ago

  By: Jonathan AC Roberts

• TSQL Self Join to find differences?

  All, I have a table I need to query and I need to count the instances that the AgentExpDate changes…

  GBeezy

  3 replies

  1 year, 1 month ago

  By: drew.allen

• filling in even the group by cells

  hi we have a report that groups on the fields you see below per row, and on "week" in columns.  It …

  stan

  4 replies

  1 year, 1 month ago

  By: stan

• SSIS Package runs on one server but getting an assembly component error on anoth

  I posted this over on Stack Overflow and got bupkis and was hoping someone over here would be able …

  TMGiff

  11 replies

  1 year, 1 month ago

  By: TMGiff

• How to calculate potential IO benefits of changes

  I work on a multi terabyte warehouse database application which typically ingests between 130 and 1…

  Jez-448386

  27 replies

  1 year, 1 month ago

  By: Jez-448386

• ssis dashboard suddenly missing from reports option under catalog/ssisdb

  hi i rt clicked ssisdb today under integration services catalog , chose reports and didnt see the d…

  stan

  2 replies

  1 year, 1 month ago

  By: stan

• checking on some restrictions related to functions

  hi i'm helping a friend on his creation of a function.   here are the issues... he's getting an er…

  stan

  1 replies

  1 year, 1 month ago

  By: frederico_fonseca

• Is there a way to automate odbc configuration so you don't have id and password?

  Is there a way to automate odbc configuration so you don't have id and password? I need to automate…

  hillbillycarl

  2 replies

  1 year, 1 month ago

  By: hillbillycarl

• Why am I getting a "Incorrect syntax near '@tblName' error message?

  I'm working on a SQL script to delete all old tables starting with the name of "Old_". I'm testing …

  Rod at work

  5 replies

  1 year, 1 month ago

  By: Jeff Moden

• Execute SSIS generates error "create_execution has too many arguments specified.

  We recently upgraded our Dev server to SQL 2019.  Since upgrading, whenever we run an SSIS package …

  darrin.wilkinson.66

  2 replies

  1 year, 1 month ago

  By: jorcaraballo@gmail.com

• Lag function on an update not working

  I have a table with odds from sportsbook, and I need to populate a gamedate value that is null . Th…

  Zososql

  3 replies

  1 year, 1 month ago

  By: Zososql