Search results for query: *

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.

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

ok, thanks I'll give that a go then

Won't grouping then grouping again have a negative impact on both performance and 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...

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

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

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

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

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')...

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

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

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.

...branch on bud.Branch_SK = branch.Branch_SK go declare @loop integer declare @totalrecords integer SET @loop = 1 SET @totalrecords = (select count(*) from #temp) -- Run Code to update Customer table WHILE @loop <= @totalrecords BEGIN insert into DimCustomerAccount select @loop+99, ''...

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

Fantastic, thanks for your help

...declare @startmonth tinyint declare @endmonth tinyint set @currentdate = getdate() set @edate = dateadd(dd,(datediff(dd,-53684,getdate())/7)*7,-53684) set @sdate = dateadd(dd,-6,@edate) set @startmonth = month(@sdate) set @endmonth = month(@edate) case when (@startmonth = @endmonth) then...

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

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

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