SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• external script for Java

  I have a requirement to make a call to a Java class from stored procedure. How do I get the return …

  vpader

  9 replies

  4 years ago

  By: vpader

• Script to DROP and RE-CREATE all Primary and Foreign Key Constraints on all Tabl

  Hi Does anyone know of a good way to Drop and Recreate all Primary and Foreign Key Constraints for …

  Weegee71

  2 replies

  4 years ago

  By: Thom A

• Using CASE Statement with $Action in Output Clause in Merge

  Hi there I want to write one combined Output statement at the end of a Merge statement to insert da…

  Weegee71

  1 replies

  4 years ago

  By: ScottPletcher

• Sum of Rows

  Hi Guys, How do i group the below code so it gives e a total duration for each person for each day.…

  Zed

  1 replies

  4 years ago

  By: Jonathan AC Roberts

• Simple SQL query

  MOTEL (motelID, motelName, town) ROOM (roomID, motelNo, type, cost) BOOKING (motelNo, guestID, d…

  johnhobbs

  3 replies

  4 years ago

  By: ScottPletcher

• Problem with conversion from char to datetime

  Hello everybody. I am trying to insert  some data in table  Production.WorkOrder. There are some …

  Sajo1510

  7 replies

  4 years ago

  By: Sajo1510

• extract name to 3 single columns

  Is there a better way to extract to 3 single columns from one full name column: Lastname, FirstName…

  sqlfriend

  12 replies

  4 years ago

  By: Steve Collins

• Refactor subqueries into CTEs

  I've been tasked with turning this SQL into a stored procedure to populate an Aggregation table (on…

  edwardwill

  5 replies

  4 years ago

  By: edwardwill

• Cant cast VARCHAR(MAX) To XML Variable

  Hi there I would like to cast a NVARCHAR(MAX) variable string to an XML variable as follows: declar…

  Weegee71

  5 replies

  4 years ago

  By: Alan Burstein

• Debugger permission issue

  We have a dev that used to use SSMS in order to debug code that was related to SQL.  I guess MS ha…

  NotBob

  5 replies

  4 years ago

  By: Mr. Brian Gale

• SSIS Oracle Source - DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

  Hi All, I'm using Visual Studio 2019 to get data from a Oracle Database and transfer it to a SQL 20…

  BIDeveloper

  2 replies

  4 years ago

  By: BIDeveloper

• Filtering a hierarchy-related query

  I've got a table with LOTS of data. It's a tree-structure (using hierarcyId datatype) and I want a …

  oRBIT

  1 replies

  4 years ago

  By: Johan Bijnens

• Archiving data to a read only file

  Hi there I have a table for which archiving functionality is required. Now I have thought of writin…

  Weegee71

  2 replies

  4 years ago

  By: Jeff Moden

• Incorrect syntax near ','.

  Hi all I'm new to sql server 2019, so any help would be greatly appreciated. I'm trying to enter va…

  wapunga

  6 replies

  4 years, 1 month ago

  By: wapunga

• Help with a query

  Hi all! I want to create a stored procedure that returns a result based on the value of some DateTi…

  Puiu

  6 replies

  4 years, 1 month ago

  By: The Dixie Flatline