Search results for query: *

We have some fairly substantial packages running as part of an over night warehouse load. Two nights ago they failed due to a connectivity issue the package couldn't find the source server. As a result we had to run the packages the following day during business hours. Now to some extent we...

Ok im reasonably new to SSIS and i was wondering if you could help. I have a large database from which i need to pull large amounts of data. Row's numbering in the several million easily. I need to pull the data out, aggrigate and transform it and pump it into a new database. I need this to...

Hi i need idea's of how to change the following. Im trying to Build a history table Which updates the current history data when a none critical field is changed, but inserts a new row when a critical field changes or a new service is added. My problem is when a customer changes thier QTY ...

I've simplified the example somewhat but essentially im looking for a way of calculating the cost price of items recently sold based on a FIFO methods. Here's two basic tables (somewhat simplified) [Sold] ITemID, SaleDate, QTY, Price 1, '2009-05-01', 2 ,£13...

Hi, im currently a software engineer and my career is going great having recently graduated university im exactly where i hoped to be at this point in my career. However... My significant other half sacrificed his own career to get me here and looking for suggestions to help him get back...

I have a table containing information on people, called person, this is linked to a second table called Employee, every person in Person has a record in Employee, so under most circumstances an inner join works well here. However of those employee's "some" are managers, these have another...

Having spent many years working a minimum wage dead end job where my manager contently took advantage of my IT skills and general willingness to go outside my job description. I finally realised after 7 years of hollow promises that i was never going to progress and it didn't matter how many...

Ok what i have is something like this, GH1 - name, Max(@cost) Details(suppressed) - name, @cost I have to use the a formula to pull the "cost" from the database because there are many types of costs in the database and im only interested in one kind. And each item may have many of this...