Recent content by stigejg

Hi James, Thank you for a useful tip, It's just been tested and worked like a dream within the ETL-job. Lots of stars to you. Stig

Hi james, this is interesting Something like this? CREATE PROC Uppdate_Price_On_Productiondata AS UPDATE A SET [Transaction Price] = B.[Costing sum 1] FROM Production A JOIN Pricelist B ON A.Company = B.Company AND A.Facility = B.Facility AND A.[Component number] = B.[Item number] AND...

yes I am using SQL server. ETL-job is av datawarehouse job that moves data from one datsource, does the necessary modification before it is stored in an new datasource. This job is scheduled and automatic when it is set up. Stig

Hi, I have two tables on a datavarehus server that goes trough a full refresh every night by an ETL job. These tables are "Production" that contains production data and a "Pricelist" that contains our standardprices. To save time and capasity i just put 0 in to the...

Hi SQLSister, I have looked around in books online and tryed to figoure out how to solve this case. But I am not familiar with Transact SQL and how I have to use the parameters for firing the trigger. And you are right, the SQL syntax are supposed to update several records. The production...

Hi, I am quiet new with SQL server programming, and I am not familiar with building up triggers and so on. I have a couple of questions: A couple of days ago I got a wery helpful tips from "Terry L. Broadbent" with this SQL syntax: Update pr Set [Transaction Price] =...

Hi Terry, Thank you, your tips is just what I needed. It works like a dream.

Hi, Thanks Jay, this one was just what I needed. Stig

Hello, I am working with something that for a while ago saw to be an easy job, but now I have used most of the day trying to solve this problem. I have tryed all around me that I thought could help me whitout any luck. So now I have to try you folks out there. I have two tabels called...

Hello, I am working with our brand new datavarehouse making tables and reports. And now the scheduled jobs are started to crash because ewryone wants their datamateria updated round midnight. So my big question is only if anyone out there can tell me an easy way to list out evry schedule-job...

Hello I have just started to teach myself java-programming and I am in the beginning of the book. Starting with the "Hello world" phrases, and I am using Jbuilder 3. But the console-window are closing before i can manage to read the result of my programming. So my litle question is...

Hello, I am going to work on some programs that is connected to an SQL server via ODBC, an i am using this connectionstring: "PROVIDER=MSDASQL;DSN=kvalreg;UID=sgu;Password=admin;" But since I dont wont to destroy any data on this server I have decided to make a working copy on an...

Hello, I have a huge problem now, I am put in charge for an old application that takes care of communication between our Production-database (SQL) and our ERP-system. In this application there is some spreads. The big problem here is that the spreads is made in Spread 3.0 and I just have...

Hello again, Now I have found out about this problem. It si the serverversion of Norton Antivirus and Cognos that does not work together. Omehow the antivirsuprogtrram stops the updatineg of the powercube. How and why I dont know. I have to make my mdc-file localy and then copy it to the...

BlueBrand, I am using an DB2, and I have tryed to delete the cube before making a new one. But evrytime I'm doing an attempt to make a new cube I get this error-message. The funny thing is that if I make the cube locally there is no problem. Stig