SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• SQL Table Issue

  Hi everyone, In below code I am creating a table and inserting some english and non-english text in…

  Jobs90312

  12 replies

  1 year, 11 months ago

  By: Thom A

• Read # of trace files

  I have a SQL agent job which starts the trace (for audit purpose) everyday at 7 am and it stops at …

  Chitown

  2 replies

  1 year, 11 months ago

  By: Chitown

• TEMPDB Version Store Growth when READ_COMMITTED_SNAPSHOT IS OFF

  Why would the version store be growing for a database where READ_COMMITTED_SNAPSHOT is OFF? SELECT…

  dpaproskijr

  8 replies

  1 year, 11 months ago

  By: Johan Bijnens

• Help with Joins

  Hi there, I'm new to T-SQL and am struggling with the join concept in practice. I'd like to join th…

  gwb

  4 replies

  1 year, 11 months ago

  By: gwb

• Parsing Stored Procedures for Table Dependencies

  Hi all, Truly not a developer here. Just a reporting analyst on a team with a bunch of untrained us…

  LukeTemp1

  8 replies

  1 year, 12 months ago

  By: ScottPletcher

• SSIS call from a client PC with no SSDT/SQL

  Hello, I have written a SSIS package on the server which on processing data outputs a CSV file to a…

  datsun

  14 replies

  1 year, 12 months ago

  By: Phil Parkin

• average of percentage

  Hello, I am looking to get average of percentages (to be calculated in same query).   create t…

  sqlenthu 89358

  11 replies

  1 year, 12 months ago

  By: MarkP

• Invoke a Tableau dataset refresh from a SQL Agent Job

  Hello, we have a nightly SQL Agent Job that refreshes our database on SQL Server 2016 Server. We al…

  dndaughtery

  3 replies

  1 year, 12 months ago

  By: MarkP

• Return 80 % match

  I have data with a column (VenSN) that stores Y, N, Null, (N with serial number ie 'N 23423545'). …

  GrassHopper

  2 replies

  2 years ago

  By: GrassHopper

• Use table from another SQL 2016 instance

  Hi,I have two SQL 2016 Enterprize instances, payroll and PP (Production planning); currently, I hav…

  vsivakumar.in

  4 replies

  2 years ago

  By: Eirikur Eiriksson

• Split One Column into Multiple that uses / as the delimiter

  I've been researching this for over 3 hours and none of the syntax I've found works.  I have a col…

  Luv SQL

  7 replies

  2 years ago

  By: Jeff Moden

• record loading

  I have a table from a Linked Server that I'm pulling data and would like to know if there is a more…

  Bruin

  55 replies

  2 years ago

  By: Bruin

• Exporting from SQL to XML issue

  Hi everyone, So I have a table which consists of different IDs of a person. Like for example their …

  Jobs90312

  11 replies

  2 years ago

  By: Jo Pattyn

• Where clause filter view before dense rank

  I have a view that has a dense rank function on a cte, sorta like this: drop view if exists drview;…

  Jackie Lowery

  11 replies

  2 years ago

  By: Jeffrey Williams

• Updating a single node in XML from SQL

  I have a xml parameter, i need to update the node <ReceiveDeliveryItem> where the node <Pu…

  lee.hopkins

  2 replies

  2 years ago

  By: Eirikur Eiriksson