Given a table
CREATE TABLE TABLE_ITEMS (
serial_num int null,
item_group int null
);
INSERT INTO TABLE_ITEMS
VALUES
(0,1), (1,1), (2,1),(3,1) ,(4,1) ,
(0,2), (1,2), (2,2), (3,2), (4,2), (5,2),
(0,3), (1,3), (2,3);
and so on...
I need to know how to run a query which will upda...
Good morning. I guess it's quiet due to time zones.
:)
I have a question : I've read about the FORCESEEK hint. But why on earth , the optimizer would NOT want to do it by default ? It is better for him and it's better for me.
Microsoft SQL Server supports backing up to remote network locations only by means of UNC names the SQL Server (and user account it's running under) has access to.
Is it possible to create backups and stream them back to a SQL client by means of using the same database connection?
I think you w...
@TomV I think you should post that as an answer. Assuming the question gets reopened (2 votes needed). Don't really understand why it was closed, I must say.
I have a table which contain some information with a Datetime column. I wanted to count how many events were in the past 30 minutes interval — So I did this :
DECLARE @k INT = 30;
WITH cte AS (
SELECT *
FROM Eservices_WebApi_Logs
WHERE DateCreated >= '20150713'
AND DateCreated < GETDATE()
)
SELECT DATEPART(hour, DateCreated) AS H,
(DATEPART(minute, DateCreated) / @k) * @k AS m,
COUNT(*) AS Purchases
FROM cte
GROUP BY
DATEPART(hour, DateCreated),
(DATEPART(minute, DateCreated) / @k)
ORDER BY
DATEPART(hour, DateCreated),
DATEPART(minute, DateCreated) / @k;
If I change the @k to 60 it will yield : how many were per hour :
But what if I want to do it per 2 hours ? now @k is not helping and I need to create a group for 2 hours... How can I do that ?
That means that, say, results for the 8:30-9:00 interval from every day will get combined in your present query. Mikael's solution is what I first thought about, and it is what you should use instead of your approach if it really matches your requirements
Anyone any idea why this happens http://dba.stackexchange.com/questions/106865/get-all-data-from-two-tables-and-group-it-into-different-category-in-mysql?noredirect=1#comment194412_106865 - the CREATE TABLE script also shows \n for every line - strange!
I lost a lot of data in my postgresql database and do not have a dump file to restore backup from, but i heard that in /var/lib/postgresql/9.4/main there are pg_xlog and pg_clog and that those directories could be used to restore previous points in the db. Could some clarify this and how to do it...
We have on the server a database and we want to replicate a database on another server. we've set a transactional replication, but we have issues with the default constraints on the tables:
On the left is schema of the table from a backup from the original server and on the right is the schema...
you take the integer part and add them as days since 1900-01-01, then you take the decimal part and add them as the time. In your example, you should add 42197 days to 1900-01-01, and 0.8680532407 days (which are 20 hours, 49 minutes, 59 seconds and 797 milliseconds)
public static Date convertDoubleToWindowsTime(double comTime) {
long result = 0;
comTime = comTime - 25569D;
Calendar cal = Calendar.getInstance();
result = Math.round(86400000L * comTime)
- cal.get(Calendar.ZONE_OFFSET);
cal.setTime(new Date(result));
result -= cal.get(Calendar.DST_OFFSET);
return cal.getTime();
}
If I use this function then the output is 2 days ahead
@Lamak actuallY i consider it is a bad idea
because to show simply a datetime,from android I have to take double value
Spring, you'd be best served by posting a question on StackOverflow for this. Provide your algorithm and sample source values, expected outcome and actual outcomes. Otherwise, you'd likely have more success in a Java chat room. In our collective mind, I suspect we'd all agree your root issue is the wrong data type was selected for storing this date value.
yes you are right,integer part gives number of days since 1-1-1900,is the decimal part is in miliseconds? As per my calculation,its not in milliseconds Current time is 22 hours and 12 minutes and if you convert it in miliseconds then it gives me 79920360 but convert(floar,getdate()) gives me 9256227238 in decimal part. So can you please tell me what's the logic behind it?
I had to bail early from the call so I don't know for certain what's gotten people's knickers in a bunch. There was, may still be, an email distribution group only for SQL Server folk. It appears they are trying to reduce silos and so created one big mailing group to serve the delivery of MS services but ZOMG, UNSUBSCRIBEXE!
20something emails to go but that's my NDA compliant version
The facilities for this year's SQL Saturday here in Kansas City are bonerific
Yes, the converted casino was cool but this building is brand spanking new and they have spent a redonkulous amount of money on creating an environment for learning.
Given a table
CREATE TABLE TABLE_ITEMS (
serial_num int null,
item_group int null
);
INSERT INTO TABLE_ITEMS
VALUES
(0,1), (1,1), (2,1),(3,1) ,(4,1) ,
(0,2), (1,2), (2,2), (3,2), (4,2), (5,2),
(0,3), (1,3), (2,3);
and so on...
I need to know how to run a query which will upda...
Microsoft SQL Server supports backing up to remote network locations only by means of UNC names the SQL Server (and user account it's running under) has access to.
Is it possible to create backups and stream them back to a SQL client by means of using the same database connection?
I think you w...
We have on the server a database and we want to replicate a database on another server. we've set a transactional replication, but we have issues with the default constraints on the tables:
On the left is schema of the table from a backup from the original server and on the right is the schema...
