Search results for query: *

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

Hello I am an current user of the Cognos products Transformer (to create the power-cube), Impromtu (where I first make the *.imr file that I converting to my *.iqd file) and Powerplay where I make the reports. And for a long time there has been no problems, but now it has stopped completely...

Hello, I have som etrouble to understand the art og VB programming. I have e litle program that I mam trying to work just to learn me a litle programming. My program has this global declarations: Private mCN As Connection Private mRS As New Recordset And I want to view the tata in the...

Hello, I have som etrouble to understand the art og VB programming. I have e litle program that I mam trying to work just to learn me a litle programming. My program has this global declarations: Private mCN As Connection Private mRS As New Recordset And I want to view the tata in the...

Hello, I had the same problem with my ADSL-connection and I where adviced to download a new connection-software called RASPPPoE and run this on my machine. And after that I had the promiced upstream speed on my connection. Stig

Hello, I have purchased me an new computer with Win ME and here I got som problems installing my old Borland c++ 5.0 (for educational purpose), so I installed Builder 4.0 (purchaces from the magazine PC+) But when I am trying to comile my small programs this errormessage shows up: Debugger...