Viewing 15 posts - 12,916 through 12,930 (of 59,062 total)
February 11, 2018 at 9:25 pm
There's no need for the second GROUP BY and you can simplify the average calculation. Also, consider adopting and capitalization and indention standard for readability. You should also start using...
February 11, 2018 at 8:56 pm
What you're looking for is called a "Crosstab". The following is your code modified to do a "Crosstab".
SELECT Year = DATEPART(yy,SignalDATE)
,Weeks = DATEPART(wk,Signaldate)
February 11, 2018 at 12:23 pm
February 9, 2018 at 3:35 pm
I strongly disagree... Darko's code is a problem... several problems, actually. But we're...
February 9, 2018 at 9:24 am
{Edit} Took a post on Easter dates down because I found differences between a couple and I don't actually know which one is correct.
February 9, 2018 at 8:37 am
I strongly disagree... Darko's code is a problem... several problems, actually. But we're wasting time on that disagreement because neither of us will change our opinion there.
As for...
February 9, 2018 at 8:24 am
February 9, 2018 at 6:56 am
February 9, 2018 at 6:39 am
And, yeah... agreed. Very difficult to post good looking code directly.
February 8, 2018 at 9:31 pm
February 8, 2018 at 9:21 pm
And, no... there's no way that I'd use SSIS for any of this. ...
February 8, 2018 at 9:54 am
astrid 69000 - Thursday, February 8, 2018 6:32 AMThanks, I solved it already 🙂
and belated happy birthday!!!! 🙂
Two way street here, astrid. ...
February 8, 2018 at 7:17 am
I would like to be able to update a varbinary field (named Varbinary_Data of varbinary(max)...
February 7, 2018 at 6:29 pm
Viewing 15 posts - 12,916 through 12,930 (of 59,062 total)