Search results for query: *

I ran my select statements with Execution plan turned on and here's what I got... What I ran... SELECT DISTINCT Ord_no AS Ord_no, Shipment AS Shipment from wspikpak where shipped='Y' AND ship_dt = DATEADD(Day, DateDiff(Day, 0, GetDate()),0)...

That makes perfect sense! Please go on.

Sure, I'd appreciate the help. I actually didn't write the script, our former IT Manager wrote it, I just kept using it. I can see how it could cause a problem and it definitely would be based on how the data is.

That worked! The only change I had to make was that UPDATED has to be UPDATE for MS SQL. Thank you!

Hi All, I'd like to run the following script... CREATE TABLE tbl (Ord_no Char(8), shipment Char(30)) insert into tbl SELECT DISTINCT Ord_no AS Ord_no, Shipment AS Shipment from wspikpak where shipped='Y' AND (DATEDIFF([day], ship_dt, GETDATE()) = 0) update o set O.user_def_fld_5=T.shipment...

That worked great! Thank you so much!

I figured it out, our DNS record (_VLMCS) was set to a server other than the proper KMS server, I changed it to the correct server and all of the clients self activated.

Here's my dilema, I've got data that looks like this... Shipment Ord_no Line_no Item_no Loc Qty Pallet Carton ------------------------------ -------- -------...

You guys are awesome, thank you!

Hi all, I'm working on creating a crystal report that needs to pull a piece of data from a long string, here's an example... [Header] PlanRelease=0 ReleaseNbr=20111021 [Main] TS=DELFOR HaveShipDate=TRUE HorizonEnd=20141231 HorizonBegin=20080212 [Address] SU=G0143 ST=OMITTED...

Hi All, I have about 35 clients running Office 2010 and have a Server 2008 R2 box running as the KMS server. I have created an installer package using customization tool telling it to activate via KMS. However all of the clients are telling me they can't activate. If I go and run ospp.vbs, set...

Thanks markros!

I've got a table that contains orders that have shipped. What I'm trying to do is sum the total price of all the orders with a back order quantity within three date ranges, this week, last week, and two weeks ago and group them by customer number. This is my query so far... SET DATEFIRST 1...

Hi All, I'd like to create a SQL view for some dashboard software that ties into our ERP system. I have five queries to run but instead of the results being formatted horizontally with a column heading I'd like them to be displayed vertically like this... Account | Amount ============= Sales...

That works! Thank you!

I'm trying to use a table 'oelinhst_sql' to calculate on time delivery. What I need it to do is count the number of records in the current month then count them again where the request date equals the shipping date then divide the count from where they match by the total number of records. This...

The printer is attached to the network and I do have permissions to print to it but I don't think that's the issue because the print dialog box never appears. Also on these programs I don't have the option to Run as Administrator.

Hi All, I have a VB Crystal Reports form that works fine on XP machines but when I try to use it on my Windows 7 box the print button doesn't work, it just does nothing. I can view the report, export, etc, just not print. Any Ideas? Thanks in advance!

Hello all! The self assigned certificate expired on my IIS server expired so I installed certificate services on it and created a new one. Everything seems fine on the server but now IE is the only browser that can open the secure pages at a normal speed. Safari and Firefox will open the page...

Thank you so much lbass! That worked perfectly!