I've been thinking about this a lot - one of my main problems is that there is a lot of business logic in our forms code - it doesn't belong...

Actually I've found some things out and now I feel a bit conned....

The report model DOES NOT allow you to abstract your data model to a set of business relationships...

If you send me a private message with your email address and I'll send you a step by step guide on how we did it with some code samples.....

Rich

Yup - use SSIS, you want to create an Integration Services project in BI development studio.

There are other ways around this problem, and you might want to consider looking at what...

Just a thought - I've got some good internal documentation for setting up HSODBC from Oracle 8i --> MS SQL and vice versa, if anyone wants it you're welcome to it, just send...

Hi Amy,

I'm running 8i, so I don't know how relevant what I know is.....

The way we run our Oracle procedures is via linked servers - I link the server into...

Just a thought Joe - the total available is presumably derived from your stock figures, I'm wondering whether you should just drag this out "live" as and when you need...

>>I can't figure out how to have 2 delimiters or terminators in the bulk insert command.

Don't bother then, just load up your text in notepad and do a find replace...

Hi Joe,

Ok, we're trying to do the same things at the moment so I understand where you're coming from.

What I can't reconcile is why you have shoved everything into a...

Of course that would work Stewart, fair point.

Interesting bone of contention between myself and our developers. I say that a nested max should be unnecessary in a well designed database, they...

I wish someone had answered this question 3 weeks ago

OK, you have two main elements you might need for this.

ReportServer is for creating...

I agree with Vladan - sounds like you've got a problem with your data model. If there is more than one address for each person then you have to work...

Hi Lloyd,

Oh dear, old technology eh? I've had this problem myself in the dim and distant, this was it :

http://groups.google.co.uk/group/microsoft.public.sqlserver.datawarehouse/browse_thread/thread/87b66eec639cae0a/c3f619f71ea3e9cd?lnk=st&q=sql+server+7.0+backup+to+network&rnum=2&hl=en#c3f619f71ea3e9cd

HTH

Rich