Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by leiela

  1. leiela

    SSIS Best Way To Load Huge Tables

    Found the failure property and it works wonderfully thanks. Yeah we are running enterprise so i'll try having them run in parallel and see what happens. However as for using one source item, they are all coming from the same database/collection of tables but each feed implements a SQL...
  2. leiela

    Slow Running Packages

    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...
  3. leiela

    SSIS Best Way To Load Huge Tables

    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...
  4. leiela

    SQl Select table where clause 'WHERE is a conditional' ???

    Hi im not really sure at what exactly you want your query to do, if you can explain it i can help. Looks to me like you need a case statement in your where clause something like. Where Active_client = 'Y' And sales = 1 AND 1 = Case When day(getdate()) = 1...
  5. leiela

    Merge Problem

    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 ...
  6. leiela

    FIFO Costing

    Yeah i've looked at that article and i have to admit it just confused the hell out of me. TBH i'm not great at working with temporary tables.
  7. leiela

    FIFO Costing

    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...
  8. leiela

    getting back into IT

    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...
  9. leiela

    Data Selection, Outer Join's

    oh sorry its Crystal reports IX
  10. leiela

    Data Selection, Outer Join's

    i wasn't sure it was clear, sorry. heres the join's {person.personid} = {employee.personid} (inner join) {employee.folderid} = {manager.folderid} (left join as i want all employee's even ones without a manager record) ------------- my selection formula is currently...
  11. leiela

    Data Selection, Outer Join's

    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...
  12. leiela

    New in the IT world.

    In my job i work closely with SQL and Oracle as well as crystal, infact it was my experience with oracle that got me the job. So im pretty competent at pulling data from a database without the nice pretty interface crystal provides, and tbh i enjoy working with databases. Is specialising in...
  13. leiela

    New in the IT world.

    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...
  14. leiela

    Performing Summary's on formula's

    Won't a grandtotal on the detail level add up all of the values? i specifically only want it to add up the "max cost" for each item. Example. GH - Tin of Beans - 50 <---- Max of details Details - Tin of Beans 30 Details - Tin of Beans 30 Details - Tin of Beans 50 Details - Tin of...
  15. leiela

    Performing Summary's on formula's

    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...
See more

Part and Inventory Search

Back
Top