SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Row-level security for users belonging to multiple AD groups?

  Hi, I am new to RLS, and I am trying to solve the following problem: We have fact tables that …

  MB-400824

  9 replies

  8 years, 4 months ago

  By: karim.diouf

• The underlying connection was closed withing a CLR calling dll using TLS 1.2

  Good Day all, My preliminary research for the above error leads me to believe that this is an issue…

  be05x5

  1 replies

  8 years, 4 months ago

  By: be05x5

• Split 60 character string every third character with pipes

  Hi All, I'm needing to split a 60 character string every third character with spaces/pipes and filt…

  DataAnalyst011

  17 replies

  8 years, 4 months ago

  By: Lynn Pettis

• FullText Index using type column

  I'm creating a full text index using a type column and have run into an issue with varchar vs nvarc…

  Mike01

  3 replies

  8 years, 4 months ago

  By: Steve Jones - SSC Editor

• Dynamic Database Selection

  So i'm a bit stuck here. I have a pair of database projects that are being deployed that I'm tryin…

  mmorales 85175

  4 replies

  8 years, 4 months ago

  By: mmorales 85175

• Calculating sum of days/weeks

  Hi, I have a calendar table that have the days, I need to add the following columns Days in a month…

  astrid 69000

  15 replies

  8 years, 4 months ago

  By: drew.allen

• Performance issue after migration from SQL Server 2012

  Hello,I'm facing with a strange performance issue on SQL Server 2016 Service Pack 1 CU5 instance af…

  Julien Maillard

  5 replies

  8 years, 4 months ago

  By: Julien Maillard

• Sort comma separated value in SQL Table

  Hi  I want to sort a column value alphabetically which is already in a sql table to something…

  PSB

  23 replies

  8 years, 4 months ago

  By: Jason A. Long

• Trigger insert

  Hi, I have a table that keep track of the store procedures and it log errors. I want to add the nam…

  astrid 69000

  12 replies

  8 years, 4 months ago

  By: TheSQLGuru

• Extract Text around comma and space into other columns

  From another post in this site, I got a working query to give me the text on the left and right sid…

  usererror

  5 replies

  8 years, 4 months ago

  By: usererror

• Throw an Error on a procedure

  Hi, I have a procedure that does MERGE. however I have new changes, please see below, these are som…

  hoseam

  4 replies

  8 years, 4 months ago

  By: Phil Parkin

• Apply targets to each month between two dates

  I have a table in SQL which lists a monthly target for a particular contract (tblTarget). tblTarget…

  dcaulton73

  6 replies

  8 years, 4 months ago

  By: dcaulton73

• Sequential 'Alter Table' queries

  Since my last visit, I've gotten by with just using my "Teach yourself SQL" book and lots of web se…

  usererror

  10 replies

  8 years, 4 months ago

  By: Phil Parkin

• 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

  8 years, 4 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

  8 years, 4 months ago

  By: pietlinden