SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• How to Obtain Call History of a Stored Procedure/UDF

  I know in the past this wasn't possible but maybe that's changed as SQL Server evolved. Is it possi…

  YSLGuru

  5 replies

  2 months, 2 weeks ago

  By: YSLGuru

• Data Joining technique help

  Hey All, I'm wondering if there is a different/better way to join the data from these two tables. P…

  Coffee_&_SQL

  2 replies

  2 months, 3 weeks ago

  By: Coffee_&_SQL

• Calculating Numerator and Denominator

  Good evening, I have a rather peculiar issue while trying to calculate Numerator and Denominator fo…

  Reh23

  2 replies

  2 months, 4 weeks ago

  By: drew.allen

• trying to call powershell from TSQL statement

  Hello, trying to call a powershell file I created, locally on the server, but also, made sure since…

  Siten0308

  8 replies

  3 months ago

  By: Jeff Moden

• Read data from json file

  I am using the following code to read a json file. I can display the keys and coreentitykey info. H…

  don075

  5 replies

  3 months, 1 week ago

  By: Steve Collins

• 2 identical tables reads on Table1 PK is 53394 reads on table2 PK 2246847

  Tables have identical structure but different indexes (except) PK and different stats.    all DTA…

  joe.hellst

  2 replies

  4 months ago

  By: Jeff Moden

• Script is filling Tempdb

  I have query which is filling TEMPDB I need suggestion how to modify this query to which can minimi…

  Nita Reddy

  3 replies

  4 months, 2 weeks ago

  By: Jonathan AC Roberts

• Trigger After Update to Update the Updated Table

  Okay I can easily see how to update a table field after an Insert but do I use the system Inserted …

  Dennis Jensen

  4 replies

  4 months, 2 weeks ago

  By: ScottPletcher

• Table Delete

  I have a very large table and I'm looking to do a cleanup based upon a non-keyed field. This table …

  Bruin

  21 replies

  4 months, 2 weeks ago

  By: Jeff Moden

• identify consecutive records greater than 1

  Hello I need help identifying all records that have consecutive hours (time in order) of greater th…

  HeftSteady

  5 replies

  4 months, 3 weeks ago

  By: Steve Collins

• Group Delete

  I have 2 tables which I need to cleanup old costkeys, based upon a driver table. The driver table i…

  Bruin

  5 replies

  4 months, 3 weeks ago

  By: Jonathan AC Roberts

• Import data from json file with special characters

  I am using the following script to import data from a json file. This file contains special charact…

  don075

  4 replies

  5 months ago

  By: don075

• Counting values with hysteresis in Report Builder

  Hi, I have a set of data (for instance sine wave) and I need to count, how many times have value re…

  UltraFan47

  2 replies

  5 months, 1 week ago

  By: UltraFan47

• Upgrading SSIS and SSRS from SQL Server 2016

  Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016, but do not have idea for the tar…

  Deni Kusdeni

  1 replies

  5 months, 1 week ago

  By: Deni Kusdeni

• SQL server help (converting rows to columns)

  I am using the following sql to convert rows into columns for each pid, intdate. This works fine wh…

  don075

  3 replies

  5 months, 2 weeks ago

  By: Jeff Moden