SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Issue with max() and aggregate, missunderstanding

  Hi all, this is my first post here and I've been looking and trying to understand this for hours th…

  insomnius

  19 replies

  6 years ago

  By: ScottPletcher

• Employee hierarchy with expense

  Please help me to get the below output from table  

  celestine

  6 replies

  6 years ago

  By: jcelko212 32090

• Indirect reference to variable

  TL:DR; I have a bunch of repetitive code (error checking, raiseerror) in a stored procedure I'm wri…

  Scott In Sydney

  7 replies

  6 years ago

  By: Steve Collins

• Merge Columns when Column in Master-/PK-Row is NULL

  Hi, I have a master row where OrderType is NOT NULL (Bold Row) Problem: When on column in MasterRow…

  info 58414

  3 replies

  6 years ago

  By: David Burrows

• Return Rows Only When a Ticket Status is the latest One

  I am looking for a query that only returns rows where the latest ticket status is Awaiting Response…

  gs1975

  4 replies

  6 years ago

  By: gs1975

• Using log4net in a dll which is called via CLR function

  Hello I am refactoring older code which is part of an SQL Server CLR Function call. The code has a …

  swissmawi

  4 replies

  6 years ago

  By: Steve Jones - SSC Editor

• Convert number to time

  How to convert number to time I have set of numbers in row and want to convert into time. Currently…

  Shaun2012

  3 replies

  6 years ago

  By: David Burrows

• JSON_VALUE in WHERE-clause results in error

  Strange behaviour in my opinion, or did I miss something in documentation? Can anyone explain this …

  marc.snoeys

  7 replies

  6 years ago

  By: marc.snoeys

• configure extended event for deadlock

  Hi All, I want to capture deadlock information and associated batch and tsql stmts . I was able to …

  vsamantha35

  10 replies

  6 years ago

  By: vsamantha35

• Dynamically concatenate string

  I have a below sample t-sql, i am trying to dynamically concatenate the rows, the number of rows ca…

  curious_sqldba

  2 replies

  6 years ago

  By: Jeff Moden

• Move data file

  Hi, I need to move data file from 1 drive to another drive under the same server , I am using SQL 2…

  WhiteLotus

  1 replies

  6 years ago

  By: as_1234

• More performant way to write this where clause

  Ahoi, i have the following where clause which was created by my predecessor and i wonder if there w…

  ktflash

  12 replies

  6 years ago

  By: Matt Miller (4)

• deadlock issue

  Hi Experts, We are seeing repeated deadlocks on one of our prod servers. Can anyone please tell me …

  vsamantha35

  14 replies

  6 years ago

  By: vsamantha35

• using trigger for tracing

  Is it possible to create a trigger on a table for a specific column that will log the user who modi…

  Jackie Lowery

  10 replies

  6 years ago

  By: Jeff Moden

• sp_executesql with multiple parameters

  I'm trying to write a stored procedure that will select the entire table if all parameters are null…

  Scott In Sydney

  9 replies

  6 years ago

  By: DesNorton