Search results for query: *

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

Fair enough :) Here's the needed info: CylinderDepositsView CDSerialNum CDCustName CDInvoiceNum CDTxnDate IsPaid CDTxnLineID CDFranchise 42051C AMI 29356CD 4/22/2009 1 20351-1240578902 C 45367C ASHAC 33001CD 1/19/2009 1 40DC6-1232565201 N 51477C AMS 33037CD 3/4/2009 1...

Thanks for the suggestions George. I updated statistics, but there's still something else going on. I ran with client statistics to see if that might be helpful. Here's the result on the 2000 machine: Application Profile Statistics Timer resolution (milliseconds) 0 Number of INSERT...

I have an MSDE 2000 database with several databases and stored procedures that I've duplicated onto a new server. The new server is Windows 2008 R2 running on VMWare vSphere 4. I've loaded SQL 2008 Standard SP1 onto this VM and copied all of the databases and stored procedures from MSDE 2000...

Before you undock, drag the crystal reports window to your laptop screen, then close the program. It should open back up on your laptop.

Have you looked at the FAQ's? Take a look at this one in particular: http://www.tek-tips.com/faqs.cfm?fid=6519 Using the function in the FAQ, you'll need to pass in the number of seconds between two datetime values. To get the number of seconds, you can use this: Select...