Viewing 15 posts - 1,291 through 1,305 (of 3,957 total)
As long as you don't have any duplicates in the MAX date, you can do it this way:
WITH GroupedData AS
(
SELECT DateStarted=MAX(DateStarted), ProductID
FROM...
October 16, 2013 at 6:28 pm
SELECT STUFF(CONVERT(VARCHAR(20),EndDT-StartDT,114),1,2,DATEDIFF(hh,0,EndDT-StartDT))
+1 to Jeff for that! Absolutely brilliant.
October 15, 2013 at 9:13 pm
Sean Lange (10/15/2013)
If you got your quote correct that person is moron.
Well now Sean, there was no reason to hold back because we're all friends here. Why don't...
October 15, 2013 at 9:07 pm
2013-09-30 00:22:05.000
Jeff Moden (10/15/2013)
Look again, please. There is absolutely no way that there are more than 25 hours between 10:05PM one day and 02:04AM the very next day.
Looks like...
October 15, 2013 at 7:15 pm
Similar to Scott's last:
SELECT CAST(DATEDIFF(ms,StartDT, EndDT)/3600000 AS VARCHAR) + ':' +
RIGHT(CAST(CAST(DATEADD(ms, DATEDIFF(ms,StartDT, EndDT)%86400000, 0) AS TIME) AS VARCHAR(12)), 9)
FROM
(
SELECT StartDT='2013-09-30 00:22:05.000', EndDT='2013-10-01...
October 15, 2013 at 6:16 pm
happycat59 (10/15/2013)
The lag clause looks like a nice way to achieve this - I didn't know that it existed until just now.Dwain - Thanks for teaching me something new 🙂
Technically...
October 15, 2013 at 5:44 am
S_Kumar_S (10/14/2013)
Perfect..perfect..
Really? I would have thought from your expected results you'd want something more like this:
SELECT TOP 12 DATEPART(mm, OrderDate) AS MonthNum, AVG(orderCount) AS AvgOrderCount
FROM OrderTest
GROUP BY DATEPART(mm, OrderDate),...
October 14, 2013 at 11:45 pm
You're not particularly clear about the relationships between each table so this is just a shot in the dark.
DECLARE @TranID BIGINT = '1234';
SELECT DISTINCT c.EID, c.SourceID, c.SourceType, c.Description
FROM #LD a
JOIN...
October 14, 2013 at 6:30 pm
Koen Verbeeck (10/14/2013)
p.avinash689 (10/13/2013)
October 14, 2013 at 6:15 pm
drknight88 (10/14/2013)
Do I need to sort/order the query to insure the records are in the right order for the comparisons?
Read up on the LAG function. Part of its usage...
October 14, 2013 at 6:14 pm
Cadavre (10/14/2013)
SELECT *
FROM...
October 14, 2013 at 2:23 am
Cadavre (10/14/2013)
I'm sure you already did it
Hehe... Yes I did actually. I didn't post my results because I'd call all of the results overall too close to call so...
October 14, 2013 at 2:21 am
MickyT was definitely on the right track when he pointed you to Jeff Moden's article on finding islands in contiguous date ranges. However I believe a small modification (add-on)...
October 13, 2013 at 9:08 pm
Abu Dina (10/9/2013)
Use Jeff's string splitter function?
If you take this suggestion, be sure to change your data type from NVARCHAR(MAX) to VARCHAR(8000).
October 13, 2013 at 7:23 pm
Could you possibly be needing to use a GEOMETRY data type as your primary key?
October 13, 2013 at 7:17 pm
Viewing 15 posts - 1,291 through 1,305 (of 3,957 total)