Search results for query: *

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

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

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

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

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

Hi Not sure if this post is in the correct forum as it seems to cross admin / programming, so apologies in advance. I currently have a huge table (28 million rows) with address information for all the UK. the columns contained in it are things like house number, street, town, county and POst...

Hi, I have the following XML fragment that I am trying to get information from using MS xml dom in Javascript methods: <Goals> <Goal id="123"> <someELement1/> <someElement2/> <myTargets myAttr1="567" myAttr2="909"> <myTarget> <myTargetID>21</myTargetID>...

Hi, I've been asked to design a database for a customer who wants to make their database searchable via the web by using free form text entry. The database contains information about night-clubs in different countries and in different cities. The database will be sql server 2005. A typical...

Hi, Is it possible to increase the value of a xsl variable in a stylesheet whilst i am looping around some elements? What I mean is if i do something like declare a variable: <xsl:variable name="myVar"/> Can i reference this in my loop and add to it, e.g. by adding the value of another...

Hi, I'm a newbie to XSL, so was hoping that somebody could easily see the answer to this: I am trying to write an XSL style sheet to build an html dropdown list. The list contains simple name-value pairs. The only extra requirement i have is to set one of the options to be 'selected' based...

Hi, I have some code set up on a textbox to try and prevent the user from trying to enter data elsewhere if the textbox is invalid. e.g. <input type="text" id="i1" onchange="test(this)"></input> .. test(ele) { if(ele.value=="" || ele.value ==null) { alert("error"); ele.focus()...

Hi, Another newbie question please. I have an HTML table that contains a number of checkbox's, each checkbox has a unique value. I also have a textbox on the page as well. Basically, i am trying to think of a way of appending the value of the checkbox to the textbox. Similarly, if the...