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!

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

Search results for query: *

  1. itprsn

    querying: results to txt includes blank lines at end of results

    1. Yes, the results are saved and used in other programs that error out with the blank lines if they're not removed. 3. I didn't see any check boxes for this either.
  2. itprsn

    querying: results to txt includes blank lines at end of results

    In SQL Server Management Studio Express: when running queries and sending the results to txt I get blank lines (or returns?) at the end of the results. Does anyone know where these blank lines are coming from and how to stop them?? Thanks...
  3. itprsn

    CR XML V3.6 TABLE AND ROW HINTS

    I'm using Crystal 8.5, having difficulty pulling XML data in. How can I tell what the table and row hints should be to pull the data in (assuming that's the problem)? I'm connecting and getting the following fields but no other: <lastauthor>, <created> and <version>. I get no other fields and...
  4. itprsn

    pivottable number field not available

    I'm not sure I set up/ran the procedure correctly, it didn't appear to do anything... It appears this is related to blank lines. When selecting my data I selected columns, not specific rows/columns. I really do need (I think) just columns because the number of rows is variable - but I want...
  5. itprsn

    pivottable number field not available

    My data is as follows: 7/9/2008 12:44:32 AM. I need to use the number option in pivottable field (lower right) to format this field as the time alone - but I don't have access to the number button - ??
  6. itprsn

    Date/Time to Time Only

    Thanks, I will check it out!
  7. itprsn

    Date/Time to Time Only

    Thanks everyone for your help! Following the advise to look at the convert function (in particular the style argument), I came across the following info: http://databases.aspfaq.com/database/what-are-the-valid-styles-for-converting-datetime-to-string.html
  8. itprsn

    Date/Time to Time Only

    Yes, I found it, thanks (newbie)...
  9. itprsn

    Date/Time to Time Only

    I have a date/time field with the following data as an example: '4/8/2008 12:03:14 AM'. I need the correct syntax to select just the time in this field. Can anyone help? Thanks...
  10. itprsn

    Set Hours in DateTime variable

    I have a date/time field with the following data as an example: '4/8/2008 12:03:14 AM'. Need the correct syntax in SQL to pull out just the date. Can anybody help? Thanks...
  11. itprsn

    ROUNDING INSTEAD OF PRECISION 2?

    Apparently so - 1000.0000 worked. Thanks!
  12. itprsn

    ROUNDING INSTEAD OF PRECISION 2?

    Having no luck trying to get precision 2 data in a stored procedure. I've tried variations of the following logic with no success. Can someone help? Thanks... SELECT CONVERT(DECIMAL(10,2),SUM(PRD.Pages*GrossFolder)/1000) MGP FROM...
  13. itprsn

    calcuate % using only subtotal data in a pivot table

    Got it, adding an adjacent column in the data source was new to me but I understand where you're going with this now... Thanks for your help!!
  14. itprsn

    calcuate % using only subtotal data in a pivot table

    Let me try and clarify: in SQL I'm pulling several records for each product's press runs and using a union to pull in one additional record for the total of all press runs for that product (to get the overrun I'm looking at all the press runs in total, then comparing to the order). All's good so...
  15. itprsn

    calcuate % using only subtotal data in a pivot table

    Not sure I understand how this works in pivot table?
  16. itprsn

    calcuate % using only subtotal data in a pivot table

    Data looks like the attached: product order press printed overrun waste % newspaper1 10,000 4 5,760 newspaper1 10,000 5 5,840 newspaper1 10,000 n/a n/a 1,600 Summary 10,000 All 11,600 1,600 xx.xx What I need to do is calculate a waste % based on the information that is found...
  17. itprsn

    Excel skipping referenced rows

    Excellent, I changed the option in MS Query - works perfect! Regarding referencing the data on another sheet, I actually just showed one column of the data but there are many more. My second sheet actually pulls the data from several sheets and formats it... Thanks again!
  18. itprsn

    Excel skipping referenced rows

    Yes, it returns only the five formulas. Yes, tried using summary!$A$7, same thing. No macros...

Part and Inventory Search

Back
Top