SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Looking for a way to change all objects at once?

  Hi, I have a field in a table called prin_ball, upon doing a search for this, I would have to chang…

  itmasterw 60042

  3 replies

  5 years ago

  By: Jeffrey Williams

• Mirror Database without Domain

  Hello, I tried to make a mirror for my Demo database My Principal server is in the Domain by the na…

  stefgrifon

  1 replies

  5 years ago

  By: andreas.kreuzberg

• Help query to select part of string

  Hi Guys Hope everyone is well, i have a field called NAME with some data as shown below Name RECA-A…

  imranazam

  10 replies

  5 years ago

  By: homebrew01

• 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

  5 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

  5 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

  5 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

  5 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

  5 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

  5 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

  5 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

  5 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

  5 years 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

  5 years ago

  By: ScottPletcher

• 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

  5 years 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

  5 years ago

  By: pietlinden