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 Chriss Miller 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: *

  1. Big0range

    Show 0 value as result of 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...
  2. Big0range

    Show 0 value as result of query

    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??
  3. Big0range

    Show 0 value as result of query

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

    Show 0 value as result of query

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

    Show 0 value as result of query

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

    Show 0 value as result of query

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

    Show 0 value as result of query

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

    Show 0 value as result of query

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

    Show 0 value as result of query

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

    Show 0 value as result of query

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

    Show 0 value as result of query

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

    Home Edition - Need to connect to a network Domain

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

    Recovering CD- & DVD-ROM Drivers

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

    Recovering CD- & DVD-ROM Drivers

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

    NT4 &gt; 2003 upgrade, upgraded PDC not new DC

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

    NT4 &gt; 2003 upgrade, upgraded PDC not new DC

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

    How to connect workgroup computers to Domain through VPN for Exchange?

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

    Using DCPromo

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

    How to connect workgroup computers to Domain through VPN for Exchange?

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

    How to connect workgroup computers to Domain through VPN for Exchange?

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

Part and Inventory Search

Back
Top