Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dibbo
  • Order by date
  1. dibbo

    Unable to connect to SQL server since going wireless

    apologies, I should have mentioned this in my original post. yes I've tried that aswell to no avail...
  2. dibbo

    Unable to connect to SQL server since going wireless

    firewall on the router is not activated. i tend to think it's not something as a fellow colleague can view the clients via his enterprise manager. Therefore would think it is a setting on our local machine. not sure whether it is related to our local wireless cards or IP setup or subnet...
  3. dibbo

    Unable to connect to SQL server since going wireless

    Hi, thanks for the response. yes can ping by both device and ip.
  4. dibbo

    Unable to connect to SQL server since going wireless

    Hi, a bit of a strange one. A number of our SQL server clients have been put on to a wireless network, since this has happenned 2 out of 3 administrators are unable to connect to the client servers via Enterprise Manager. further info: We can ping the clients by both device name and IP. The 2...
  5. dibbo

    Strip time from datetime value

    Thanks for the assistance guys...
  6. dibbo

    Strip time from datetime value

    I'm writing a query that pulls back various values, with one being a datetime value i.e. 2005-04-08 07:29:26.000 (dbo.tblScans.Scan_DateTime) How do I strip the date off just to leave the time? been looking at the convert function but can't get the correct syntax.. TIA
  7. dibbo

    Increment week function starts on Sunday

    sorted.. replaced SH_StartDateTime with DATEADD(d,-1,SH_StartDateTime)
  8. dibbo

    Increment week function starts on Sunday

    Hi, i've got the following code in a query: DATEADD(wk, DATEDIFF(wk, 0, SH_StartDateTime), 0) it works ok in the way that it returns: 08/11/2004 08/11/2004 08/11/2004 15/11/2004 15/11/2004 15/11/2004 22/11/2004 and so on.... The 8th, 15th and 22nd being Monday's But for some reason it's...
  9. dibbo

    How to find out the start date of the week

    sorted it.. While Weekday(givenDate) <> 1 ' While not Sunday givenDate = DateAdd("d", 1, vRetVal) ' Go forward 1 day Wend
  10. dibbo

    How to find out the start date of the week

    just to give you a summary of what i'm trying to achieve - a user selects a date range of 10/10/2004 to 10/11/2004. now the data returned needs to be grouped by 'week', but I don't want to group 10-16, 17-24 etc. I want to find out what day the 10th is e.g Thursday and then group Thurs til...
  11. dibbo

    Create Unique ID in Temp Table

    Just what I wanted. Thanks. Dave.
  12. dibbo

    Create Unique ID in Temp Table

    I am performing a SELECT.... INTO #TempTable, which works fine. However, the rows aren't unique so i'm wanting to introduce a unique ID into the first column. Is this possible, if so how? TIA Dave.

Part and Inventory Search

Back
Top