Search results for query: *

I have a "view" where I am using DATEPART (week, [mydate])to show the current week and I need to make sure that the week shows up in the view based on the week starting on Monday instead of the standard US week which starts on Sunday. What is the best way to combine DATEFIRST with...

Hi all, I have a number that I need to divide accross a group of percentages. Example: $1000 - Need to spread this number accross the following percentages 60%,30% & 10% to find the correct $$$ value for each. Note that the total percentage will always be %100. There are several fields...

I have created several data cubes in MS Analysis services and am using MS Office Components to view them in a web browser on our website. I am TRYING to remember how to view the entire SELECT statement for a given data cube.(MDX Query) I want to be able to cut and paste the MDX query into...

I am trying to insert a row of data from one table where it does not exist in another table using the below statement. In this case, I want to insert the data from table A into table B where week 4 in table B does not exist. And at the same time I am setting the week in table B to be 4. I get...

Can anyone tell me where to find a good training class for Biztalk ? Or at least recommend a few good books ? I searched the Microsoft site and could not find too much in a way of training. Thanks, George

I am somewhat new to MDX. I have a webpage that displays a pivot table based on an Analysis server data cube. I am trying to create and MDX statement that would show ALL data in the cube for a given sales person based on the Microsoft login ID. Example: Show all data in a given cube for sales...

Could someone please tell me the best way to find out the transactions per second during peak operating hours ? Thanks

I have 6 tables that I need to join. Each table has an identifier that exists in all other tables. I can join the first 3 tables using DISTINCT and I get the results I am looking for. But when I try to add any of the remaining three tables I get only a few records. I could create 2 separate...

I have three tables that I need to join. There are several fields in each table that are the same and there is only one common field between all three. I was using the common field for each table to make the join but the problem I am having is that when I add the third table, I get rows of data...

I am trying to convert a text field to a date field based on the below structure. I have several dates that are null which I think I can deal with but I get failures for dates that are stored as NON date values. Example:99999999,etc I would like to be able to convert the below dates and set the...

I need to update exchange rates in one table based on values from two other tables using date ranges as shown below. Table to be updated: UPDATE tbl_Sales_Fact SET Exchange_Rate = 1.448 Exchange Rate comes from another table which could be several currencies as I have shown here: 1.4485...

I need to select the last date for any given month that exists in a table on sql server. I have looked at books online and other help topics but can't find how to do this. Any help would be appreciated. Thanks