SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Insert (x) rows into table with y columns from string

  First I want to thank anyone who takes a moment to help with this.  I really appreciate all the hel…

  Budd

  8 replies

  11 months, 1 week ago

  By: Budd

• How to get total sum across the table and sum grouped by date ranges

  Here is sample code and what I tried to achieve, but not getting the output, any advice? select k.c…

  SSCNewbee

  7 replies

  11 months, 2 weeks ago

  By: SSCNewbee

• the workaround for procs truncating varchar and nvarchar max output fields

  Hi , assuming the answer at https://stackoverflow.com/questions/50474892/return-strings-from-sql-se…

  stan

  2 replies

  11 months, 2 weeks ago

  By: stan

• Multiple deadlocks occurring with contentious code

  We are seeing multiple frequent deadlocks occurring with the following extract of code, which forms…

  zoggling

  7 replies

  11 months, 2 weeks ago

  By: Jeffrey Williams

• Order By on a single table raises Ambiguous column name error

  How in the world can the below query for a singular table produce the error msg "Ambiguous column n…

  YSLGuru

  2 replies

  11 months, 2 weeks ago

  By: Dennis Jensen

• SQL Plan Guide usage

  Is it possible to see how many times a SQL plan guide has been used?

  Jackie Lowery

  2 replies

  11 months, 3 weeks ago

  By: Jackie Lowery

• How To Work-A-Round Not being able too use CASE within ORDER BY

  How To Work-A-Round Not being able too use CASE within ORDER BY with differing data types GOAL: To …

  YSLGuru

  9 replies

  11 months, 3 weeks ago

  By: Jeff Moden

• Help with pivot table query with a where clause

  I have a table which contains the ID, AVALUE, TYPE,NUMBER1 and NUMBER2 TYPE is either A or B I want…

  system243trd

  2 replies

  11 months, 3 weeks ago

  By: ScottPletcher

• Filtering Extended Events by Start Time

  Hi, I'm setting up an Extended Event session to capture activity that's occurring overnight but I c…

  giles.clapham

  6 replies

  11 months, 3 weeks ago

  By: giles.clapham

• Transferring millions of records in live production

  Hi we have req of transferring huge data from live table to another table in production env. Live t…

  saum70

  9 replies

  11 months, 3 weeks ago

  By: Emperor100

• Flexable/Effective means to join the Nth record

  I have no doubt this has been covered many times and has many answers but I'm hoping by now this ha…

  YSLGuru

  12 replies

  12 months ago

  By: Jeffrey Williams

• Parse Double Quoted comma separated data with comma

  I've used this function before and I'm sorry I do not recall it's origination.  (DelimitedSplit8K) …

  drbob

  16 replies

  1 year ago

  By: Steve Collins

• Script to Merger duplicate indexes

  Hello, I am trying to firgure out how to merge duplicate indexes using a script; any help will be g…

  EM2

  25 replies

  1 year ago

  By: EM2

• select string removing two sets of characters

  Hi  , I need help replacing a certain strings from a query response. My searches are pointing to a …

  HeftSteady

  6 replies

  1 year, 1 month ago

  By: Phil Parkin

• View generating different plan

  Hello   I have a view based upon a number of tables I'm selecting the same data from this view…

  DamianC

  8 replies

  1 year, 1 month ago

  By: Jonathan AC Roberts