SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• When updating one row in a table, update trigger creates 3 rows in audit table

  I have a table with one trigger on it. CREATE TRIGGER [dbo].[trgPersonnel] ON [dbo].[Personnel] FOR…

  webskater

  4 replies

  8 years ago

  By: TheSQLGuru

• Use inserted identity field value to link to identity field from source table question.

  Hi all I have a final destination table with identity field that I need to get back and link it to …

  Leo-209864

  6 replies

  8 years ago

  By: Leo-209864

• Using IN and Case When splitting Numeric values

  Hello Comunity and happy new year for all of You. I would like to know how can write this CTE using…

  luissantos

  5 replies

  8 years ago

  By: luissantos

• SQL Agent job - Power shell script error

  I have created a sql agent  job to execute powershell script.this is to stop SSAS service in a…

  itsvenkyyy

  3 replies

  8 years ago

  By: Sue_H

• Insert sets of IDs and Years into a table

  This is probably rather simple, but I'm having a brain stumble today. Any thoughts on a SQL query t…

  chrisjgreen08

  6 replies

  8 years ago

  By: ScottPletcher

• Find a sub string in a column based on values in a reference table

  Good morning,   I am not quite sure how to approach the problem. I have a table for custo…

  fparker 20089

  14 replies

  8 years ago

  By: fparker 20089

• Row inserts for groups of rows (Totals for groups of like data).

  I want to group data like all invoices from a supplier which is easy enough but when selecting mult…

  bswhipp

  27 replies

  8 years ago

  By: Jeff Moden

• Json + SP_execute

  HiI have an issue in troubleshooting below is sample code DECLARE @json NVARCHAR(MAX) = N'{ "…

  yuvipoy

  4 replies

  8 years ago

  By: Evgeny Garaev

• Master database

  I've got a server with 175 databases on it, all (theoretically) identical copies of each other from…

  Robert Frasca

  14 replies

  8 years ago

  By: ScottPletcher

• Join with SQL View taking more time in SQL 2016

  sql server - Join with SQL View taking more time in SQL 2016 - Stack Overflow   &nbs…

  nirav.gandhi7

  8 replies

  8 years ago

  By: yuvipoy

• Adding indexed computed column to vendor system-any negative impacts?

  I have this vendor system I have to work with...it is perhaps the most horrible system ever made 😉 …

  Maxer

  4 replies

  8 years ago

  By: ScottPletcher

• CASE with 'and' condition not working

  sorry for bring such a simple thing to this forum. for some reason the case statement with and…

  cocopuffs

  6 replies

  8 years ago

  By: cocopuffs

• Problem with Tuning of Delete Statement

  Hi all,This is my query.Delete FROM AliTest2.DBO.SDE_GEOMETRY9     WHERE N…

  Hamid-Sadeghian

  34 replies

  8 years ago

  By: Hamid-Sadeghian

• Changing the result set to have the result of all databases instead of just one

  Dear Forum Members, I have the below query that returns some results based on the database that I h…

  river1

  1 replies

  8 years ago

  By: Lynn Pettis

• Views and Collations

  Hi thereIs there a way of changing the collation for a view, and not by individual columns in a vie…

  shindle 17293

  3 replies

  8 years ago

  By: Alan Burstein