Viewing 15 posts - 7,876 through 7,890 (of 9,720 total)
I just realized I'm going about this all wrong. I don't need *random* numbers specifically. I just need numbers that are NOT the TaxID. Which means I can use a...
July 7, 2010 at 8:41 am
First of all, "she", not he. @=)
Secondly, I need random numbers that do not repeat. I'm not limited to a range, but I need to make sure they only repeat...
July 6, 2010 at 11:33 am
lionwelp (7/1/2010)
Brandie Tarvin (7/1/2010)
Also, am I reading correctly that you want the most recent Druk_nr value? The one with the greatest (most recent) creatie__dat?
I want to have the most recent...
July 2, 2010 at 9:24 am
CTE stands for Common Table Expression. There's no easy way to explain it except as a pre-query to your main query which can replace 1) a temp table, 2) replace...
July 2, 2010 at 9:15 am
Good catch. I missed the '/' character. I was assuming that maybe he meant for that to be the unicode character of N.
July 2, 2010 at 9:11 am
Have you experimented with PIVOT yet? As usually coded, it wouldn't directly output your results as expected, but I bet you could nest a few PIVOT subqueries together to come...
July 1, 2010 at 10:48 am
Honestly, I think you're overly complicating things. You don't need the function, if I'm reading your code correctly. You can just do a CASE statement in the JOIN clause.
Also,...
July 1, 2010 at 10:42 am
What is vvers_dat supposed to be? I'm running your code on my sandbox and I can't do the data insert because that column disallows NULLs and has no insert value...
July 1, 2010 at 10:26 am
Thanks, everyone. I appreciate your assistance. Looks like I'm stuck with cursors still, but I'm well on my way to a solution.
Soon as I verify it, I'll write up an...
July 1, 2010 at 10:17 am
Eugene Elutin (6/30/2010)
1. You better try my update before saying it will not work.
You're correct. I didn't catch that you were using FranchiseID in that number. I skimmed over...
June 30, 2010 at 10:12 am
Thanks, but your solution won't work. Even though my supplied data set only has one paired team, my actual database has multiple FranchiseIDs with multiple StoreIDs. Your update will make...
June 30, 2010 at 8:57 am
He's correct. Your exec statement is the problem. You're missing a single quote right before 44.0.
EDIT: Make that before BOTH 44.0 bits.
June 30, 2010 at 8:39 am
Thanks for the info, Carolwood, But that doesn't answer the OP's question. Does that software allow for de-duplicate backup procedures?
June 29, 2010 at 6:27 am
The Query Builder does have memory / processing limitations compared to the regular query window. We've had a lot of issues with users creating workable queries in the QB that...
June 29, 2010 at 6:25 am
Viewing 15 posts - 7,876 through 7,890 (of 9,720 total)