Search results for query: *

Hi All, I wonder if you can help. I had to reinstall windows 2003 server on my pdc as it would not boot. This went all fine and DNS, Active dir, and DHCP was installed. Added all my user accounts back in and this is the problem i have. I cannot write to a shared directory with all my users docs...

Below is some working part of my current sql. What i would like to do is have a date parameter in RS 2000 which will be the most current saturdays date say 14/10/06 then where i have hardcoded the dates below do some kind of dateadd - 7 thing to dynamically replace the dates in the case things...

Hi All, How do i delete current rows in a excel sheet from say row 8 downwards before loading in my ADODB.Recordset from a fresh query Kind Regards Dave

Hi All, Dont know if this is a excel or sql issue so here goes Got a excel sheet pulling data from a sql table, no prob there. In the ms query i order my results by a field with a number in but it shows the numbe 1(one) below say number 10(ten) why would this be. I can get around this by...

Hi All, Whits end, a million searches here and google :-( How do i connect to and update 1 (one) field in a sql server table with the data in 1(one) field in my spreadsheet. I have got the date from sql server into my spreadsheet and now i want to simply send changes in my one field back to...

Hi All, Sorry if this is in the wrong place. I have a excel sheet that pulls data from a sql 2000 table. I want to update 1 field and send the update back to the sql table. How do i do this ????? SO if i update my field in excel from say a number "1" to a number "2" how do i send the update...

Ver new to SQL and trying to get this right. I am using Reporting servcies 2000 to try and make a week by week total report. I have this sql at the moment cobbled together from various websites. SELECT customer AS Cust, CASE WHEN dated >= '09/10/06' AND dated <= '09/16/06' THEN...

Hi All, I have an RS 2000 server that works fine inside our internal network. We have a remote office that users login to out network from, and this works but they cannot get to our RS server. They are setup as members of domain users, but i have a feeling that the ip scope for our remote...