Search Results
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 sql-server
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 …
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 …
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 …