Recent content by zeuz

I never have used union all before, but it works perfectly. Your query, which now looks a lot nicer than mine, returns the exact rows that mine does. Looking at the estimated execution plan, your query has a cost of 2.32, mine has 2.18. close enough that it makes no difference to me. This...

Andel You query lists all the previous occupants of every bed, a combined total of 17330 rows. It needs to be only the previous occupant of beds that are currently empty, or no name but still with the bed if there's never been an occupant in that bed. gmmastros Your query is again almost...

The following is ALMOST accurate, I just got to this point. I forgot one table in the chain above, to get from bedusage to client there's a serviceused table inbetween as shown in the query below select lastname, firstname, bedname from bed left join bedusage on bed.bedid = bedusage.bedid...

I'm a little out of practice on my SQL and I've been asked to create a query on a database that I can't figure out. It's a hostel and the database is room (well, all client record) tracking. There's a Table for Beds (500 rows) BedID bedname etc. Then there's a BedUsage table (18,000 rows)...

I use a utility called USBDLM http://www.uwe-sieber.de/usbdlm_e.html it actually allows you to set drive letters based on criteria as well. ie any key over 64MB can be assigned to F:. a drive with the volume name of 'MYDRIVE' can always be B: etc.

it's a question of cost. I work for a charity and we have the 2612 already sitting here doing nothing.

My setup is as follows: PIX 506 \ hub - DSL modem. PIX 506 / Each Cisco PIX has to retrieve their IP via DHCP (Telus as the ISP calls DHCP reservations 'static') If both PIXs were on the same subnet they would be able to communicate directly to each other, however this is not...

if it's a numeric field you're working with it's likely easier and possibly even a lot faster to do it mathamatically. select FieldName from TableName where (FieldName % 100 - FieldName %10)/10 = 4

Wish I could offer more then a vague guess on this one, but here goes. I don't see any routes set up in the posted config. Mostly you'll only need 1 route command that can handle all traffic and it'll likely look something like this: route outside 0.0.0.0 0.0.0.0 XX.YY.XX.YY Use the...

your ip pool for the pptp clients cannot be the same as the inside subnet try changing ip local pool vpn_ip_pool 10.0.0.230-10.0.0.254 to ip local pool vpn_ip_pool 10.0.1.230-10.0.1.254 or something similar. It's been a while since I set up PPTP on my firewalls, so don't recall it all, but...

My syslog logs the full domain name. The thing that makes the difference is having a WORKING url filtering software running. n2h2 or Websense. For example: Feb 10 11:10:28 172.16.1.1 Feb 10 2005 11:10:26: %PIX-5-304001: 172.16.1.13 Accessed URL...

you can do this without much difficulty. Though if you do have access to modify the router and do as iproute suggests then his way is the way to go. if you don't need the router, or don't have access to the router config, then this may be the way to go. basically you do a static mapping for...

Mystery solved - Call tracking software was recording this as a completed call. It assigned a cost to the call, but the calls only had a duration of about 6 seconds so they must have been blocked. However the software doesn't know it was restricted. Raw data dumps are a lot more useful then...

1010220 should be blocked by the generic block which I have for anything that starts with a 1 - (allows 1800, 1888, 1877, 1866) 411 is also blocked so is any of the * codes that could give another dialtone (*67, etc) As I said before, some of these people using the phones are being VERY...

On what I believe to be a MICS 4.1 system I need to be able to block operator calls from certain extensions. They are public use phones so the people using them can be quite creative at getting past restrictions. I've blocked calls beginning with a 0 but somehow they still get through. Long...