10,685 reputation
23163
bio website
location Connecticut
age
visits member for 3 years, 3 months
seen 37 mins ago

I'm a dude.


Aug
25
comment SQL select top X rows having sum limit
You could do this pretty easily with a recursive CTE...But honestly for running totals (which this is) a cursor is probably the best-performing solution.
Aug
21
comment How to back out of mass update in SQL Replication
I just went through this a few weeks ago with transactional replication. The solution is to reinitialize, unfortunately.
Aug
19
answered What is better? Delete and insert or update?
Aug
19
comment What is better? Delete and insert or update?
The performance difference could well be in how you are performing the DML statement. Is this running in a loop by any chance?
Aug
18
comment How do I ORDER BY typical software release versions like X.Y.Z?
This is confirmed by your fiddle...
Aug
18
comment How do I ORDER BY typical software release versions like X.Y.Z?
Do you need to convert these to numbers? Otherwise I would expect 10 to be between 1 and 2.
Aug
11
awarded  Popular Question
Aug
5
comment can we transfer sql database backup from one server to another server directly?
You need to take a backup, unless the database is readonly in which case you can copy the files directly.
Aug
4
comment How to write a query which finds all circular references when a table references itself? (II)
Wouldn't 7 still slip by?
Aug
1
awarded  Notable Question
Jul
28
answered Conditionally join table
Jul
28
revised Case always returns null?
deleted 89 characters in body
Jul
28
comment Case always returns null?
Sorry I missed the column name changes in all that code :) Output the raw dates in a select to see what you get.
Jul
28
comment Case always returns null?
@KidCode That still doesn't cover the possibility of the dates being EQUAL, which is what is happening. Both your date columns use the same calc so they will have the same value.
Jul
28
answered Case always returns null?
Jul
25
comment High Service Broker queue
This really sounds like it may be an issue with how the messages are being handled. Are you sure conversations are being closed?
Jul
24
reviewed Approve suggested edit on How do I place leading zeros for numbers less than 10 without affecting those 10+?
Jul
24
comment How do I place leading zeros for numbers less than 10 without affecting those 10+?
Try the new version...
Jul
24
revised How do I place leading zeros for numbers less than 10 without affecting those 10+?
added 23 characters in body
Jul
24
revised How do I place leading zeros for numbers less than 10 without affecting those 10+?
added 126 characters in body