SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Parameters hard coded Views

  One SQL Server has both databases Databases  DB1_QA   and   DB1_TEST Database   RP  has a view vw3 …

  TRACEY-320982

  4 replies

  6 years, 5 months ago

  By: ScottPletcher

• Creating a Group Total with group totals along side

  Hi there   I have a set of three tables that i wish to report group totals on However I am hav…

  Weegee2017

  2 replies

  6 years, 5 months ago

  By: Weegee2017

• JsonPath Array

  Hi, i read a JSON-File into a var. SELECT @json = BulkColumn FROM OPENROWSET(BULK 'C:\Tmp\MyJson.j…

  info 58414

  1 replies

  6 years, 5 months ago

  By: info 58414

• Returning data from a stored procedure using Amazon RDS

  Hi - I'm new to this community and an SQL novice. I am trying to call a stored procedure and t…

  andy.apollocentral

  3 replies

  6 years, 5 months ago

  By: Patti Johnson

• Retry logic for deadlock in while loop

  Hi DBAs, I have a procedure to perform certain operations (insert and update in a table) in while l…

  sqlenthu 89358

  2 replies

  6 years, 5 months ago

  By: DesNorton

• Stored Procedures

  Hi, I created a stored procedure that creates a temporary table, fills it with data, and runs a sel…

  TJ_T

  13 replies

  6 years, 5 months ago

  By: Jonathan AC Roberts

• What's the Best Way to Pass Table Driven Sensitive Info in SSIS?

  Hi, I have a requirement to loop through several SFTP sites, grab files, and then perform various a…

  chris.o.smith

  1 replies

  6 years, 5 months ago

  By: chris.o.smith

• Count of entries & grouped by month - extracted from a date

  hiya amazing people I need some help with the query below. I need to see the breakdown of entries b…

  sqlguru1day

  9 replies

  6 years, 5 months ago

  By: jcelko212 32090

• Database with thousand of tables and no foreign keys.

  Hi, I have a database with thousands of tables. I wanted to see the relationship between tables and…

  Gamleur84

  14 replies

  6 years, 5 months ago

  By: Jeff Moden

• How to define a table valued function to accept tables and columns as parameters

  Hi all, I am currently extracting a lot of bi-temporal versioned tables from a core DWH at a given …

  svenflock

  6 replies

  6 years, 5 months ago

  By: ScottPletcher

• What's the best way to write this query?

  I have a table of rules for orders.  The rules table determines several things but in this example,…

  Goalie35

  5 replies

  6 years, 5 months ago

  By: Goalie35

• INSERT SELECT uses only 1 CPU core with TABLOCK option - how to optimize?

  Hi all, I am currently into ETL scripts performance tuning. What I do is, that I try to optimize lo…

  svenflock

  1 replies

  6 years, 5 months ago

  By: svenflock

• Using T-SQL to cross-check lookup lists in XML format (Second attempt)

  Hello experts, First - apologies if this post appears twice. I tried to the edit the SQL code sampl…

  webrunner

  3 replies

  6 years, 5 months ago

  By: webrunner

• Dynamic SQL and parameters

  Hi all   I've got a stored procedure that runs on a schedule. It generates some dynamic SQL ba…

  richardmgreen1

  8 replies

  6 years, 5 months ago

  By: kherald69

• Is there any way to catch/handle an error from a remote procedure call?

  For example if i run this: BEGIN TRY EXEC msdb.dbo.sp_help_job @job_name = 'foobar',@job_aspect = '…

  TangoVictor

  3 replies

  6 years, 5 months ago

  By: TangoVictor