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

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

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

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

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

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

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

Hello I've been having a quick look at microsoft technet I want to start somebody off learning about Transact SQL There's quite a few links Does anybody have any recommendations? Thanks Damian.

Hello Assuming the view returns the same number of records at the table e.g. tblItem has details of 1000 Items VwItem also has these 1000 items but perhaps does some additional calculations If I wanted to join to return (for example) the item description what should I join to? Is it more...

Hello Using SQL 2000 What's the easiest way to list each table along with the record count within a specific database Thanks

Hello Using SQL 2000 If I have the following sample data: Date Quantity In Quantity Out 200801 100 0 200802 100 100 200803 500 200 200804 300 200 200805 400 400 At day 1 the...

Hi Does anybody have any thoughts on this as it has happened twice now and i'm a little bit concerned We are using SQL 2000 Basically, I leave it running, used and backed up etc. Very occasionally, we have the need to create a new database - this highlights the problem The last 2 times i've...

Hello I have a problem in MS Word (2003) I am trying to cut and paste a picture When I paste it onto a pre-created document all it displays is a grey line I'm not sure who created the document that I am trying to paste onto If I create a new document and cut and paste onto the it works...

Hi I am using SQL 2000 I can't really describe this any other way, so will start like this Over the weekend our SQL server was rebooted (routine maintenance) Upon restarting, all the server roles have disappeared and, upon investigation a number of elements of the master database have become...

Hello We have 2 identical database on 2 seperate servers (SQL Server 2000) One live server, one test (live is a higher spec) Running the exact same script on the live server takes a number of times (20+) longer I've backed up and copied the database from live to test and given it a different...

Hello Could somebody point me in the right direction when estimating how many processors to use on a SQL Server implementation Thanks Damian.