Viewing 13 posts - 1 through 13 (of 13 total)
I think you pointed me in the correct direction. I did not had a listener.
Checking this now. if that brings the solution for my issue.
May 28, 2019 at 11:52 am
In short --> An always on cluster sends log files from the primary server to the other server(s). (like mirror databases or transaction log shipping)
During the time the always...
November 2, 2018 at 8:55 am
Extra info, I made it like this to see the exact days hours etc
SELECT T1.Number, T1.StartDate as [New], T2.StartDate as [Assigned],
CAST ((datediff (ss, T1.StartDate, T2.StartDate)/3600/24) AS varchar (2)) +...
February 20, 2015 at 9:43 am
Thanks,
I needed to play a bit around to get the data the same way you had. Using a table variable now, but the last line with the cross apply did...
February 20, 2015 at 9:35 am
Thanks,
I needed to make some small changes because it was only part of a complete script, but I got it working.
And also understand the query itself.
Peter
September 30, 2014 at 4:43 am
Thanks for this reply.
The current_timestamp is from SQL, it work fine.
And the query itself is part of a scripts, so the rows are already calculate.
But anyway, I will see what...
March 5, 2014 at 1:04 am
Thanks, that was the solution for me.
October 29, 2013 at 6:07 am
Ah thanks,
That worked.
Just was too focused into getting a SET statement, but doing it directly in a SELECT is way easier.
Peter
May 10, 2013 at 7:45 am
Yes, yours is working great now. thanks a lot
September 7, 2012 at 3:29 am
Yes, it works.
Thanks, now I can dig into the script what it really does so I can also try to understand.
Thanks very much.
September 7, 2012 at 3:22 am
Still not working with the newest queries I got, same error withe the group by clause (even twice this time)
Maybe this is more difficult then expected. because if I use...
September 7, 2012 at 2:56 am
Yes when there are 0 logins, then it should return 0
September 7, 2012 at 2:22 am
unfortunately not
Msg 8120, Level 16, State 1, Line 6
Column 'Miview.Start' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY...
September 5, 2012 at 8:02 am
Viewing 13 posts - 1 through 13 (of 13 total)