SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• SQL query to find last date a product was checked before it was installed

  I have two tables, one covers jobs for a product and the other covers the last time a product was c…

  dcaulton73

  6 replies

  4 years, 3 months ago

  By: Kristen-173977

• Add column to existent table with default costraint value based on condition

  Add column to existent table with default value based on condition Hello, i would to create a new c…

  first100

  7 replies

  4 years, 3 months ago

  By: Kristen-173977

• Vague job scheduler support for SQL Server on Linux

  I’m having some trouble figuring out the kind of support for Linux that the SQL Server 2019 job sch…

  Scott McIntosh-222013

  3 replies

  4 years, 3 months ago

  By: surperKK

• Server is fast, then slow, then fast with no pattern "Solved?"

  I am having a problem with my sql server running queries and using it in Visual Basic.  The primary…

  Jocar26

  8 replies

  4 years, 3 months ago

  By: Ken McKelvey

• Using IF EXISTS in a select statement

    Hi All, I've got a couple of tables and I'm trying to use IF EXISTS to decide if I need to g…

  paul 69259

  4 replies

  4 years, 3 months ago

  By: GroverVivek

• Pivot Table SQL

  I would like your support to find a solution for my problem of duplicating several lines instead of…

  ak24

  4 replies

  4 years, 3 months ago

  By: GroverVivek

• Why I have problem with adding IDENTITY in my table?

  I want to create Table which name is ARTIKAL. Also I want to set Identity  in ID column but every t…

  Sajo1510

  9 replies

  4 years, 3 months ago

  By: Jeff Moden

• MS SQL Server 2008 R2 upgrade to what?

  database in MS SQL Server 2008 R2 (web edition) for website I have a nice development in the above.…

  Digs

  14 replies

  4 years, 3 months ago

  By: Steve Jones - SSC Editor

• It does not keep the data in the table being filled from a stored procedure

  I would like to know why when consulting a table that is filled with a stored procedure and the las…

  AlexRodriguez1990

  6 replies

  4 years, 4 months ago

  By: Grant Fritchey

• SQL Query - Get Start/End Date per Employment Period

  Hi All, Need to get Start and End Date per eployment period, meaning an employee can be hired and r…

  kburata

  1 replies

  4 years, 4 months ago

  By: Ken McKelvey

• function output

  Hi Expert,   I am troubleshooting this function and unable to understand the actual output fro…

  Shree23

  1 replies

  4 years, 4 months ago

  By: Ken McKelvey

• SSRS Parameter - Convert from Int to Text

  Greetings, I have an SSRS Report where I am trying to create a parameter of text Dropdowns from a S…

  Paul Stasny

  2 replies

  4 years, 4 months ago

  By: Paul Stasny

• Sequentially Adding Variable Number of Rows

  I need to add a number rows together and I'm not sure how to do it. I have the following dataset. …

  roong

  4 replies

  4 years, 4 months ago

  By: roong

• SSRS 2019 & PDF

  Hello from Germany, can anyone tell me, whether SQL Reporting Services 2019 can render reports as a…

  Monti99

  1 replies

  4 years, 4 months ago

  By: Monti99

• @@TRANCOUNT = 2?

  Just a curiosity question... When executing a DML statement in autocommit (normal) mode, the @@TRAN…

  duckpond_wkb

  2 replies

  4 years, 4 months ago

  By: Goldner