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...

Just to clarify, I don't work for LaunchCode, I'm a volunteer.

Thanks,

Kathi

I fixed the typo OVER  should have been ORDER BY

Thanks,

Kathi

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...

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...

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....

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.

LAG and LEAD do not use the frame. They are simple to use and perform great!!

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.

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.

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...

Have you tried posting in the user community for WS_Ftp? You might get an answer quicker there.

OK, corrected that, too.

I've added the indentation and corrected the case of calcsq.

Thanks,

Kathi

I modified the explanation a bit. The answer stands since he's asking about the value returned by that batch which runs successfully.