SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Dictionary Lookup

  Hi I have hundred million ID, NAME pairs stored in SQL Server as a table that is accessed by C# cod…

  etl2016

  4 replies

  4 years ago

  By: Chris Wooding

• Datediff (exclude holidays - no function)

  I'm counting the days between two dates using DateDiff.  In my query I'm excluding weekends, now, I…

  clouddeveloper

  2 replies

  4 years ago

  By: jcelko212 32090

• Finding number of SELECT statements pr. tabel/view with Query Store

  Hi guys. I have a question regarding Query Store. I want to check how much each table is used in my…

  gaggelak

  4 replies

  4 years ago

  By: gaggelak

• SQL - SUBSTRING combined with CHARINDEX not returning desired results.

  Hello Friends, I'm in need of some help here please. I'm trying to extract a certain part of a stri…

  DiabloSlayer

  8 replies

  4 years ago

  By: ScottPletcher

• Update query based on join

  Hi, I have 2 tables: 1 storing the amount at Quarter level: Quarter | Amount 2020 Q1| 100 --a 2020 …

  kirti

  2 replies

  4 years ago

  By: bradley84

• Create a delta from downloaded info

  I'm looking for some suggestions on how to create a delta file that will some me differences from y…

  Bruin

  44 replies

  4 years ago

  By: Bruin

• Not getting expected index seek.

  Here is the query and the indexes.  I can't figure out for the life of me why I'm not getting an in…

  Jackie Lowery

  15 replies

  4 years ago

  By: Jonathan AC Roberts

• Stored Procedure returning different results from the query run seperately

  Hi all, We've got a stored procedure with a single date parameter. When I run the query inside the …

  craig.bobchin

  3 replies

  4 years ago

  By: ratbak

• Trying to understand parentheses placements

  Hi all, for a long time I've struggled with code that had multiple consecutive right parentheses, a…

  JaybeeSQL

  4 replies

  4 years ago

  By: Jeff Moden

• Calendar report for SQL Agent Jobs - what GUI do you recommend?

  Looking to create  a Calendar report for SQL Agent Jobs, to display the future (1 week, e.g.) and p…

  VoldemarG

  4 replies

  4 years ago

  By: Jeff Moden

• T-SQL to find id waiting each hour

  Hello Need to write sql to find datetime between start_Dt and end_Dt so that ID can be counted at e…

  leo_dec

  2 replies

  4 years ago

  By: Steve Collins

• Azure Data Studio doesn't yield any results when I run it

  Recently I've noticed that Azure Data Studio (ADS) doesn't produce any results when I run it. I'm w…

  Rod at work

  7 replies

  4 years ago

  By: Rod at work

• help with SQL script

  Hello Need help with sql script . sample data below with result expected in #data_result table. I t…

  leo_dec

  4 replies

  4 years ago

  By: Steve Collins

• Unexpected Results from Row Level Security (RLS)

  Here is the use case. We have a table (ctrl_parms) to contain application control parameters. We wa…

  berean1224

  1 replies

  4 years ago

  By: berean1224

• Dynamic column selection for alerting rather updating

  I have two Tables SourceEmployee and TargetEmployee both same column names except the targetemploye…

  asita

  1 replies

  4 years ago

  By: asita