Hm, neat. I see what you did there. The Parsename had me all sorts of scragged up until I broke it down and figured out what you were...

Welsh Corgi (8/16/2012)

---

This is the response that I got:

You have two choices, a USB drive direct attached or a nas network attached drive. I don't have any other options. Sorry....

I'll have to agree with Lynn on this one. Setup a test between a map and a locally generated and run multiple timing tests. Present those results to...

I'm not sure I'm seeing what the difference is between your code and what I'd posted earlier Sergiy... am I missing something there?

Nevermind, I see it. Why round trip...

How up to date does the copy need to be kept? Snapshot replication isn't going anywhere anytime soon as far as I know, and should work in standard.

... which,...

M_E_K (8/16/2012)

---

As a side question (sorry if it's a newbie one) : if the session coming from the Oracle app is set to read_uncommitted, why are we blocking the truncate...

ESpigle (8/16/2012)

---

Interesting--I had not really looked at or considered that option. I'll have to dig around for some more extensive information and howtos on doing this. The link...

To add to the above information, merely adding an order by to the update from statement will not guarantee the ordering of the internal components. SQL Server does whatever...

david.ostrander (8/16/2012)

---

I would agree and would like to use the Multicast. I attached a image of what my Data Flow looks like at the moment.

How can I upload my excel...

DataAnalyst011 (8/16/2012)

---

Actually I am a complete newbie. I was hired on at a medical school to create statistical reports and dashboards since I'm basically the only one who knows the...

Yeah, preflattening might be a best choice here, but somewhere in your ETL you'll end up doing a pivot somewhere. Have you looked into SSAS and attaching reports to...

Lynn Pettis (8/16/2012)

---

Evil Kraig F (8/16/2012)

---

*blinks* Homework question? I feel like it's being setup for a punchline.

Books online; data types. Check out int, bigint, decimal, numeric, float,...

You can't avoid a pivot here (that's exactly what this is), you're going to do that or cross-tab, which is a series of grouping functions with your pivot pre-built, basically.

Out...

I would agree with SSIS in general, but if that's not an option and you must stay in T-SQL the easiest way is to quick-hack the results for BCP, like...

*blinks* Homework question? I feel like it's being setup for a punchline.

Books online; data types. Check out int, bigint, decimal, numeric, float, and money, for starters.