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

    What part of the module would allow me to do that?
  2. 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...
  3. onyxtacular

    updating Boolean based off character and character location

    I figured it out... UPDATE customer_master_ext SET [2020] = 1 FROM customer_master inner join Customer_Master_ext on CUSTOMER_MASTER.CUSTID_23 = CUSTOMER_MASTER_EXT.CUSTID_23 WHERE substring(customer_master.custyp_23,2,1)='2'
  4. 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...
  5. onyxtacular

    How to add records based on query

    Thanks SQLBILL and bborissov I got both of the codes working. Previously the company downloaded the data...made manual changes and then uploaded the data. The process took hours to complete, now it takes minutes. Your help is greatly appreciated. I will do my best to pay it forward.
  6. onyxtacular

    How to add records based on query

    I'm also trying your way bborissov. It seems straight forward. I'm learning this SQL as I go. Thanks for the help.
  7. onyxtacular

    How to add records based on query

    I must be missing something...I tried running pretty much as SQLBILL gave me. Here is the actual code I used: SELECT * INTO #cfgmaster_temp from GNC5.dbo.Configuration_Mst WHERE 'FEANUM_44' = '01' AND 'CFGCHR_44' = '21' UPDATE #cfgmaster_temp SET CFGCHR_44 = '50' INSERT INTO...
  8. 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...
  9. onyxtacular

    What do I need?

    Thanks for your post. I've read through https://msdn.microsoft.com/en-us/library/ms162773.aspx and this looks like it may work for what I would like to do.
  10. 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...
  11. onyxtacular

    import data to parameter

    Just a quick update, the problem was crystal linked the first field so it limited the output based on the the number of records. Once I cleared the links things went smoothly.
  12. onyxtacular

    import data to parameter

    Hilfy, First thanks for your help and time on this. I went back and made the modifications. The report finally ran, but no data. I then cried just a little, but then I went back and looked at everything I finally tried EXTERNAL JOIN MSClose40_.startON={?Onyx: Order_Master.CUSORD_10} which...
  13. onyxtacular

    import data to parameter

    Well I got it to work...kinda. I switch from csv to excel. the problem with the csv is CR read it as a number instead of a text. I'm sure there is a quick and dirty way of fixing that, but this is my first rodeo so I'm focusing on the goal and saved it as an excel and CR made the link. Now...
  14. onyxtacular

    import data to parameter

    {Order_Master.TYPE_10} = "MS" and {Order_Master.STATUS_10} < "4" and {Order_Master.CUSORD_10} >= '{MSClose40_2003_csv.startON}' and {Order_Master.CUSORD_10} <= '{MSClose40_2003_csv.endON}' After a lot of head scratching last night I came up with this. Which I think would meet the criteria. I...
  15. 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...
  16. onyxtacular

    Generating web page from shared folder

    Well I've been playing with the permissions to the folder in question \\gnc3\drawings\ and still have not gotten pass the permission denied error. I guess what really irks me is that I can get the sub-folders to list out but not the files. When uncomment the (line 20) For Each file In...
  17. onyxtacular

    Generating web page from shared folder

    Hi niteowl: Thanks, this code seems to be really close to what I need. So far I've gotten the folders to list out. I had to comment out the files routine, but at least I'm on the right path. Reading the files gives me a permission denied error. Once I tweak the permissions I should at...
  18. onyxtacular

    Generating web page from shared folder

    Hi, Thanks for the responses: Rac2: the domain name is my internal server - http://gnc3 and I want to point to the virtual folder http://gnc3/foldername. I would the contents of the folder to be a web page. Thanks for responding...I hope this clarifies what I'm trying to accomplish...
  19. 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