SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

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

  AMCity

  3 replies

  5 years, 6 months ago

  By: AMCity

• 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 hasn'…

  Hell-1934

  10 replies

  5 years, 6 months 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

  5 years, 6 months 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

  5 years, 6 months 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

  5 years, 6 months ago

  By: pietlinden

• need help Parsing XML

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

  koolme_85

  3 replies

  5 years, 6 months 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

  5 years, 6 months 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 years, 6 months 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 years, 6 months 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

  5 years, 6 months ago

  By: Jeffrey Williams

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

  Goalie35

  3 replies

  5 years, 6 months 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

  5 years, 6 months ago

  By: Steve Collins

• 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

  5 years, 6 months 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

  5 years, 6 months ago

  By: LLSQL42

• Table locks while inserting into the table

  Hi , I am facing a deadlock while i am trying to insert data into a table. At the same time we have…

  komal145

  6 replies

  5 years, 7 months ago

  By: Jeff Moden