Viewing 15 posts - 91 through 105 (of 622 total)
I've gone back on to the system and can't replicate the error today so maybe it was a friday brain fug. Thanks to everyone who contributed to the thread,...
May 21, 2018 at 7:14 am
My initial reaction is that you should be able to do this in SSIS with a regex extension from either APEX or Pragmatic Works. If not then can you run...
May 21, 2018 at 7:07 am
Thanks for the support and suggestions, I will see if I can cobble together a simplified version of the code to show the issue. The code has so much clean-up...
May 19, 2018 at 6:02 am
I agree with Patrick, There are edge cases that are not described in the original problem. Is the challenge to get as many orders in as possible, or get as...
May 18, 2018 at 10:15 am
The design pattern is to achieve one or more of the following, some of which have already been mentioned.
Take the calculation hit once at load time rather than burn...
May 18, 2018 at 9:49 am
No, I am joining two tables which have a common single field PK-FK relationship (should also be 1:1)
JOIN TableA ON TableA.ID = TableB.TabelA_ID = 125K records
LEFT...
May 18, 2018 at 9:42 am
I tried to do this recently with WORD 2010 on-premise with no success.
I don't know about 2016 version or O365 but 2010 has no functionality to read XML files...
May 18, 2018 at 9:25 am
YUK!
interesting challenge. If I were to do it in the code I would be looking at either RANK() OVER() in a CTE to sequence the entries and then...
January 4, 2018 at 8:07 am
before you try to execute put the SQLText into a msgPrompt so that you can copy and paste it to management studio.
I suspect the problem is that you...
January 4, 2018 at 7:53 am
Joe,
Don't go away but how about a new years resolution to try and be a bit less aggressive towards newbies and those for whom English is possibly not...
January 4, 2018 at 7:49 am
Joe,
Don't go away but how about a new years resolution to try and be a bit less aggressive towards newbies and those for whom English is possibly not...
January 4, 2018 at 7:47 am
Google for Recursive CTE - basically a CTE that references itself. You can set a level 0 in the CTE and then a derived level as the derived level of...
January 4, 2018 at 4:26 am
@rahoul
How have you managed to accumulate 1234 points on your profile when you can't even SUM and GROUP BY?
We are all for helping newbies and...
January 4, 2018 at 4:17 am
Jeff,
Are you planning to speak at any European conference this year (SQL Bits?) I would love the chance to shake your hand and thank you personally for your...
January 4, 2018 at 3:47 am
Let me try and restate the problem and can msmith confirm whether my understanding is correct.
Items come in different carton quantities (40,20,10,5,2) and at any time we will only...
January 4, 2018 at 3:08 am
Viewing 15 posts - 91 through 105 (of 622 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy