Latest posts of: Stoic Joker - DonationCoder.com
Welcome Guest.   Make a donation to an author on the site May 25, 2015, 06:40:17 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2010! Download 24 custom programs!
   
  Forum Home Thread Marks Chat! Downloads Search Login Register  
  Show Posts
      View this member's profile 
      donate to someone Donate to this member 
Pages: Prev 1 ... 120 121 122 123 124 [125] 126 127 128 129 130 ... 212 Next
3101  Main Area and Open Discussion / Living Room / Re: Real SciFi Technology - a 3D-Replicator on: July 11, 2011, 06:31:50 AM
I guess they'd need to somehow scan the bones before the injury to make good copies.

Not really, they could either scan (assuming a limb) the other side and transpose it before "printing". Or possibly scan the remaining fragments, jig-saw puzzle them back together (in virtual), and then "print" the completed result. Either way the result would be far more accurate than the current breed of erector-set style ("adjustable") one size fits all options.

P.S. Sorry to hear about your mom.
3102  Main Area and Open Discussion / General Software Discussion / Re: Google+ on: July 10, 2011, 10:11:52 AM
If you want to follow me, I'm here. If you want an invitation, I'll send you one.

Don't know if I'll get anywhere but I'll try it.
3103  Main Area and Open Discussion / General Software Discussion / Re: can you recommend a free email system on: July 08, 2011, 03:54:53 PM
Check out Stallard Technologies - Dell PowerEdge 2800 (call and ask for Geoff - He'll work with Ya). They're a great company I've dealt with in the past many times. Exchange should run just fine on the machine at that link.
3104  Other Software / Developer's Corner / Re: My First Aussie Gig =D on: July 08, 2011, 03:45:00 PM
Hell, I haven't been in a suite since my wedding 20 years ago. Only had a tie on probably three time since then. I hate dressing up ... But I like freaking people out ... cause they never expect me to know what I do when they see me (until it's to late (hehe)).
3105  Main Area and Open Discussion / Living Room / Re: More ammunition why patents are EVIL on: July 08, 2011, 09:00:33 AM
Ah yes! My favorite Gallagher line was:
There is a brightness knob on the TV ... But it don't work!
3106  Main Area and Open Discussion / General Software Discussion / Re: can you recommend a free email system on: July 08, 2011, 08:57:44 AM
I've reached the point where the only SBS project I'm still willing to take on is migrating somebody off it.

ROFLMAO  Thmbsup
3107  Main Area and Open Discussion / General Software Discussion / Re: can you recommend a free email system on: July 08, 2011, 08:21:29 AM
Yes, it is Exchange 2003.  And yes we could just update the hardware, but I would also be inclinded to want to update Exchange as well if I was going to stay with that.  I have been told that some of the other mail systems will run on XP and they are not the memory hog that Exchange is.

Anything that has to deal with that many mailboxes, is going to need that much memory (which is cheap these days). I really don't see Exchange's usage as excessive. I've got several SMBs that run their Exchange & DC on the same box with only 4GB of RAM (and 20 or less mailboxes) that are doing just fine. Key is to be sure to put the Exchange mail store on its own partition to keep it from fragging C: to hell and back (that's one key point that will make, or break an Exchange deployment fast!).

SBS is a classic train wreck. Everything is on C: and DNS is borked, and the box goes tits up in a year ... Why??  wallbash ...I see this happen all too often.

Mail server running on XP!?! ...Oh the horror!
3108  Main Area and Open Discussion / General Software Discussion / Re: can you recommend a free email system on: July 08, 2011, 07:10:50 AM
(Yes I'm an Exchange fan...) Why not stay with Exchange and just update the hardware? Refurbed off-lease servers are fairly cheap, and it's not that hard to migrate if the install was documented well. Kinda like domain controllers, join the new one, promote it, sync it, and demote the old one, done.

...Granted I'm assuming Exchange 2003 here, I haven't tried the above with an Exchange 2000 server...So I can't guarantee it'll work.
3109  Main Area and Open Discussion / Living Room / Re: 64 Bit OS - When to Switch ? on: July 08, 2011, 06:56:05 AM
The only compatibility issues I have come across are clients with ancient peripherals (usually printers and scanners).

Add to the the kernel/user mode drive debacle and you drop even more devices on the x86 editions also. I don't know if it's laziness, greed, or both on the part of the manufacturers...But I'm getting tired of having to have that conversation with people because their 2yr old high dollar print device just flat don't work on their new machine. Mac ain't exempt either, their (probably the worse) compatible devices list isn't much more than a single page long these days.

Go to any manufacturer's site these days and try to find a 32-bit machine, it ain't easy. Or even possible for some unless by special (phone in and beg) request.

The only reason I didn't do a full-time switch to XP x64 back when was I couldn't bear to part with TClock ... But that got fixed shortly there after... Wink ...The instant I had a semi-stable alpha (carrot, stick...) I made the switch.
3110  Main Area and Open Discussion / Living Room / Re: More ammunition why patents are EVIL on: July 08, 2011, 06:36:23 AM
George Carlin (and I) agree with you, which is particularly apt today!

Amen to that! I have long maintained that George Carlin was the only true sage of the 20th century. He forced us to look at things (and ourselves) for what they really are...and not what we believed, or wanted them to be.
3111  Main Area and Open Discussion / Living Room / Re: More ammunition why patents are EVIL on: July 07, 2011, 07:56:36 PM
As for the term "Big Pharma", yeah, I don't much like it either, but it was already brought up. It does sound a tad nutty.

*Shrug* If the shoe fits...
3112  Main Area and Open Discussion / Living Room / Re: 64 Bit OS - When to Switch ? on: July 07, 2011, 07:51:45 PM
I have been using Vista x64 and Win 7 x64 for years now.

Same here, performance, compatibility, all good.
3113  Main Area and Open Discussion / General Software Discussion / Re: Google+ on: July 07, 2011, 12:58:02 PM
According to a couple of German websites, some profiles with an obviously faked name were removed.

Well that sucks, I really don't want to use my real name online. Nor will I (it's boring). Sure the G+ thing is a bit tempting to try - for the hell of it - Mainly because I completely ignored the last 500 fads... But I'll not be signing up with anything close to what it says on my drivers license.

+1 with that. A Google and Bing search of my first/last name returns a grand total of 6 valid hits.

Shit, I just ran my name through Bing, and it says I'm a Photographer from Austrailia...??
3114  Main Area and Open Discussion / General Software Discussion / Re: Data Recovery for SCO OpenServer on: July 07, 2011, 11:44:00 AM
I'm with ^them^ ... Don't chance making it worse.
3115  Main Area and Open Discussion / General Software Discussion / Re: Google+ on: July 07, 2011, 11:40:06 AM
According to a couple of German websites, some profiles with an obviously faked name were removed.

Well that sucks, I really don't want to use my real name online. Nor will I (it's boring). Sure the G+ thing is a bit tempting to try - for the hell of it - Mainly because I completely ignored the last 500 fads... But I'll not be signing up with anything close to what it says on my drivers license.
3116  Special User Sections / N.A.N.Y. 2012 / Re: NANY 2012 Pledge: De-stress on: July 06, 2011, 11:25:20 AM
Okay, I'm intrigued (Stressed, burned-out, and on the verge of cracking).

What'cha got??

3117  Other Software / Developer's Corner / Re: SQL Query is Kicking my Ass. on: July 06, 2011, 08:18:41 AM
Occam's Razor anyone?

The answer was simple, after I got the question right.

Formatted for SQL with the GeSHI Syntax Highlighter [copy or print]
  1. SELECT ClientID, PC.SerialNo, PC.ModelName, CurLocation, Max(TimeStamp) AS LastValidCount
  2. FROM PageCounts PC
  3. INNER JOIN Printer_Inv PiX ON PC.SerialNo = PiX.SerialNo
  4. WHERE PiX.Active = 1 AND ClientID = 'Client X' AND TotalPP > 0
  5. GROUP BY PC.SerialNo
  6. ORDER BY LastValidCount DESC, CurLocation
  7. LIMIT 0, 300
3118  Other Software / Developer's Corner / Re: SQL Query is Kicking my Ass. on: July 06, 2011, 06:48:18 AM
Now I'm not an expert, but it seems because you need the last date from a bunch of non zero pagecounts, but you also need values from a bunch of zero pagecounts, that you have to do a subselect to get the max date and other information from the zero pagecounts data and then reuse that in your main query. smiley

That's about where I got too. Unfortunately the passing values between queries thing just isn't cooperating. I could resort to bolting this thing to a web page and just doing the subquery in the result set's while loop processing ... But I really wanted to keep this as a single free standing SQL query script so it could be dumped to Excel quickly.

So if that means you're back in the "nested select" performance problem then perhaps it's worth restructuring the data if possible, or wait for someone with better knowledge to help you out cheesy Google for subselect alternatives

...That's why I'm here... smiley ...Google just got me into the joins fiasco. Restructuring the data is not an option as it's tied into/used by more than one of our internal billing systems (can U say Ripple Effect..?  cheesy). There has got to be a simple answer for this...I just haven't stumbled across it yet.
3119  Other Software / Developer's Corner / Re: SQL Query is Kicking my Ass. on: July 05, 2011, 01:34:45 PM
Take out the #7 Having clause and run the query.  
Is this the subset that you want the "max" timestamp to be chosen from?

Okay, I take this to mean: When looking at the output, how do I know it's wrong? ...Which is actually a hell of a good GD question, now that I think of it ... Or rather, now that you asked me to think of it. Wink

Now here's the weird part. Most of it ain't. Here's an updated version of the query as just used for above:
Formatted for SQL with the GeSHI Syntax Highlighter [copy or print]
  1. SELECT Pc1.ClientID, Pc1.SerialNo, Pc1.ModelName, PiX.CurLocation, Pc1.TotalPP, Pc1.TimeStamp
  2. FROM PageCounts Pc1
  3. INNER JOIN PageCounts Pc2 ON Pc1.SerialNo = Pc2.SerialNo
  4. INNER JOIN Printer_Inv PiX ON Pc1.SerialNo = PiX.SerialNo
  5. WHERE Pc1.ClientID = 'Client X' AND Pc1.TotalPP = 0 AND PiX.Active = 1
  6. GROUP BY Pc1.SerialNo, Pc1.TimeStamp HAVING Pc1.TimeStamp = MAX(Pc2.TimeStamp)
  7. ORDER BY Pc1.TimeStamp DESC
  8. LIMIT 0, 300

This produces a data set of the correct size...and with the correct items. The problem is the dates are "wrong". Sure they're what I asked for ... But that's not (exactly...) what I meant (to ask for) ... And computers are of course basically shit for interpretation. (...Oops!)

So here's how I got ^^there^^. I was (assuming) looking for a data set size somewhere in the 30's, so when I kept getting 80's it looked/felt/appeared "wrong" ... Which it would have indeed been (wrong) if I hadn't just created another bill last Friday which contained 80 something devices with absent page counts.  wallbash

So here's the - Newly updated with correct-er information - fun part. The date column (actually) needs to reflect the date of the last non-zero value. I went with max to get the latest info. because the table contains the complete billing history. So I didn't want to have any old zeros surfacing if they'd been "washed" by a valid, more current, non-zero count. However I do need this report query to show how (far back) long its been since device X has had a valid count retrieved from it ... So we can look into the why who is most guilty of (zero count) silence.


I think it's where the issue lies when you try to bring PC2 timestamp into the picture.  If it is then at least you can try the other methods (sub queries, temp files, etc) you've tried to see if it get's the one "max" timestamp from your subset.

No that part - Best I can tell - is Okay ... I was just on the wrong end of the problem. Wink

Thank you!
3120  Main Area and Open Discussion / Living Room / Re: Lots of New Members on: July 05, 2011, 11:07:07 AM
i don't get it.  huh

(playing off laser) Lazar, as in Lazarus: Popular back-from-the-dead guy in the bible. Wink

3121  Other Software / Developer's Corner / Re: SQL Query is Kicking my Ass. on: July 05, 2011, 08:40:38 AM
Take out the #7 Having clause and run the query. 
Is this the subset that you want the "max" timestamp to be chosen from?

I'll have to get back to you on that ... I gotta be on-Site here shortly.
3122  Other Software / Developer's Corner / Re: SQL Query is Kicking my Ass. on: July 05, 2011, 08:38:48 AM
Um... Perry? I may have translated the query incorrectly. The below modified version held a pair of 3.0GHz Xeons at 25% usage for 10 minutes (with no output in sight) ... So I gave up (had to) and killed it. Table's only got 20,000 lines in it. So I'm guessing something is awry (or you've got some seriously fast hardware).

Formatted for SQL with the GeSHI Syntax Highlighter [copy or print]
  1. SELECT DISTINCT
  2. Pc1.ClientID,
  3. Pc1.SerialNo,
  4. Pc1.ModelName,
  5. Pc1.TimeStamp
  6. FROM
  7. PageCounts Pc1
  8. INNER JOIN PageCounts Pc2
  9. ON Pc1.SerialNo = Pc2.SerialNo
  10. AND Pc2.ClientID = 'Client X'
  11. AND Pc1.TimeStamp = (
  12. SELECT MAX(TimeStamp)
  13. FROM PageCounts
  14. WHERE Pc1.SerialNo = SerialNo
  15. )
  16. ORDER BY Pc1.TimeStamp DESC
3123  Main Area and Open Discussion / Living Room / Re: nearby lightning skrike kills neighbours computers (and mine) on: July 05, 2011, 07:03:30 AM
@nudone - I feel ya man - venting thread - been there after a lightening strike myself. smiley

@westom - You really need to take into consideration that there is a lot of specialization in IT. Your skillset corner of the world is not the same as everybody elses. Soften your tone a bit and you'll get much better responses.

---------------------------------------------------------

That being said, I do have to agree that in this type of situation the best usage of $100 going forward is to hand it to an electrician to investigate how well ones dwelling is actually grounded. I did my own investigating back when (because I can), and did find a few things what needed attention.
3124  Other Software / Developer's Corner / Re: SQL Query is Kicking my Ass. on: July 05, 2011, 06:43:59 AM
Have you tried using temporary tables? Joins can be very expensive. (Sorry -- I'd love to jump in and help more, but need to run out the door.) Multiple queries can sometimes help.

My understanding was that joins were less expensive than nested selects, so I went that route to keep the server from racing itself to death (had to kill it a few times). This isn't for something that has to be done frequently by multiple users. It's a one-shot report that has great potential to be useful going forward on a ~monthly basis. So if it took a few minutes to run...That's Okay...If it comes up with the right answer.

OTOH, if it could be done quickly, no-one would complain... Wink

Haven't tried temporary tables yet, but I have been slowly resigning myself to the possibility of their need. In a nutshell, the downside of being completely self taught, is that when you're stuck, you are stuck... smiley (e.g. I'm stuck'ed)


@Perry - At this point I'm game to try anything. I'll try your query later today and see what happens. Hopefully it'll give me a data set that's a bit less hellter skelter than what I have been getting.
3125  Other Software / Developer's Corner / Re: SQL Query is Kicking my Ass. on: July 04, 2011, 11:55:46 AM
It's very hard to help you without seeing an example database, but I think the problem is between line 5-7.
If you look at the
documentation on group by / having you see Having is used as a where on groups.

Having is something I just ran across the other day while Googling for an example of how best to get a list of max(dates) out of a table during/using a self join. So given that it has yet to create a result set that made complete sense it's quite likely I'm using it wrong...or expecting it to do more than it actually does (hell if I knew what I was doing I'd probably be done by now... (hehe)). Also that's just one of a multitude of things I tried none of which worked properly.

Not sure how well this will paste, but here's a small (cleaned) piece of the table's content.
Formatted for SQL with the GeSHI Syntax Highlighter [copy or print]
  1. INDEX  SerialNo ModelName ClientID   CurPageCount  OldPageCount   TimeStamp   TotalPP
  2. 29 CNBM044207 3380 mfp MIKLA01 2404 26 2005-10-27 09:04:17 2378
  3. 9 USLH039092 1100 CRITR01 39339 38834 2005-09-29 11:47:17 505
  4. 10 CNDIF23087 1160 CRITR01 7947 7632 2005-09-29 11:47:17 315
  5. 30 USBNL12704 4200 MIKLA01 199451 193626 2005-10-27 09:04:17 5825
  6. 12 CN09506649 4300 CRITR01 401922 383635 2005-09-29 11:47:17 18287
  7. 13 JPCG012675 4v CRITR01 449756 449206 2005-09-29 11:47:17 550
  8. 14 USBB019753 8000 series CRITR01 844310 839591 2005-09-29 11:47:17 4719
  9. 15 USBB020920 8000 series CRITR01 760125 756990 2005-09-29 11:47:17 3135
  10. 16 U61036C5J482752 Brother MFC8840D CRITR01 3271 2314 2005-09-29 11:47:17 957
  11. 18 USBB031505 3100 fax SNIFFERT_B 167316 167316 2005-10-02 11:47:23 0
  12. 19 USCC000104 4050 UFORA03 258810 255488 2005-10-04 08:50:26 3322
  13. 20 JPJB002010 Color 8550 series ECODE01 162675 160416 2005-10-18 16:27:32 2259
  14. 21 USLH039092 1100 CRITR01 39945 39339 2005-10-19 08:52:25 606
  15. 22 CNDIF23087 1160 CRITR01 9131 7947 2005-10-19 08:52:25 1184
  16. 24 CN09506649 4300 CRITR01 426537 401922 2005-10-19 08:52:25 24615
  17. 25 JPCG012675 4v CRITR01 450190 449756 2005-10-19 08:52:25 434
  18. 26 USBB019753 8000 series CRITR01 848516 844310 2005-10-19 08:52:25 4206
  19. 27 USBB020920 8000 series CRITR01 768063 760125 2005-10-19 08:52:25 7938
  20. 28 U61036C5J482752 Brother MFC8840D CRITR01 4225 3271 2005-10-19 08:52:25 954
  21. 31 USSC016017 4000 series OCLAD01 124823 124164 2005-10-27 13:25:31 659


I'm still not really sure what you want because the query you are posting is not the same as your description of the query in the starting post.

The relevant part is. There are just some other (device specific) values being pulled in from another (PiX) table.

Your query is trying to search for a Client that is Active where the billing date from pc1 historyical information is identical to the last billing date from some other place (pc2), then grouping by printer and timestamp. It doesn't make sense.

I had a feeling that might confuse thing, which is why I didn't lead with it. Just ignore all the PiX.* stuff. It's only verifying that the device with SN X is "active" to thin out the data set.

Also to me it's not clear how Pc2 is related to pc1 tongue in english? Without being clear how you want the query in english noone can translate that to SQL. hope that helps

Hm... (a bit sketchy on that myself), Best I can tell table is joined to itself on SN so that each SN can be searched for/aligned to its maximum date with a TotallPP of 0.

I'm at a point where the more I look at it the less sense it makes (forest for trees??) even after taking a break.
Pages: Prev 1 ... 120 121 122 123 124 [125] 126 127 128 129 130 ... 212 Next
DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.124s | Server load: 0.04 ]


Share on Facebook
submit to reddit