SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Indexing in a Merge Replication environment

  Hello SQL Gurus I am new to Database design.  We are building an application that is expected to ha…

  pssudarshan

  1 replies

  5 years, 2 months ago

  By: pssudarshan

• Help needed in checking dates spans and status

  Hello All, I have a requirement where we need to merge spans if the status is same for continues sp…

  dhanekulakalyan

  1 replies

  5 years, 2 months ago

  By: Steve Collins

• Temporal Table Reporting

  Hi All, I have inherited a database which has a number of system versioned (temporal tables). One o…

  Leighton21

  6 replies

  5 years, 2 months ago

  By: Jeff Moden

• Same Query to run in different DB.

  Hi, How to execute single query on different databases when one of the column missing in one databa…

  Sangeeth Raj

  3 replies

  5 years, 2 months ago

  By: Jeff Moden

• RunRate , Forecast using Recursive CTE or UNION ALL

  I would be grateful if you can help me to calculate the RunRate(forecast) on the following table . …

  imfarhan

  2 replies

  5 years, 2 months ago

  By: Mr. Brian Gale

• Create a customer calendar from its history

  Hello, I would like to create a calendar from a history table for a customer, so that I can read th…

  olaf.renk

  5 replies

  5 years, 2 months ago

  By: Steve Jones - SSC Editor

• Sub Query - return only all orders ready to pick

  I have a table with some data, Having hard time returning values based upon two conditions. Create …

  Bron Tamulis

  6 replies

  5 years, 2 months ago

  By: operosewa

• Storing VARCHAR(MAX) off-row

  Hi all   We've got some fairly lengthy pieces of (free)text we need to store for reporting pur…

  richardmgreen1

  30 replies

  5 years, 2 months ago

  By: Jeffrey Williams

• Help with T-SQL

  I have a web interface for managing tool rentals for our chapter members. I have a display page tha…

  netguykb

  2 replies

  5 years, 2 months ago

  By: jcelko212 32090

• Help in Date spans for continuoes and regular dates spans

  Hello all, I would like to take input scripts and generate output data as given below. output is ex…

  dhanekulakalyan

  13 replies

  5 years, 2 months ago

  By: jcelko212 32090

• User-Defined Function; syntax problem

  ALTER FUNCTION [dbo].[Max1] (@Dem Dec(18,6), @UnitCost1 Dec(18,6), @AnnCost1 Dec(18,6), @EBQ1 Dec(1…

  saintor1

  2 replies

  5 years, 2 months ago

  By: frederico_fonseca

• Large table query performance

  Hi all, in my datawarehouse i have large table with about 2.5B of rows. Table is partitioned by dat…

  nickname

  1 replies

  5 years, 2 months ago

  By: BrainDonor

• Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

  Is it reasonable to roll-up ALL metrics from Query Store to measure 'everything'? and then compare …

  VoldemarG

  24 replies

  5 years, 2 months ago

  By: Jeff Moden

• SQL bulk insert unique rows from a parent table to multiple child tables

  I have a table Locations whose schema is below. I want to select all unique rows from the Home tabl…

  marcus

  3 replies

  5 years, 2 months ago

  By: Phil Parkin

• Get current and previous week sales

  Hi, I have a FactBooking (BookingDateKey, Amount, Qnt) and a dimension DimDate(DateKey,Year,Month,W…

  Rocky's

  1 replies

  5 years, 2 months ago

  By: pietlinden