I was booting, then I logged on, started visual studio (didn't get to the usual UAC prompt), right-clicked Chrome, ...and black-out. Fried. No response to anything. Dead.
My only chance to get anything done for 1.21 is....... to download the source onto my work laptop. But I have 32-bit Office.
And there's no way I'm swapping my Office install on that machine
LOL
I get up to unplug it...
... it's not plugged.
I ALWAYS LEAVE THAT POWER CORD IN THE WALL! WHO PULLED IT AND SCARED THE SHIT OUT OF ME LIKE THIS???
To add some context, the query is going to pull users that are only from a certain group of sellers. The data that tells you if they are a part of that group lives in another database DB2 and the lookup index is actually buried in a field that has a value like this: "O:123456" so we first have to look for the records with the right letter before the : and then take the index from the part after the : — Brian T Hannan24 mins ago
@Mat'sMug Looks like you're not the only one stuck with a crappy string-based database structure :D
Too many string functions!
Based on your comment I think there would be some ways to reduce string functions to speed up this case statement.
To add some context, the query is going to pull users that are only
from a certain group of sellers. The data that tells you if they are a
part o...
I mellowed it a little bit. I feel sure that a null check with string wildcards would be faster, but... damn that case statement is a mess
I'll go with gut-feeling here:
INNER JOIN
DB2..table4 (NOLOCK)
ON CASE
WHEN CHARINDEX(':',
table2_batch.reference_number,
3) > 3 THEN SUBSTRING(table2_batch.reference_number,
3,
CHARINDEX(':',
table2_batch.reference_number,
3) -3 )
...
I was mostly hoping that the OP would realize just how weird what they are doing is by explaining it in plain English. I would wager that they didn't write that but rather it got "dumped" in their lap
@downvoter: care to answer yourself? or comment, at least? — Mat's Mug28 secs ago
damn you SO
There is no information here that's necessary to help you. This has zero chance of receiving a useful answer. The existing answers just received a -1 from me because they are random guesses. Who knows what element of this query is slow?! Noone can. To help you resolve the problem: Learn about query tuning in general or post a lot more information (query plan, schema, ...). — usr4 mins ago
ah
random guess, indeed. but I'm pretty damn confident about it.
I just tried this and I got this error: "Conversion failed when converting the varchar value '3583355:3807567' to data type int." — Brian T Hannan50 mins ago
You did not mention that the data before the colon can be something other than a single letter. Let me see if I can make this work using sql fiddle... — Phrancis2 mins ago
@Mat'sMug who knows if that join is even important? The joined tables might consist of zero rows. 99.9999% of the time could be spent elsewhere. Noone knows anything. I have tuned 100s of queries and I don't have any idea what's slow here. You cannot tell from the query alone, ever. — usr1 min ago
actually that function is part of the ETL process I'm building on SSIS, which is under SC. I should save a .sql file out of it, and include it in the project.
I was tasked with re-writing a login VBScript we use on about 50 machines. The original script was hacked together by someone who clearly had no idea what they were doing (multiple lines that literally did nothing, including creating persistent shares, deleting them, then recreating them 4+ times...
I feel like I'm getting there-ish with Objective-C, sort of. I mean, I don't feel like I know every part of the framework inside and out (a lot of it though, maybe most)... but I do feel like I have a pretty exact understanding of how exactly the language works.
I don't know vbscript even in the slightest, so this review is going to use the Socratic method.
Const STORE_NUMBER = "29"
Why is a variable with the word "NUMBER" in the name of the variable actually a string? Should this be an integer?
Given:
Const NUM_REGS = 3
Why are we bother...
I previously asked about a login script using VBScript, being a Python programmer with literally no experience in VBS. I took those suggestions to heart, and would like to submit the result for further review.
Specifically: am I repeating myself in the class definition? Do I really have to decla...
> AdamSmith: You likely did not get much feedback because (1) there are not that many active VBScript programmers these days and (2) your code is pretty good. – Eric Lippert
> During his sixteen years at Microsoft he was a developer of the Visual Basic, VBScript, JScript and C# compilers and a member of the C# language design committee;
Too many string functions!
Based on your comment I think there would be some ways to reduce string functions to speed up this case statement.
To add some context, the query is going to pull users that are only
from a certain group of sellers. The data that tells you if they are a
part o...
I'll go with gut-feeling here:
INNER JOIN
DB2..table4 (NOLOCK)
ON CASE
WHEN CHARINDEX(':',
table2_batch.reference_number,
3) > 3 THEN SUBSTRING(table2_batch.reference_number,
3,
CHARINDEX(':',
table2_batch.reference_number,
3) -3 )
...
I don't know vbscript even in the slightest, so this review is going to use the Socratic method.
Const STORE_NUMBER = "29"
Why is a variable with the word "NUMBER" in the name of the variable actually a string? Should this be an integer?
Given:
Const NUM_REGS = 3
Why are we bother...
VBA Rubberducking
VBA Rubberducking