SQL Beginner: one to many relationship, updating single row based on many rows in join table

Hello, I'm fairly new to SQL and seem to be struggling with the concept of "one to many". I'll use …

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…

IN-Memory tables

Hello All!I would like to know what is the the pros & cons of In-Memory tables in SQL Server 20…

String Search

STORED PROCEDURE

Hi following is my stored procedure, its will help me calculate went a particular staff is due for …

I have to get a count of orders placed between 1 pm yesterday and 1 pm today by day

The table looks like thisOrderNo, OrderDate908, 1/3/2018 13:20:34909, 1/3/2018 15:18:41910, 1/4/201…

Hard to get CU's behind the most recent

We're looking to update our SQL 2014 SP1 instance to SQL 2014 SP2 CU8. I guess I'm thinking that th…

Transactional replication keeps applying snapshot

Hi, I created a new snapshot and applied it.  It ran the scripts to truncate all the tables an…

Spam Topics

Spam seems to be deleted fairly promptly these days, not sure if this is automatic or by manual int…

Wrong regional settings (decimal point)

I'm not sure how this happened, but I'm no longer able to use a decimal point on SSMS. Instead, I n…

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 😉 …

HTTP command

Hi All, I need to run an http from an SQL procedure (for example http://woodwell.gr/uploads/re…

Deleted

Deleted.

100+ Queues/Jobs calling one Procedure

Hi Experts, i have created 100+ Jobs which is calling one procedure which is effecting the speed, a…

Is My Foreign Key Table Unnecessary?

I'm sure this has been addressed many times here but none of the search terms I've tried have surfa…