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

    Flat file to query help needed

    I'm new to ssis and need some help. I have a csv file I need to use as a parameter to get some information and then update it. Here's how it looks in crystal reports... SELECT "Order_Master"."ORDNUM_10", "Order_Master"."TYPE_10", "Order_Master"."STATUS_10", "Order_Master"."CUSORD_10" FROM...
  2. onyxtacular

    updating Boolean based off character and character location

    Our company for years have used a text field as a way of adding more information about the customer. There are 3 digits in the code and the depending on the character and the position lets us know some information about the customer. Recently I found a way to add custom fields. Now I would like...
  3. onyxtacular

    How to add records based on query

    Hi Everyone, I trying to add data to the table based on query of the same table. Basically we have a several thousand entries with 21 in the option filed and want to make duplicates of the entries with 50 in the option field and change the string in the description field to something else...
  4. onyxtacular

    What do I need?

    Hi Everyone, I'm new to SQL and have been tasked with creating an "app" where the user can run a query to our 2012 SQL server with the click of the mouse. Our old db was Pervasive SQL and there was a way for the users to access the db on their desktop...sometimes with horrible results. What I...
  5. onyxtacular

    import data to parameter

    HI Everyone, Currently the user types the parameters into the report manually. I want to convert the report to gather the data from the fields of the .csv file. I've added to the .csv to crystal report what I don't understand is exactly how to make it read the values in the place of the...
  6. onyxtacular

    Generating web page from shared folder

    My company has tons of PDF drawings listed in folders by sales order number. I already have script to access the information, but it returns a basic folder listing back. I would like to modify this to return a webpage which will allow me to put other information in the page. This is what I have...

Part and Inventory Search

Back
Top