Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 2357

All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.

2 votes
Accepted

Find over-payment amount using a three-table join

There is no straight-forward way, just linking these tables, to give the result. The code below gives you the answers, with the bonus that, letting @ColId null, every Client will be processed. You m …
Marcus Vinicius Pompeu's user avatar
1 vote

ERWIN create and use database

You have to edit the Forward Engineering Template (FE Template). Simple said, hard done. As each class of entities (table, views, SPs, etc.) have their own block of generation code, it has to be don …
Marcus Vinicius Pompeu's user avatar
2 votes
Accepted

Trigger/Event that fires when a Transaction finishes

Man, I'm terribly sorry. I'm 'answering' stating that there's no simple solution as the one you devised. You presented us a very interesting challenge. I've been doing research and exercises in the …
Marcus Vinicius Pompeu's user avatar