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

Glad we could help.

lionwelp (7/1/2010)

---

I want to have the most recent...

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

Good catch. I missed the '/' character. I was assuming that maybe he meant for that to be the unicode character of N.

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

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

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

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

You're correct. I didn't catch that you were using FranchiseID in that number. I skimmed over...

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

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.

Thanks for the info, Carolwood, But that doesn't answer the OP's question. Does that software allow for de-duplicate backup procedures?

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

samiam914 (6/14/2010)

---

I am having trouble with linked server. In this linked server, only one windows ID is mapped to an Oracle ID ... it's password does not conform to windows...