SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Is there good practices on creating the database and schema using stored Proc?

  Hi , we would like to automate the database  and schema creation with master data for one of our pr…

  sram24_mca

  7 replies

  4 years ago

  By: Grant Fritchey

• SQL agent failed job report last 24 hours

  Hi All, Posting it on development group, if anyone can provide query. Basically, I am seeing 100+ f…

  Saran

  5 replies

  4 years ago

  By: Steve Jones - SSC Editor

• sql server keeps looking for my User Defined Scalar Function in the Master DB

  I have a Visual Studio project web site that I have been using for years. The move to SQL server 20…

  brian.cook

  25 replies

  4 years ago

  By: brian.cook

• outer apply alternative

  My goal is to get the results below. Trying to get the nearest date and result from the #Data table…

  boehnc

  3 replies

  4 years ago

  By: Jeff Moden

• MAXRECURSION 0 Option

  Hi Everyone, I am trying to apply a Multi table function that uses a recursive CTE. When I apply it…

  Scott745618

  8 replies

  4 years ago

  By: Adi Cohn

• Convert string containing ''yyyyMMdd_HHmm' back to Datetime format (dd-mm-yyyy

  Hi there I have a database table containing historical data This table contains the name of tables …

  Weegee71

  6 replies

  4 years ago

  By: SwePeso

• Speed up join

  Hi everyone, I am working on a join that takes days to run, the code is below (it has been edited f…

  Scott745618

  26 replies

  4 years ago

  By: ScottPletcher

• SQL If not null then insert N

  Is there a way to write a line into a SQL so that the column only shows a N if there is something i…

  FrancisH

  4 replies

  4 years ago

  By: Eddie Wuerch

• Cross-Tab & Concatenate Rows with a join : Help with a Query

  Hi, Can someone please help me with a query? I have two tables and I want the concatenate rows as a…

  sqlguru1day

  2 replies

  4 years, 1 month ago

  By: sqlguru1day

• SQL Subqueries

  Hi ! i got a task where i am to post only the Reshnum of the Department with the highest count of a…

  beefycarrot

  5 replies

  4 years, 1 month ago

  By: ScottPletcher

• Snowflake ODBC to SQL Ole Destination ERROR

  Hi there, everyone. We've create and SSIS package that gets data from a Snowflake database via an O…

  darkangelBDF

  3 replies

  4 years, 1 month ago

  By: jeremy.davis

• Printing the Highest count

  i have a Problem in my code, the case is this. I need to count the amount of employees in all the d…

  beefycarrot

  4 replies

  4 years, 1 month ago

  By: ScottPletcher

• table-valued functions, temp tables etc - when to use each one?

  Sorry for the dumb question, but given all the "things" that return tables... temp tables, table-va…

  pietlinden

  4 replies

  4 years, 1 month ago

  By: pietlinden

• Set Cache Size of Sequence

  Hi, I've got the following version of SQL Server installed. Microsoft SQL Server 2016 (SP2-CU16) - …

  robh0502

  5 replies

  4 years, 1 month ago

  By: frederico_fonseca

• xp_subdirs cannot access LAN location

  Hello, I have a problem with "xp_subdirs" inside a stored procedure that always has worked in the p…

  cpd_318

  2 replies

  4 years, 1 month ago

  By: WHug