Viewing 15 posts - 301 through 315 (of 26,490 total)
I can't test the openquery part of your code but I am pretty sure that the double quotes are your problem. I also added a bit to your sp_executesql that...
December 4, 2019 at 10:46 pm
See what happens when you make the following change:
ALTER FUNCTION [dbo].[GetTenPercent_Moss]
(
@parentId int,
@sampleyear int
)
RETURNS TABLE
AS
RETURN
(
SELECT TOP (10) PERCENT
...
December 4, 2019 at 10:23 pm
I wonder whether I will be cast out from The Thread as a maverick grammar nutjob for suggesting that NSO would be a better abbreviation, given that 'verbal' means...
December 4, 2019 at 9:24 pm
Sheesh, week 13 and the playoffs are already set! And I'm on the outside looking in...
For those out of the playoffs, there's still seeding for and competition in...
November 26, 2019 at 8:47 pm
This looks like the earliest this has occurred. Normally it seems to go until the final week to finalize the top 6. Didn't think I would make it based on...
November 26, 2019 at 6:25 pm
Let me try to explain a little better.
I need to get a select where all columnB that are not columnA value 1 turn to zero.
This explanation...
October 20, 2019 at 2:13 am
You want the best help, post the full SQL code and the error message you are getting. Posting a tiny snippet does not provide the context needed to really help.
October 17, 2019 at 5:08 pm
Would help if I checked my line-up more often, nothing like missing that your QB is on a buy week.
I won't be at PASS 2019, but I plan on registering...
October 17, 2019 at 4:35 pm
Glad to see that someone rewrote the multi-step tvf to an in-line tvf. That really should help the performance, but of course ymmv.
October 8, 2019 at 7:09 pm
I'm sure that someone else will understand what is being requested here, but it's beyond me.
Yes, I am confused as well. Good thing I am at work so...
September 26, 2019 at 7:46 pm
re "for part no XXX708, it selects 3 warehouses with no activity but there are 2 more with recent sales"
I think the initial query I gave you should work:
September 10, 2019 at 7:43 pm
Thanks for the very kind feedback, Jason.
Interesting code, Jason. While I've seen such a thing before, I've not seen many folks that provide a starting value and number of...
September 10, 2019 at 5:05 pm
Viewing 15 posts - 301 through 315 (of 26,490 total)