Viewing 15 posts - 7,876 through 7,890 (of 9,715 total)
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
samiam914 (6/14/2010)
June 16, 2010 at 6:29 am
Spiritual support is also acceptible. But when you do get back into gaming... @=)
June 14, 2010 at 7:26 am
It's not services you necessarily have to worry about. It's all the little things, like Linked Servers, jobs or SSIS packages that specifically call those accounts, etc.
The only way to...
June 14, 2010 at 4:44 am
Are your servers within the same domain and both inside the firewall?
If not, is your firewall open to the ports being used in the mirroring?
June 14, 2010 at 4:39 am
Crashes as in it brings SSMS down or freezes SSMS or what?
Describe what happens step-by-step please.
June 11, 2010 at 11:58 am
Viewing 15 posts - 7,876 through 7,890 (of 9,715 total)