Viewing 15 posts - 1 through 15 (of 18 total)
Talent is always there and never hard to find! The problem is employers not wanting to pay for that talent! Yes thats great to offer training to those who...
January 4, 2022 at 7:36 pm
Just to clarify, I don't work for LaunchCode, I'm a volunteer.
January 3, 2022 at 3:15 pm
I fixed the typo OVER should have been ORDER BY
September 2, 2021 at 6:10 pm
I thought it was cool that Alice, our manager at the time, came up with a plan so that you could take that sabbatical last year. It took a team...
July 19, 2021 at 5:11 pm
I've have run only one garage sale in my life and am pretty sure Goodwill would have just tossed the floppies. I didn't have the box or manual. I'm keeping...
February 8, 2021 at 12:46 pm
We think it is really important that there is annual gathering for our community and we hope to see it continue to expand and thrive as the community of data professionals grows....
February 3, 2021 at 1:17 am
I think he came up with this from watching movies and TV shows. "Office Space" is one example of employees doing bad things to get back at the company.
November 30, 2020 at 1:12 pm
LAG and LEAD do not use the frame. They are simple to use and perform great!!
February 10, 2020 at 2:21 pm
Sorry, typo in the explanation. Query #2 is the answer and it is scoring properly. I updated the explanation. Query#1 -- wrong results. Query #3 won't run.
February 10, 2020 at 12:20 am
Looks like you are missing a comma after the FeatureValue column.
SET @sqls = 'SELECT ItemCode, IPN,PartnerName,CustomerName,FeatureValue, ' + @Columns + '
Try that and see if it works.
February 5, 2020 at 10:05 am
In this case, it would work. I should probably have pulled a different column like the amount. I wanted to show that you can use FIRST_VALUE and LAST_VALUE to pull...
February 3, 2020 at 12:01 pm
Have you tried posting in the user community for WS_Ftp? You might get an answer quicker there.
February 3, 2020 at 11:41 am
OK, corrected that, too.
January 15, 2020 at 6:33 pm
I've added the indentation and corrected the case of calcsq.
January 15, 2020 at 3:05 pm
I modified the explanation a bit. The answer stands since he's asking about the value returned by that batch which runs successfully.
January 13, 2020 at 5:45 pm