Search results for query: *

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

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

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

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

Thanks for the assistance guys...

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

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

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

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

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

Just what I wanted. Thanks. Dave.

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.