Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kpetree10

  1. kpetree10

    Create SQL Trigger to run script

    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)...
  2. kpetree10

    Create SQL Trigger to run script

    That makes perfect sense! Please go on.
  3. kpetree10

    Create SQL Trigger to run script

    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.
  4. kpetree10

    Create SQL Trigger to run script

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

    Create SQL Trigger to run script

    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...
  6. kpetree10

    Display Multiple Records Horizontally

    That worked great! Thank you so much!
  7. kpetree10

    Office 2010 will not automatically activate with KMS

    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.
  8. kpetree10

    Display Multiple Records Horizontally

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

    Select Part of a string after certain value

    You guys are awesome, thank you!
  10. kpetree10

    Select Part of a string after certain value

    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...
  11. kpetree10

    Office 2010 will not automatically activate with KMS

    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...
  12. kpetree10

    Multiple date range SUM query

    Thanks markros!
  13. kpetree10

    Multiple date range SUM query

    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...
  14. kpetree10

    Creating a SQL View Vertically

    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...
  15. kpetree10

    Select Query help

    That works! Thank you!
See more

Part and Inventory Search

Back
Top