Reputation
3,037
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
12 30
Newest
 Custodian
Impact
~118k people reached

Aug
27
comment Cannot open SQL Server profiler file
This is not about importing a trace file really, this is about accessing it in Transact-SQL (particularly, using the sys.fn_trace_gettable function).
Aug
27
awarded  Custodian
Aug
27
reviewed Close How to update multiple tables in MS Access from multiple excel files?
Aug
26
comment What collation to use for Ukraine?
I don't think the number of locales a collation applies to should determine your decision. It is true that the difference between the two collations in question seems minor, but it is there nevertheless. It all depends on the target audience, I think. Perhaps the OP's Ukrainian mate is bi-lingual (Russian/Ukrainian), as many are in Ukraine, as I am, in fact. That doesn't mean the established sorting rules should be ignored. Just saying.
Aug
26
revised How to create a relatively complex MySQL query
more formatting improvement and typo fixing
Aug
26
reviewed Approve How to create a relatively complex MySQL query
Aug
25
revised Computed Column Update when Table Value changes
formatting
Aug
25
revised Case When over 2 columns return results into 1 output column
added a missing word
Aug
25
reviewed Reject and Edit SQL Server 2000 on Windows 10
Aug
25
revised SQL Server 2000 on Windows 10
added 6 characters in body; edited tags; edited title
Aug
25
revised DELETE from Linked Server table using OPENQUERY and dynamic criteria
deleted 26 characters in body
Aug
25
comment Remove duplicates from multiple joins
You've likely oversimplified your query, because there's no way you could get that result with that set of join conditions. If you have 3 appointments and 2 payments for the specified customer, your query should return 3×2=6 rows for you. As your question is about the incorrect results, you should make your example more accurate. If posting the actual query is impossible, consider at least making your current result reproducible based on some data samples. My guess is you are missing a condition that links a specific appointment to a specific payment.
Aug
25
revised Remove duplicates from multiple joins
added 14 characters in body; edited title
Aug
25
revised How to apply two different where conditions for two different tables in same select statement
changed to (more) Teradata-compliant syntax
Aug
24
comment Calculate column running total
The manual isn't perfectly explicit about that (I've looked here and here), but yes, it is you say, an ORDER BY without a frame specified implies the frame to be BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.
Aug
24
answered Using Left or substring with wildcard in SQL
Aug
23
reviewed Reviewed Networking (classmate like) website database model
Aug
23
revised Networking (classmate like) website database model
grammar
Aug
23
reviewed Reviewed Which command Deletes and Frees Space
Aug
23
revised Which command Deletes and Frees Space
added 1 character in body