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 derfloh 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: *

  • Users: jmiskey
  • Order by date
  1. jmiskey

    Export Data From SQL to a Delimited Text File

    Denny, That sounds pretty cool! If I can capture that code, it could save me a ton of work! Do you know of any good write-ups on how to do what you proposed? In the meantime, I will scour the web to see what I can find out about it.
  2. jmiskey

    Export Data From SQL to a Delimited Text File

    mrdenny, The problem is, I currently have no query! All the table linking, grouping, and calculations, are currently done within Crystal Reports. To try to re-write as SQL is probably going to be a monster, and may be beyond my level of SQL writing expertise! Geoff, I will look into MS SQL...
  3. jmiskey

    Export Data From SQL to a Delimited Text File

    I get the feeling that what I want to do is probably far too complex for that. We are talking about joining 8 different tables, with multiple join fields, multiple levels of grouping, numerous calculations, criteria, and returning dozens of fields (in the 5 different record type formats...
  4. jmiskey

    Export Data From SQL to a Delimited Text File

    I have never heard of BCP before (other than Business Continuity Plan). Can you link multiple tables? Can you do grouping? Can you use/set criteria? Is it easy to use?
  5. jmiskey

    Export Data From SQL to a Delimited Text File

    I have a SQL database, where I need to join 8 different tables (and perform different levels of grouping) and export a delimited text file. It is basically an extract used to merge into a participant statement at an external printing vendor. For each person, a set of records will be exported...
  6. jmiskey

    Export Formulas / Report Specifications

    Is there a way to export or print the Formulas Fields and other Crystal Report Specifications for a Crystal Report? I am using CR10. I have a complex report with many calculated values that I need to reproduce in another program. Thanks.
  7. jmiskey

    Create Fixed Width (Space Delimited) Text File

    Thanks Ridyen. I don't think there are a lot of fields on the export, so that workaround may work.
  8. jmiskey

    Create Fixed Width (Space Delimited) Text File

    I need to create a data export file using Crystal Report that exports a file in Fixed Width (Space Delimited) Text format. Without doing a lot of "trial and error", is there any easy to designate how many spaces each field should take up? It appears that the default ruler in Crystal Reports is...
  9. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    George, I am intrigued by this solution, but can't quite figure out how to make it work in my example. Can you use recursive calculations in a query? Basically, I am trying to create a subquery that will be part of a larger query.
  10. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    select 'ABC', 'A' union all select 'MMM', 'S' union all select 'XYZ', 'A' union all select 'XYZ', 'B' union all select 'ABC', 'W' union all select 'XYZ', 'W' union all select 'DEF', 'C' It looks like in your code, you have to need to know all the companies and pay frequencies ahead of time, and...
  11. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    Cool code, but I don't think I will be able to use it for the same reasons I can't use Alex's.
  12. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    Essentially what I need to build has to be able to be dynamic and built on-the-fly every time a certain Crystal Report is run (the data query I am trying to create is part of the Data Source of my report). So I don't know how possible/feasible it is to have something that builds temporary...
  13. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    That looks a bit complex, and those table drops do scare me. Anyway, it looks like it would run in to the same problems I mentioned to George six posts up, where the number of possible values is unknown (not pre-determined) and we do all the results to be "left-justified" (instead of having a...
  14. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    Yes, I thought that might be the case. If I were doing on Microsoft Access, I would probably create a make-table query to create a temporary table that would create that Pay_ID field via some VBA code. However, I don't think that approach is too feasible here. It's hard to overcome poor...
  15. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    Hmmm... That is something to ponder. I will have to re-consider my report to see if that is do-able. We had intended to show different fields, but may be able to change it.
  16. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    Thanks for the response. There are just two potential issues: 1. We may not know all the payroll frequencies codes ahead of time. For example, we have some companies that have multiple bi-weekly pay frequencies, so their codes are "B1" and "B2". Ideally, we would like to write the query...
  17. jmiskey

    Create Cross-Tab Query From Table with Only Two Fields

    From my experience with Microsoft Access, I know you can create Cross-Tab queries if you have at least 3 fields. However, I am trying to create a Cross-Tab Query in SQL Server when I only have 2 fields. Here is sample of what I have: ID Pay_Freq ABC A MMM S XYZ A XYZ B ABC W...
  18. jmiskey

    Nesting Calculations in Select Statements

    George, That actually is exactly what I did, mostly because I am using Subqueries because the code I posted is just a small piece of larger code I am building where I am linking 4 tables together. I was just curious if there was a way to it within one query, for those instances in which I am...
  19. jmiskey

    Nesting Calculations in Select Statements

    Thanks. It also appears that I cannot use the Calculations in WHERE clauses, i.e. in my example above I cannot use WHERE (ELECTIONS - DEPOSITS)>0 Seems like a nuisance to have to keep typing in the same calculations time and again, but it is what it is...
  20. jmiskey

    Nesting Calculations in Select Statements

    Can I base calculations on other calculations within my Select statement, or do I need to base each calculation on the underlying components? For example, I have this query SELECT A.SOCIAL_SECURITY_NUM, (A.TOTAL_ELECTIONS + A. TOTALOTHERADHOC + A.TOTAL_ROLLOVER) AS ELECTIONS...

Part and Inventory Search

Back
Top