Search results for query: *

Hi, I have 2 calculated measures, one which should return a value for the given period, the other the cumulative value to date. My syntax is as follows: Period: ([Measures].[Quantity], [DimAction].[Action].&[1]) Cumulative: SUM([Measures].[Quantity], [DimAction].[Action].&[1]) Can anyone...

Hi, I have a AS 2005 SP2 cube with an Account dimension for financial statements. I need to use the ByAccount AggregateFunction property setting to ensure that both the Balance Sheet and Profit and Loss statements calculate correctly, however for reasons unknown i cannot get the correct...

Hi, I was recently asked to perform a number of backup operations by, in order not to upset anyone in Seattle, my "client" [wink]. I was only allowed to use SSMS, which may not have been installed correctly as many of the features were unavailable [wink]. 1. My "client" instructed me to...

Hi, Can anyone tell me the licensing requirements for Reporting Services 2005 Report development? I understand that anyone accessing the report manager to view a report requires a SQL Server CAL, however how is the Business Intelligence Development Studio licensed? The Licensing FAQ on...

Hi, Is there any way i can use MDX to return a list of a specific dimensions members, without the associated measures or do i need to simply use T-SQL? My dimension is effectively a list of all sites, and i want to return a list of 'Member Names' to use in a Reporting Services report...

Hi, My SQL Server 2000 DB is a subscriber to a dailiy replication from an off site SQL Server. Until recently, both servers were 2000 and replication worked fine. The publisher has now upgraded to SQL 2005 and is unable to reinstate the replication, apparently due to a permissions problem...

Hi, I have a proc that checks for the existance of a file in a network folder using xp_fileexist. Is there a way of returning the date a particular file was created using this or a similar method? Thanks in advance. Cheers, Leigh The problem with common sense is that it isn't that common!

Hi, I'm attempting to run a DTS package and change the value of a Global Variable using 'dtsrun'. My package simply takes the result of an SP and populates a .txt file. When i created my global variable (int datatype), i gave it a default value of 0 as it couldn't be left as null. my code is...

Hi, I'm trying to execute the following xp_cmdshell statement in order to create a new directory on a different machine to my SQL server. xp_cmdshell 'mkdir "\\Prnsrv01\reminders and direct mailing\Test Dir"' When i try to create the file locally, all is well, however not on the remote PC. I...

Hi, I'm a bit of a DTS newbie and i've been struggling with this all day now... I have a DTS task which outputs the contents of a table to a .txt file, i've had to use DTS as i need the column headings as the .txt file is used for an MS Word mail merge. What i want to do is add a WHERE clause...

Hi, I'm not sure if this is the correct forum to be asking this question, however i'm sure someone will point me in the right direction if not... I work for a relativley new company (UK based) that for the past couple of years has concentrated on growing the business and devoting the IT...

Hi, i have a public folder which contains contact information, outside of our global address book(s). Is there away of making the contents of this folder available to users offline via Outlook 2003, the same way that 'Contacts' is available? Thanks in advance. Cheers, Leigh The problem with...

Hi, Chain emails are becoming a problem with many of our users convinced that by forwarding on emials to 10 of their mates will make them win the lotto or save a Tibetan goat from becoming tomorrow night's dinner. These people have been warned regarding the potential issues regarding such...

Hi, I have several word 2003 letter templates which are currently used to mail merge data directly from my SQL Server 2000 database. In order to cut down network traffic, i'd like to be able to output my resultset from SQL as an XML file and send it to the user to use for their mail merge. Is...

Hi, I have a report that has been merrily running on a schedule for at least 12 months with no issues whatsoever. I'm been asked to modify the report slightly so i attempted to open it in Visual Studio 2003 only to recieve the following error message: "...\visual studio projects\sales...

Hi, I have a table within my Word 2003 document that i want to conditionaly format some of the cells based on their contents. the problem i have is that this document is used for a mail merge and therefore i cant simply insert an excel object and use Format > Conditional Formatting. I'm sure...

Hi, Is there any way of capturing the return value of DBCC CHECKIDENT and using that value as a parameter in an SP? I've tried SET @MyVar = (DBCC CHECKIDENT) and i can't use @MyVar = (SELECT MAX(id) FROM MyTable) + 1 as the next identity value may not be sequential. If it helps, my table has...

Hi, I have a user who's Outlook 2003 is adding 3 image files and a 4th file to any email sent outside of our network. The files are named: image001.gif image002.gif image003.emz image004.gif There are no images in the users Signature and these images are not related to our organisation...

Hi, I'm using BULK INSERT to import data from multiple sequentially numbered text files into my database. My code works fine and all is well until a particular file doesn't exist. DECLARE @Practice int DECLARE @File varchar(255) DECLARE @SQL varchar(8000) SET @Practice = 101 WHILE...

Hi, I'm attempting to use BULK INSERT to import data from a .txt file to a table in my DB. The problem i'm having is that despite working correctly, the data in the SQL table is imported together with its text qualifier, in this case ". My code is as follows: SET NOCOUNT ON GO TRUNCATE...