SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Permissions required to access network share when executing R code via sp_execute_external_script

  Hi there We are using SQL Server 2016 with R Services (In Database) and are having issues trying to…

  doodlingdba

  4 replies

  7 years, 8 months ago

  By: doodlingdba

• Have most occurrence column in result set

  I have result set with 4 columns. for example my column names Routername,a,b,c in result set. …

  sathyab18

  3 replies

  7 years, 8 months ago

  By: pietlinden

• Index rebuild - fail scenario

  Hi,For Index Rebuilds, I only find articles about how to do, which I know. What I would like to kno…

  nanonerd

  9 replies

  7 years, 8 months ago

  By: subramaniam.chandrasekar

• Remove article from replication with script

  I have multiple tables with the same name but different schemas. I want to script out the drop of o…

  Fiona.Preedy

  8 replies

  7 years, 8 months ago

  By: Sue_H

• Dynamic SQL - Maintain Column Order

  Hi folks, I'm importing AWS data (json files) into SQL.  Each file contains data on one single…

  Y.B.

  3 replies

  7 years, 8 months ago

  By: Lynn Pettis

• Result truncation bug

  Here's an interesting riddle.  I'm building a code generator, so the SELECT clause is just one…

  Mike Hotek

  18 replies

  7 years, 8 months ago

  By: Jacob Wilkins

• Remove duplicate record based on criteria

  Hi All, EDIT: I was convinced I was connecting to a 2016 instance but just now found out it's …

  micang

  8 replies

  7 years, 8 months ago

  By: jcelko212 32090

• how to do Intermediate calculations for partial rows based on a particular field

  I have a data table which has RowNo, EntityName, Value, KeyYear. RowNo is Unique.  EntityName …

  Naidu PK

  6 replies

  7 years, 8 months ago

  By: Naidu PK

• OR in JOIN criteria

  Apologies if this has been asked before, searching for it yields too many results. I've been elimin…

  r5d4

  11 replies

  7 years, 8 months ago

  By: Matt Miller (4)

• Count numbers per month with increasing value

  Hi. I have a table with date and a increasing value.There is not allways one reading per month…

  bjorn.gabrielsson

  4 replies

  7 years, 8 months ago

  By: bjorn.gabrielsson

• Help me in update - complex

  hi All,    Hope all are fine create table #sample(id varchar(100), version_no int, set_ty…

  JoNTSQLSrv

  14 replies

  7 years, 8 months ago

  By: JoNTSQLSrv

• problem with INSERT TRIGGER

  Hello comunity,I build  this Trigger  to  insert into table mytab  2 keys for u…

  luissantos

  1 replies

  7 years, 8 months ago

  By: Evgeny Garaev

• Is it possible to create a unioned view where inserts go into only one of the tables

  I would like to join 2 tables in a view, but be able to insert into said view and have the record o…

  Clint-525719

  3 replies

  7 years, 8 months ago

  By: RAThor

• how to get all values from one table repeated to each group on a column in another table

  Updated Query tables: I have a table called DisplayFields and another one called tax. Displayfields…

  Naidu PK

  10 replies

  7 years, 8 months ago

  By: Naidu PK

• Importing Multiple Excel Files using TSQL

  Hi Folks, So, here is my goal this time:  To import multiple Excel files into a database using…

  kevaburg

  10 replies

  7 years, 8 months ago

  By: kevaburg