Search results for query: *

Wierderer and wierderer. At least it's not so easy I feel like a total idiot for not figuring it out. Output is still wrong - here's the first 50 rows: 8 1 8 85 9 1 9 227 10 1 10 266 11 1 11 254 12 1 12 195 13 1 13 233 14 1 14 217 15 1 15 213 16 1 16 164 17 1 17 56 18 1 18 28 8 2 8 66 9 2 9...

Well, I didn't want to bug you further, but I can't find where to make the change to d2.id. A little help??

Still not quite there, same problem as before. Here's the output: NULL 0 0 0 NULL 0 0 0 NULL 0 0 0 NULL 0 0 0 NULL 0 0 0 NULL 0 0 0 NULL 0 0 0 NULL 0 0 0 NULL 0 0 0 NULL 0 0 0 8 1 8 85 9 1 9 227 10 1 10 266 11 1 11 254 12 1 12 195 13 1 13 233 14 1 14 217 15 1 15 213 16 1 16 164 17 1 17 56 18 1...

Okay, I used your earlier script to create a table of dates called "days" from 1 - 31. The following is at the beginning of the query: select h.id,coalesce(DayPart,0) as Date,coalesce(Hourpart,0) as Hour ,coalesce(Countpart,0) as Data from (select datepart(dd,DateTime) as DayPart...

Here are the first few rows of the results: 1 0 0 0 2 0 0 0 3 0 0 0 4 0 0 0 5 0 0 0 6 0 0 0 7 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 24 0 0 0 8 1 8 85 9 1 9 227 10 1 10 266 11 1 11 254 12 1 12 195 13 1 13 233 14 1 14 217 15 1 15 213 16 1 16 164 17 1 17 56 18 1 18 28 8 2 8 66 9 2 9 180 10 2...

Tricky, tricky.... The sorting is now back in order, although it starts out with 13 rows of 0s except for the id column that appear to be sorted by the number in the id column. Those rows do not list a date or time, just 0s. Where I would need a 0, particularly for the 19th hour, is nothing...

A ha... Got a table called hours, query runs fine. I'm getting back now four columns instead of three: the first is id, the second appears to be date, the third hours, and the fourth the needed data. Sorting is the next big hurdle - it used to sort by Day 1, hours 8-19, Day2, Hours 8-19...

Esquared, I tried you first and had the same result (hours with no or 0 data not being included in the output table). SQLDenis (heeyyy... there's just one n in your name!!) - I tried yours second and got: Invalid object name 'hours'. I'm looking at the logic to see if I can figure it out...

Great idea - Here's the query: select datepart(dd,DateTime),datepart(hh,DateTime),count(datepart(hh,DateTime)) from Table1 where DateTime >= '2005-12-01 00:00:00.000' and DateTime < '2006-01-01 00:00:00.000' and datepart(hh,DateTime) between 8 and 19 and datepart(dw,DateTime) BETWEEN 2 and 6...

Sorry, I'm a SQL idiot. I'm a networker easing into a new work situation involving pulling reports from a SQL database. I've heard the term "left join" and read the word "coalesce" once in a novel (but I do know the definition!) How would one put the terms into action in a SQL environment...

Howdy. I have a couple of queries I run, whereby I take the results and paste into a spreadsheet. The data returned by the query is broken down by hour. If there is no data for the hour, I would like to see a 0, but the query does not return anything at all. I then have to copy data to a...

I've seen third-party software advertised that is supposed to overcome the no-domain limitation of XP home. Do a search for "XP Home" and domain and see what you can find. I can't attest to it's reliability or functionality.

Deleted the registry key, still a no-go. Same message upon attempted hardware install at system start - "cannot find the software" to install the hardware. Seems I'm missing or have the wrong file(s) somewhere...

I recently installed a software package that took the liberty of "updating" my CD and DVD device drivers. Now, neither drive works. They are recognized by Windows XP Pro at startup, and Windows tries to install the "new hardware". However, it is unable to find drivers for either drive, even...

The domain is a live, public domain. I'm trying to perform the upgrade in place, side-by-side along the existing servers.

I'm upgrading an NT domain to 2003. I have a machine I've built specifically to be the upgrade machine (Once the domain is upgraded, I have all-new servers I'll incorporate). I've installed NT4 as a BDC, run SP6a, promote to PDC, run the 2003 upgrade from the CD. After upgrading the OS, I can...

How did that file transfer time compare to opening the same file via email? You may not have a problem if problem other than connection speed if the times are similar. It sounds like you just have a slow connection if it takes a minute to transfer 54kb. If your email clients are reaching the...

Don't put Exchange on a DC, you can't manipulate the DC as much without breaking Exchange (as you've seen). Even for testing, you'll get potentially flawed results.

don't use pcAnywhere, do a file transfer by opening a path with the unc (\\remotecomputer\C$). Email a file then transfer the file via unc, see how close or far apart the times are. You should have all your clients resolved by DNS, and managed in the same zone Exchange is in.

Sounds like the Exchange-thru-VPN setup is working fine. The remote users have to allow time for the entire email to download. If they are connecting through slower or more troublesome methods (dial-up, ISDN, or DSL), there's probably a bandwidth issue, or some packet loss is being experienced...