Loner (10/7/2007)No team can build a data warehouse or any system in seven days unless the company have a thousand developers. But even the company hires a thousand developers,...

Did the default database setting cause a change of scope? Meaning - the "old" way had you connecting into a specific instance, and the new one might not, or...

SSMS is trying to connect using named pipes - but you haven't enabled named pipes (Surface configuration shows TCPIP only enabled). So there seems to be a client config...

It's a reasonably straightforward thing to do in T-SQL, so can that be coded easily into a SSIS package? sure. You're not giving any specifics, but I can give...

And - just for giggles - what's the name it's trying to connect to in the OLAP step?

one sec - you want only want TOTALS greater than zero? or only add up the positive lineitems?

If you only want positive totals, that's a little different - that's a...

Don't get me wrong - the Outlook client install is usually the most straightforward way to do this. It's just that once the client is installed, the ONLY part...

Two quick methods. The second one only if you need the negative total as well....

Method #1 - "include only credits"

select visit_ID, sum(pmt_amt) from [yourtablename] where pmt_amt>=0 GROUP BY...

peterzeke (10/5/2007)

So next time the toilet gets clogged, rather than assume it will take 20 minutes to plunge it out, I put some bigger numbers around the job, say 3...

Your inner query isn't related to the outer query in any way, and you have 3 columns instead of one in the sub-query.

You need to use something like this (the...

It's not so much setting up Outlook as it is setting up the MAPI mail account on the machine (in the Control Panel, Mail area).

In other words - I don't...

The main purpose of partitioning is to try to spead out the work across multiple disk sets threads and processors to speed things up. The best performance is when...

Well - trying to compare a local connection to one going through a firewall isn't exactly apples to apples. There are a lot more moving parts in an "over...

No reason you couldn't. Remember - bcp runs from a command prompt, so you can "parameterize" that any way you wish. If you were to enclose that in...

[rant]

That's some of the worst auto-generated code I've ever seen. That makes trying to clip your toenails with a chainsaw not look so stupid. Whoever built the system...