SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• divided by zero error in SQL please provide solution

  divided by zero error in SQL please provide solution

  kbhanu15

  3 replies

  3 days, 4 hours 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 week, 1 day 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 week, 1 day ago

  By: stan

• is this query correct and optimize?

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

  reza.asali

  1 replies

  1 week, 2 days ago

  By: Ken McKelvey

• 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 week, 4 days 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

  2 weeks, 4 days 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

  2 weeks, 5 days 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 …

  stan

  1 replies

  3 weeks, 2 days 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

  3 weeks, 3 days 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

  4 weeks 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 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 month ago

  By: Zososql

• can my phone run ssms inside our firewall?

  Hi my phone is now upgraded to allow teams , outlook etc using my work account.   Its a portal mo…

  stan

  3 replies

  1 month ago

  By: Mr. Brian Gale

• what have people done for ssrs params needing very precise start and end times

  Hi we run 2019 standard.  one of our mfg locations requires somewhat precise start and end param t…

  stan

  2 replies

  1 month ago

  By: Jeff Moden

• is netsuite's analytics warehouse (NSAW) a viable alternative to the sql stack?

  Hi our corporate level warehouse currently sits on sql server 2019 standard where some cubes also r…

  stan

  1 replies

  1 month, 1 week ago

  By: stan