SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Merge statement - matching ON all columns

  Dear SQL users, I have a need to refresh tables from Source to Target.  there is no particular 'ke…

  pisorsisaac

  1 replies

  1 hour, 19 minutes ago

  By: Phil Parkin

• Sum of Two Columns Only When One Column Has A Certain Value

  Dear Forum: I have two columns (Col3 and Col4).  I need a SUM of these two columns, but only when …

  AMCiti

  3 replies

  8 hours, 5 minutes ago

  By: AMCiti

• Needed to find all possible Dates Overlaps from a single Table

  Hi, I have the following Episode table example: Where DischDate = "2020-02-20" means - client has…

  Hell-1934

  10 replies

  19 hours, 52 minutes ago

  By: Hell-1934

• How to define data types

  What are the things you consider when you create a new table and define data types of each columns?…

  ocean3300

  9 replies

  1 day, 10 hours ago

  By: MVDBA (Mike Vessey)

• How to find out HOW MANY inserts, HOW MANY updates happend in merge

  How can i get the counts of how many records updated and how many inserted with Merge   MERGE …

  mcfarlandparkway

  5 replies

  3 days, 17 hours ago

  By: Mike01

• To show the count per month from the date provided

  I have two tables namely Vendors & Visits. Create Table Vendor (VendorId BIGINT IDENTITY(1,1) N…

  VSSGeorge

  2 replies

  3 days, 19 hours ago

  By: pietlinden

• need help Parsing XML

  Scenario 1 works just fine DECLARE @XMLT XML = '<Header> <ReportDate>10032017</Repor…

  koolme_85

  3 replies

  4 days, 4 hours ago

  By: Mr. Brian Gale

• In-memory database

  Hi, Currently i am processing records in SQL Server itself. Any recommended in-memory database, whi…

  LLSQL42

  11 replies

  4 days, 10 hours ago

  By: Grant Fritchey

• FUN only, solving a Puzzle.

  /* For FUN. I like puzzles, I like T-SQL coding, I like to show off :-), so why not combine these. …

  ben.brugman

  5 replies

  5 days, 11 hours ago

  By: ben.brugman

• Recursive CTE vs UNION ALL in a VIEW

  Hi, I'm trying to improve a VIEW which is made of several UNION ALLs, something like this: SELECT 0…

  Mauricio_

  60 replies

  5 days, 14 hours ago

  By: Mauricio_

• Copy the Code from an SSIS Package

  Hi Forum, I want to copy the .xml code from an existing SSIS Package to use later. I go to the SSIS…

  Oscar_Boots

  3 replies

  6 days, 2 hours ago

  By: Jeffrey Williams 3188

• Need help writing query to inactivate all except the most recent record

  In the following table, there can be multiple records per order (indicated by OrderID).  There is …

  Goalie35

  3 replies

  6 days, 3 hours ago

  By: Matt Miller (4)

• How to preserve leading zeros with insert into

            Below is the create table script and the insert into statement. …

  nevada19785

  13 replies

  6 days, 23 hours ago

  By: scdecade

• Error on executing rename statement

  Error on executing rename statement in a table. Not able to debug this. Please help. IF COL_LENGTH(…

  VSSGeorge

  3 replies

  1 week ago

  By: VSSGeorge

• Data Extraction Tools

  Currently using SQL Stored Procedure to write a script joining multiple to form a data and insert i…

  LLSQL42

  5 replies

  1 week ago

  By: LLSQL42