Recent content by Snakeroot

Ahh, that makes sense. I got stuck looking at the problem from one angle. Thanks for the suggestion!

I searched previous posts and the FAQ, but didn't see anything about this. I have a table that is generated by a 3rd party software. The name of the second column is not static. It contains a date reference. For instance one time the column name may be FFEB07 and another time it may be...

I figured it out. I had to add -ExpandProperty Path, so the whole thing looks like this: foreach ($i in Get-WebApplication -Site "Default Web Site" | Select-Object -Property Path -ExpandProperty Path) { echo $i $url = "http://www.mydomain.com$i" echo $url $wc = New-Object...

I'm completely new at PS and I'm stuck. I feel like I'm right on the cusp of what I'm trying to do. Running Windows Server 2008 R2, IIS 7.5 in 32bit mode Here's my script: foreach ($i in Get-WebApplication -Site "Default Web Site" | Select-Object -Property Path) { echo $i $url =...

Thanks Mr. Denny. I'll check them out. Kodr: Reluctant to use GV yet since it's not deemed ready for business. Love GV for personal use though.

Is there any technology out there that would allow our corporate office to obtain local phone numbers in other states and have the ability forward incoming calls to those local numbers to cell phones (or any other phone really)? I know locally, we can go through our phone company and get a...

Sorry, I told you the wrong thing. The last group is actually by txnLineID, not WO#. This is a new process and I can tweak the input of the data. I'm wondering if it would just make more sense to include the Serial on both entries during the data entry, then do a join in SQL using the...

Without trying it, wouldn't that give me every other work order rather than every other record in one work order?

Grouping on a particular template, then on customer name, then on date of transaction, then on wo# On this particular template type, there are only the two types of records that I indicated earlier.

CR XI (11.5.11.1470) SQL Server 2008 I'm having a problem getting the exact result I'm looking for and could use some help. I have 5 fields: CSize, Serial, WO, RefT, Lbs I have two types of records that are being displayed currently: Cyl record and a Ref Record This is the current output...

This is in the select part: DATEDIFF(Day,CAST(dbo.AF_QB_Invoice.TxnDate AS datetime), '12/24/09') AS DaysSinceLastRental This is in the where part: WHERE (dbo.AF_QB_Invoice.TxnDate >= 'Jun 24 2009') AND (dbo.AF_QB_Invoice.TxnDate <= '12/24/09') AND (dbo.AF_QB_Invoice.TemplateRef_FullName...

That didn't work for me. It still shows the calculated date.

I have a few views that I'd like to see the original code, but when I edit the view it's showing the calculated date rather than the formula used to come up with that date. Is there anyway to keep SQL from processing the calculation so that I can just see the code? BTW, I'm using SQL 2008.

George! WOW! That cut down the time from over an hour to about 3 seconds. That's incredible! I really appreciate you taking the time to teach me how it works as well. I'm going to have to go through that several times so that it becomes familiar to me and then I can use it for other...

Don't forget that Windows 2008 has a firewall and it defaulted to on. That's usually the first thing I check when I "used to be able to do it on 2003." You can get to the firewall settings from the Server Manager under "Configuration".