SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Get data into a table

  Hi I have two tables create table Students (StudentID int not null , Name nvarchar(20)) insert into…

  SQL-Learner

  5 replies

  9 years, 4 months ago

  By: SQL-Learner

• JSON from within a table

  Hi there, I can successfully parse JSON from a file based on some examples that are out there.…

  DaveJenkins

  5 replies

  9 years, 4 months ago

  By: DaveJenkins

• SSIS connection string environment variable problem

  I've got an SSIS project that uses an environment variable for it's connection string. This is the …

  Robert Frasca

  9 replies

  9 years, 4 months ago

  By: sha4lo

• SQL71502 Error in SSDT when referencing STRING_SPLIT function.

  High all, I am getting the following warning in SSDT: "SQL71502: Procedure: [Execution].[MyStoredPr…

  RedLlewy

  9 replies

  9 years, 4 months ago

  By: DesNorton

• retrieving global variable for trigger

  Hello, I'm dealing with a database problem and I would like to know how to solve it. The problem is…

  junk.mail291276

  10 replies

  9 years, 4 months ago

  By: junk.mail291276

• merging multiple Exists

  Hi I have the following query  with multiple exists run against the same table. Can I merger a…

  sql_2005_fan

  6 replies

  9 years, 4 months ago

  By: ChrisM@Work

• Indexes

  If I have a column where the leading column is defined in an Index do I need a separate index with …

  Welsh Corgi

  11 replies

  9 years, 4 months ago

  By: John Mitchell-245523

• GETTING ERROR ON THE OUTPUT

  My Source has 2 tables and i need to get all the data based on component wise like hierachical data…

  skmoh2

  7 replies

  9 years, 4 months ago

  By: Thom A

• Consuming JSON with OPENJSON

  This question is really a question on the format of the raw JASON as retrieved from the service pro…

  michael.french 172

  2 replies

  9 years, 5 months ago

  By: michael.french 172

• Merge tables from multiple instances to one central warehouse table?

  Hi, I have one db per instance with information/logging data for the whole instance. How shoul…

  magnus.tengmo

  2 replies

  9 years, 5 months ago

  By: Matt Simmons

• Bring data from one server to another server

  Hi,  I have a few tables in one server which contains huge amount of data lets say 50 million …

  SQL-Learner

  5 replies

  9 years, 5 months ago

  By: Matt Simmons

• A way to avoid repeating case statement

  Hello, Is there a way to avoid repeating a case statement. If the first is true, there is an amount…

  lulu_lutz

  1 replies

  9 years, 5 months ago

  By: lulu_lutz

• Restore script for split backup files

  Hi, Does anyone have a script handy that'll identify the most recent full backups within a director…

  A3Paper

  2 replies

  9 years, 5 months ago

  By: A3Paper

• Adding an item count as another column to a function

  Hi, I have the following code below, which is using a tally table, to split out a text string into …

  kyagi.jo

  2 replies

  9 years, 5 months ago

  By: kyagi.jo

• Prevent Mass Updates With RowCount 1

  I have a mission critical table which at times unfortunately does need a manual update to key value…

  mary.clemons 79057

  3 replies

  9 years, 5 months ago

  By: Eric M Russell