SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Custom Header Row in Query Result

  Don't laugh too hard. For 36 months I've been sending a monthly file to a vendor that requires a cu…

  usererror

  27 replies

  4 years, 3 months ago

  By: Kristen-173977

• Can anyone explain the design decision here?

  I've been asked to take over maintenance of a system (the previous dev has left).  I've been looki…

  edwardwill

  35 replies

  4 years, 3 months ago

  By: ScottPletcher

• Import THIS xml file in an SQL DB

  Dear all! I have tried to use the seach function, but not found anything i could understand. What i…

  Edvard Korsbæk

  1 replies

  4 years, 3 months ago

  By: Ken McKelvey

• 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 s…

  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 primar…

  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 …

  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, 3 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, 3 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, 3 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, 3 months ago

  By: Paul Stasny