SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• SSIS package execution error due to 'untrusted domain'

  Hello experts, Could someone point me to some ideas about troubleshooting this error that I am gett…

  webrunner

  4 replies

  5 hours, 15 minutes ago

  By: webrunner

• Temporal Table Reporting

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

  Leighton21

  6 replies

  2 days, 2 hours 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

  2 days, 6 hours 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

  1 week 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

  1 week 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

  1 week 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

  1 week, 4 days 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

  1 week, 6 days ago

  By: jcelko212 32090

• SSMS v.18 slow? Is it me or....?

  Hello, Does anyone find SSMS v.18 client to have a very slow start? ~30sec. to load and prompt for …

  datsun

  8 replies

  1 week, 6 days ago

  By: dmadden51

• 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

  1 week, 6 days 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

  1 week, 6 days 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…

  spider007

  1 replies

  1 week, 6 days 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

  2 weeks 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

  2 weeks, 1 day 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

  2 weeks, 2 days ago

  By: pietlinden