Search results for query: *

Thanks guys, I will try both these out shortly and let you know if I get stuck further. Regards. MrPeds

Hi, I have a simple SQL Server 2008 table that contains history information relating to a salesPerson and their associated Office on given dates. The data is a bit like this: ID_Salesman, ID_Office, StartDate, EndDate 1 2 2010-01-01 2010-01-05 1...

Sorry for the late response! This script is really powerful and simple, thank your for your help! MrPeds

Hi, Thanks for the response. Any suggestions on how I would detect the users number format in client-side javascript? I could then use this to set the stylesheet separator dynamically in client side javascript. Thanks, MrPeds PS: I know it isnt strictly an XML follow up question but...

Hi, I have an xslt file that carries out a simply transformation on an xml file. One of the transformations i am carrying out is the display of some readonly decimal values (2 decimal places). I am carrying out the transformation client-side in the browser. e.g. select="format-number( $var1...

Hi, I have another noob javascript question, sorry to be a pain! I have a simple html table. Each row contains a text box where the user enters some percentages. The percentages must add up to 100%. I have some validation code to ensure that only numbers are entered in the text boxes. What...

thanks for your help!

Hi, I currently have some javascript code that returns a UTC date: var d = new Date(); document.write (d.toUTCString()); This returns a string like this: 'Sun, 31 May 2009 20:03:23 UTC' I want to eventually write this to a SQL server database so need to format the string to a sensible...

Thank you for your response! I ran SQL Profiler to identify what queries were being executed by the RS report. This gave me a starting point to work from. Regards, MrPeds

Hi, I was wondering if there is a way of obtaining a list of database tables that have been partitioned and the details about those partitions? e.g. are there any system views or system stored procedures that can be utilized to return this information? We have a requirement to build a UI that...

Hi, I have inherited a number of aspx pages that I have been tasked with localising. The pages have never been designed for localisation so I think this may be some of the problem. I'd basically like to know how I deal with scenarios like this: 1) Static text contained within HTML markup...

Hi, I have some code that works in VBScript when I try and connect to an analysis services 2000 cube. It does something similar to the following: set cn = CREATEOBJECT("ADODB.Connection") set rs = CREATEOBJECT("ADODB.RecordSet") .. .. Call cn.open ("Provider=MSOLAP; Datasource=" + tServer +...

Hi, Is it possible to use the isql executable on a machine that does not have sql server installed? e.g. as long as we provide the server name, username and passwords to a machine that does have it installed are we able to still use it ? Thanks. MrPeds

Hi, I have an SSRS 2000 report that contains 2 datasets. Each dataset holds the results of a basic MDX query (the queries come back almost instantaneously in the sample MDX app). The report also contains a very simple stored procedure call which returns only 1 row of data. Our problem is...

Hi, I have a table that contains a column of names. Some of the names in the table contain non-English names, e.g. contain accents and special symobols. I am basically wanting to write a query that will return me the rows where the name column contains characters that are not a-z and not A-Z...

Hi, I have a SCOPE definition in a measure script which looks like this: SCOPE([Location].[Location Idty].[All Location],Measures.[Iowa Sales Per Hr],[Units].[Units].[Actual]); .... .... END SCOPE; What this is saying is that if we are at the All Location level in the Location dimension...

..actually, i used the BINARY_CHECKSUM function available in sql 2k.

any ideas on how to go about doing this? I am a newbie to this kind of thing. Regards, MrPeds

Hi, I have an Int column in a sql 2000 database which states if the row is locked or not. if the row is not locked the column equals zero (0). Otherwise, if the row is considered locked I have been asked to set a checksum value for the column. I was thinking of using all the other columns in...

Hi, I'd like to know if there is a way of using a stored procedure to write the result of a query to a csv file. My application code will create the csv file if it does not exist and i am assuming that suitable permissions will be available on the file for sql server. What I would like to do...