Search results for query: *

Hi I've been trying to figure out how to dynamically set my server connection for the webservice. I have been able to set this connection on the webpage (it is set in a text file which the page goes through and extracts the server name). I am unable to get the same right with the webservice...

Hi I've got a standard VS datagrid (I'm developing in visual studio 2003) and I've converted a few columns to template columns and replaced the labels with textboxes for input. The tab navigation moves from left to right, but I would like the users to be able to navigate through the cells with...

Thanks for the reply Frederico- I don't think I posted the first post clearly- you mention the following: "As an apart make sure you have clearance from both HR and your top managers regarding accessing real salary data. This area is always a can of worms." My problem is exactly this-...

Hi I am currently working on an appplication (ASP.Net front end, with SQL Server 2000 DB). the problem I have is that I need to pull in the companies salary information , which includes employee numbers and names. How would I go about locking myself out of this information, given that I am the...

Thanks to both of you for your help- much appreciated. I've managed to get it working. :)

Hi I am fairly new at VB and ASP.NET and have been trying to edit items on a grid. I have managed to create editable columns or editable rows, but I cannot control it any further than that. What I am trying to do is the following: For example say we have a 10 column by 10 row grid. I would...

Thanks for the input- was hoping there was some way to do this easily, but I guess I'll try and normalise and write an update to the other tables. Thanks.

Hi I am trying to figure out a way to perform basic operations between rows, which would be best demonstrated using an example: Key Name P01BY P02BY P03BY 1 Volumes (Current Year) 10 20 30 2 Net Revenue (CurrentY) 10 20 30 3 % New Business Volume 0.5 0.2 0.5 4 New Business...

Hi I am fairly new on the admin/setup side of Microsoft SQL Analysis Services. I have just installed Microsft SQL Server 2000 and the Analysis Manager that comes with it. I have created a new database in the Analysis Manager and used a database from the SQL Server I am running and tested the...

Hi I am fairly new on the admin/setup side of Microsoft SQL Analysis Services. I have just installed Microsft SQL Server 2000 and the Analysis Manager that comes with it. I have created a new database in the Analysis Manager and used a database from the SQL Server I am running and tested the...

Hi In SQL Server 2000, and the DTS package designer, if I select the property of a transformaion task (a simple table export between 2 servers) it hangs for about 3 minutes before opening- I did not have this problem on my older PC (a celeron 2 gig with 500meg RAM). I have just installed on a...

Thanks for the quick replies- I'll test these out now.

Hi I was wondering if anyone knew a way of updating a field with the number of rows that were updated by a specified query. For example if I run an update query in query analyzer and it returns "2000 rows affected by query"- is there anyway for me to update another table with that value (2000)...

Hi Wondering if anyone can help with this- I''ve just installed SP2 for WinXp Pro and enabled the firewall- It's just Set to "On", not "Don't Allow exceptions". The problem I am having is that I cannot send or receive "Net send"'s anymore. can anyone tell me what to disable on the firewall to...

Hi I've got a huge (couple of million rows) table with a field called 'Main_Name' which is essentially the surname(last name) field- what I would like to do is display all the rows where Main_Name does not have any alphabetic characters eg where the field is equal to '^54' or '.,.;' i'm a bit of...

hi thanks all for the replies just an update- i tried both of the new methods- the (LIKE '%[^0-9]%') didn't seem to work at all, but nigelrivett's (patindex('%[^0-9]%', col) = 0) worked perfectly. thanks for pointing out the flaw in isnumeric.

thanks so much amorous- worked like a charm. :)

Hi I am trying to filter a query to exclude any rows where the Identity Number field has any alphanumeric (not sure if this is the right word) values in it. eg: i would want to exclude rows where the Identity Number field is '123fgh345' or 'sdf123456' only keeping rows where there are numbers...