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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. collierd2

    Cant display the header of footer in Visio 2007

    Hello I'm aware that the header/footer does not show on a page On one of my visio diagrams, it's not showing when I print preview either Really don't know why as I can create a new diagram and add with no issues Any thoughts what would cause something like this? Thanks Damian.
  2. collierd2

    Looping either 10 times or breaking out if successful

    Hello Using SSIS (SQL 2005), I'm looking for SSIS to help with the: I want to truncate a table Then connect to a server and extract data from that server into a table This I can do with a simple trucate and insert Problem is, the connection seems to fail pretty frequently So, I would like to...
  3. collierd2

    Most efficient way of handling tempdb

    ok, thanks I'll give that a go then
  4. collierd2

    Most efficient way of handling tempdb

    Won't grouping then grouping again have a negative impact on both performance and tempdb?
  5. collierd2

    Most efficient way of handling tempdb

    Hello I am having some issues with tempdb. Basically, it's growing beyond our disc drive space. I know, there's one piece of code causing it I appreciate records can be inserted a certain number at a time and that would keep this to a minumum although, I'm a little unsure of what to do with...
  6. collierd2

    Issue creating links to work documents

    Hello I'm using Cognos 8.4 I've created a folder and I now want to drop some MS Word or Excel documents into this folder I've added some documents to the documentation within webcontent I can see these when accessing the URL Now, If I try to add the URL by clicking New URL, it comes back...
  7. collierd2

    Issue with sort/distinct when updating

    Whilst I still don't know the source of the problem, it seems as though the 50k rows at a time has worked. This method builds approx 15x faster so I will apply it to the other databases Thanks
  8. collierd2

    Issue with sort/distinct when updating

    I updated statistics this morning. I've also dropped and reapplied indexes. It was a thought that cross my mind. Like I say, it just seems to create a different (inefficient!) execution plan. Right now i'm just rewriting to perform 50k at a time. I'll look at the pland for that. I'll also print...
  9. collierd2

    Issue with sort/distinct when updating

    I'm going to try a 50k rows at a time approach and see if that works better
  10. collierd2

    Issue with sort/distinct when updating

    update FactSalesOrderLineAggregate set Company_ID = isnull(DimOpCo.Company_ID,'*NONE'), FullAccountingDate_AT = isnull(DimAccountingPeriod.FullAccountingDate_AT,0), CustomerBranchID_AT = isnull(DimBranch.BranchID_AT,'*NONE'), CustomerCountryCode_AT = isnull(DimCountry.CountryCode_AT,'*NONE')...
  11. collierd2

    Issue with sort/distinct when updating

    Thanks Simon Row counts do vary from database to database. I've now realised that all the joins are actually appearing as a right out join within the execution plan - despite ALL join been left outer joins (?!?) There's something strange happening here as I really can't think why it would want...
  12. collierd2

    Issue with sort/distinct when updating

    Hello I am using SQL server 2000 I have a piece of code that performs a large amount of updates against every row on a table The code runs in about a couple of minutes against 5 of my 6 databases The other one takes over an hour All 6 databases are sychronised (Using SQL compare), such that...
  13. collierd2

    Stored Procedure Running each part of the code

    Strange, initially, I wrote the code without the gos and it failed. Just removed them all and it worked without a problem Thanks for the help Damian.
  14. collierd2

    Stored Procedure Running each part of the code

    Hello Using SQL 2000, I have the following code: CREATE PROCEDURE spDimCustomerAccountUpdate AS CREATE TABLE #temp ( rn INT IDENTITY (1, 1), Branch_SK int, CustomerBranchID_AT nvarchar(10), CustomerBranch_AT nvarchar(30), CustomerDivisionID_AT nvarchar(10), CustomerDivision_AT...
  15. collierd2

    Changing the data source/destination of a package

    Hello I have a package that transforms some data into a table (test, will eventually do a number of these transfers) It has a dynamic properties task along with a source and destination OLE DB Connection There's a transform data task between the source and destination servers I have created...
  16. collierd2

    Stored Procedure within a case statement

    Fantastic, thanks for your help
  17. collierd2

    Stored Procedure within a case statement

    Hello I have a stored procedure (spInventory) The procedure returns all stock movements between 2 passed parameters (@startdate and @enddate) Both are smalldatetime e.g. exec spInventory '2009-01-01', @currentdate Returns all movements from the start of the year up until now (@currentdate is...
  18. collierd2

    Display all levels of an hierarchy

    Hello I've spent quite a bit of time trying to work out how to do this (C8.2) Using report studio, i've created a report The report is a list report with a customer hierarchy in the first column and various sales figures alongside it The customer hierarchy goes: region -> branch -> sales rep...
  19. collierd2

    DMR drill through

    Hello I am using Cognos 8.2 I have created a report using DMR that has a column available for drill up/down What I want to do is drill through from that column to another report Problem is, if I enable drill through, it works at every level Drill through should only be available at the lowest...
  20. collierd2

    sql 2000 joins

    Hello I'm wondering if anybody has any recommendations for this issue: If I run a simple select, it works If I join to another table, it works If I join to a seperate table, it works Now if I join to both tables, it runs indefinitely Does anybody have any suggestions Thanks

Part and Inventory Search

Back
Top