Search results for query: *

No, these are separate, say for example a customer calling to check where their order is. "There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

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

We found it to be more involved than that, so in a nutshell, no. This guide proved invaluable http://msdn.microsoft.com/en-us/library/ms143686.aspx "There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

Thank you, has put my mind at rest. "There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

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

If i did that, how could I go about forcing IE/FF to use one rather than the other? I can't force the http to use a certain route as some of the programs use http to connect to my work site. "There are only two lasting bequests we can hope to give our children; one of these is roots, the other...

No 'fraid not, I need both connections but want to use a different one per profile, with both running at the same time (not asking for much!). Unfortunately, network settings are global but it appears I can at least set firefox and IE to use a proxy server. I've tried creating a proxy server...

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

Yes, it seems far too complex so I'm going to attempt to simplify it and keep it in SQL. Thanks :) "There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

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

Thats great, thank you very much "There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

Thanks for the link but the master data we want to compare isnt in SQL. It is in VMS and each file can consist of millions of rows. At the moment, we have a program that uses an odbc connection to reach into sql and find out for example which keys are missing but it is still a serial read...

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

You would get a better response in the Exchange forum but to quickly point you in the right direction, you can export your calender to CSV then import into SQL. You can do this using either BCP or DTS. If you find you do want to do it that way, Im sure there is a BCP faq on here. There are...

If you don't need to join both tables in a query, then that's how we do it - one connection string per server. Don't know if we use global.asa, that might be a question more suited to a .NET or ASP forum I think. If you do need to join both tables, I would look at Linked Servers in BOL. They...

That'll teach me not to refresh before I post :) "There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

I beleive you can use the decimal data type e.g. decimal(38, 15) will store what you wish. Caveat, Ive never used this in a production environment, so it would be a good idea to test it thoroughly. There are some other issues with using these data types - see BOL. "There are only two lasting...

Im not sure I understand clearly what you are trying to do - are you tring to determine when a SQL server is unavailable or are you receiving an error in an application which you're attempting to debug? "There are only two lasting bequests we can hope to give our children; one of these is...

Hey, Great to hear you sorted it out :) "There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

Off the top of my head - which is probably not a good idea before coffee, check the collation for each of your (n)varchar/text columns used within your query and ensure they match. My lazy way to do it is to script each table in Enterprise Manager (Right-click on the table, All Tasks, Generate...