1,597 reputation
619
bio website
location Ukraine
age
visits member for 2 years, 5 months
seen 2 hours ago

19h
comment What is better? Delete and insert or update?
Any triggers for update on the table?
22h
revised Split in and out for attendance machine system
improved formatting, spelling, punctuation
22h
suggested suggested edit on Split in and out for attendance machine system
1d
awarded  Revival
1d
answered Strange behaviours with SET options in SSMS
1d
answered Derive daily delta from total daily counts? Tsql
Jul
25
comment How do I place leading zeros for numbers less than 10 without affecting those 10+?
Agree with @ypercube. You could change the first comparison to MyColumn < 10 but that might break as we don't know if MyColumn is guaranteed to ever contain only numbers.
Jul
25
comment SQL Server - constraint to prevent overlapping dates
In response to the earlier comment of yours where you are giving an example of INSERT that doesn't work, that INSERT doesn't populate a PreviousFinished value, which it must according to the method in the linked answer.
Jul
25
comment SQL Server - constraint to prevent overlapping dates
Or perhaps you are struggling to understand how the method in the answer to the linked question works?
Jul
25
comment SQL Server - constraint to prevent overlapping dates
Regarding your update, I don't really understand the actual problem you are facing. Is this about your table already having ranges that overlap and you wanting to detect and resolve them?
Jul
23
comment SQL Server - constraint to prevent overlapping dates
That's great news, people will come here and immediately see that this question already has an answer. :)
Jul
23
comment What is the correct way to ensure unique entries in a temporal database design?
How would you go about splitting an existing (closed) range into two with this restriction implemented? Doesn't seem possible to me, but I might be missing something. (However, it certainly seems possible with the other variation, the one that allows gaps.)
Jul
23
comment How do I include nulls during comparisons in SQL Server?
CASE value WHEN 26 THEN 1 ELSE 0 END = 0. Beautiful, ever so intuitive and by all means sanest of ways.</sarcasm>
Jul
14
comment Getting unique names when the IDs are different (DISTINCT ?)
+1, although deriving a table appears to be perfectly unnecessary.
Jul
9
revised How do I go about easy table input without creating an application?
minor rephrasings to avoid possible ambiguity
Jul
8
answered How do I go about easy table input without creating an application?
Jun
18
comment SQL2542N - No match for a database image file was found based on the source database alias
Does it matter that you are running the command from the /data/home/db2inst1 directory while the file you say is located in /home/db2inst1?
Jun
18
comment T-SQL Calculate average value for Duration Field
Strangely, thanks to you I've just discovered that DATEDIFF(SECOND, '00:00:00', Duration) is actually slower than your original suggestion, but replacing the '00:00:00' (a string) with a 0 (an integer) did make it faster (than your method). Don't know why we've got different conclusions. (If this matters, I didn't use a table in my tests, because I only wanted to test the expressions, so I assigned same expression to a variable in a loop and measured the time.)
Jun
18
awarded  Altruist
Jun
18
comment T-SQL Calculate average value for Duration Field
You could just get the difference in seconds between '00:00:00' and Duration instead of all the string manipulations.