Search results for query: *

Hello We have a Sales cube with orders stored at line number level so: OrderNum -> 1 or more InvoiceNum -> 1 or more LineNum I've developed another cube that holds Enquiries which are recorded at order level so: OrderNum -> 0 or more EnquiryNum. I'm attempting to create a single cube with...

Im currently learning SSAS using the a simplified order schema. The order fact contains multiple dates i.e create_date_key, order_date_key, shipped_date_key each of which is linked back to the calender dimension via a foreign key relationship. When I process the cube, I end up with a single...

Hi I have a wireless and a wired network. I normally run 2 PC's, one on each network but since my PC is in the shop, I want to move the apps to a seperate profile on my existing PC. Here's what I hope to acheive - can anyone let me know if it's possible and how I can get it done? On profile A...

XML: <dataset> <official> </official> <unofficial> </unofficial> <aliases> </aliases> </dataset> The official and unoffical nodes both contain TeamA, TeamB, Selection (numerical) and Index (numerical). Additionally the unofficial list has several Sources. The aliases node containts Index...

Can anyone point me to a white paper or resource on the internal workings of the checksum function in SQL 2000? We are considering creating a function externally that replicates this function and can be used to compare rows from a VMS based system against SQL rows without having to compare...

On a fairly busy website, we are attempting to capture the HTML when specific conditions are met. Each time a page is visited, a SP is called to determine if those conditions are being met. If they are, details are logged to a table, with a auto incrementing integer clustered primary key. This...

I have an AFTER trigger for INSERT, DELETE, UPDATE as below. Using profiler, I can see that the trigger has fired but the data is missing from the target table. This occurs ocassionally, I'm at a loss to explain why. The trigger should rank all rows with a matching code and clear then re-insert...

Hi I'm pretty new to PHP to excuse the newbie question. I have a PHP file which I'd like to run on a schedule. On exit() it returns a number which is 0 for "All OK" and anything else for an error. I've tried evaluating the ERRORLEVEL in the batch file but it comes back as 0. Below is my...

Hi folks I'm curious why this is happening and haven't spotted anything similar on the boards yet. Every time I test my trigger the execution time bloats from 0ms to up to 2 seconds. I've written and tuned the trigger, which is down to about 16ms when I update the table with a single row - (we...

Hi This little Excel problem is giving me a headache. Hopefully, someone can help :) I have a fixed amount to distribute say dosh is £500. I want to distribute this to a number of households say houses is 3 households. Preferably, I want to distribute this as evenly as possible. But I also...

Hi I stumbled across tagged comments while trying out ApexSQL and Innovasys Document!X - not much information online about them, except they are referred to as something else ?! Any ideas ? Do you think it's something like extended properties that Microsoft will be supporitng into the future or...

Is this possible on Windows 2000 or will it only work on Windows 2003 or not at all ? Any hints, guides, FAQ's appreciated. Already have a cluster with SQL 2000 installed as default. Would be great to create a SQL 2005 named instance on same cluster. Life is a blast when you have a...

Hi I've created a stored procedure prUpdProduct on dbProduct that updates a table Brochure on dbBrochure which in turn has an on insert, update trigger trBrochure that updates another table BrochureFeature on dbBrochure. I have granted UserApp execute permission to prUpdProduct but it breaks...

Hi, Just out of curiosity, I wondered how I could get the numerical value of a word. For example "Smith" Could be 512 an it would be unique unlike "Smithson". I could use soundex but it would be the same for Smith and smiths for example. Life is a blast when you have a semi-automatic..

Hi I've got some code to send faxes on Windows 2000 which works fine using the FaxOutgoingJob but I can't seem to determine the successful fax status. Am I right in assuming that if it failed an error would be received, otherwise you assume it has gone o.k ? Looking at the fax monitor, I can...

Hi I have a bit of a dilemma. I am creating a data model for a client management system. A client can request we perform a service for a third party on their behalf. We create a case for the third party who will usually be John or Jane Doe. We want to be able to link all of John / Jane Doe's...

Is there any code / third party apps I could use to extend the functionality of Outlook web accesss ? I especially want the "Have Replies Sent To" option Life is a blast when you have a semi-automatic..

When I remove the commented line, this works in about 3 secs. Adding the commented line (subquery) causes it to hang. When I run just the SELECT statement with the commented line in, it also takes about 3 secs. So.. in summary, my code works as a select statement but breaks as a cursor. Any...

Ive succesfully put auditing on BUT I also get other events I dont want to see. Is there any way to reduce the number of events logged ? Life is a blast when you have a semi-automatic..

Im trying to create a string in a select statement that returns which columns are in error e.g SELECT Col1, Col2, Col3, CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END + CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END + CASE WHEN Col1 = 0 THEN 'Col1 Is In Error' END AS Result...