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 TouchToneTommy 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. arodri

    How to use a sum of numbers that are evaluated at a later time

    Hello, I have a Commissions report that I'm trying to finish but there is one final percentage that I'm having trouble with. Groups in the report: Group#1: Region Group#2: EmployeeName Group#3: SiteName All employees only work in one region, but there are times when one employee works at...
  2. arodri

    Parameter like and not like formula

    pmax9999, thank you again. That did the trick. I didn't enclose the formula you gave me in parenthesis so the order of operations must have been off. As soon as I added the parenthesis everything started working as I expected. Thanks so much! I really appreciate it.
  3. arodri

    Parameter like and not like formula

    Thanks AndyMc and pmaxx9999! pmaxx9999 - I used your solution and it seems to be working as far as selecting the appropriate terminals, but for some reason when I select "ALL" or "Wash" from the drop down list in the parameter, it displays ALL of the sites (this report is being group by sites)...
  4. arodri

    Parameter like and not like formula

    Hello, I'm not all that experienced with Crystal formulas, and have a parameter issue I can't figure out. I have the report working perfectly, and this parameter is the last step. I have a field in the report called "Terminal" that has almost a hundred different values, but here are examples...
  5. arodri

    Integrating subreport with main report

    Hello, I'm not even sure if this is possible, but I have two seperate reports right now that I need to make one. I don't work with subreports much but when I do, I normally put them in the main report footer, so that the subreport will just appear at the end of the main report. The reports...
  6. arodri

    Concatenate multiple rows into a single row

    Thanks for your help! I had to take a different route in the query but if this comes up again I'll know :)
  7. arodri

    Concatenate multiple rows into a single row

    I'm not sure how (or if it's possible) to concatenate the data in the way that I need it. Here's a sample of my data: Service1 Serivce 2 Service 3 Code Date NULL TS NULL 05S6 2011-01-09 00:00:00 FS NULL NULL 05S6 2011-01-09 00:00:00...
  8. arodri

    Selecting numbers to the right of the leading zeros

    Oh sorry! the query wasn't working at first but got it now. Works perfectly...thank you so much!
  9. arodri

    Selecting numbers to the right of the leading zeros

    Maybe I'm missing something but how would converting my field help in selecting all numbers to the right of the leading zeros?
  10. arodri

    Selecting numbers to the right of the leading zeros

    I have a table that I need to select the correct location numbers from but I can't seem to select the right numbers that I need. The location number is always the last number after all of the zeros to the right of it. For example, if in my table it reads "0000000004" then the location number...
  11. arodri

    Renaming text file - using wild character

    I need to rename it because I'm creating a dstx package with it and I need a set file name to map the columns in that file. jebenson - that worked perfectly. I used a variation because the job will run before the current days file is in the folder, so I had to use -1 on the date, but other...
  12. arodri

    Renaming text file - using wild character

    Andy- that's exactly what I need to do. I need the same set file name because I will be deleting every file as soon as its processed. There will be no duplicate names in the folder. Jebenson- I can't have a date in the name. I just want the file name to be renamed to "Emailunsubs.txt" every...
  13. arodri

    Renaming text file - using wild character

    Hello, I have the follwing code that I'm using to renam a text file, which works fine: My.Computer.FileSystem.RenameFile("d:\FTP\Void\Unsubs\Test\CW_EmailUnsubs022912.txt", "EmailUnsubs.txt") My problem is that the file that I need to rename ("CW_EmailUnsubs022912.txt") always has the date...
  14. arodri

    Insert Statement not working

    SQLBill you are a life saver!! I had no idea how I was going to get this if this didn't work. Adding the "GO" between the )) and the INSERT statement did it. Thank you sooo much everyone! I really appreciate all of your help.
  15. arodri

    Insert Statement not working

    I deleted everything after the last two close parenthesis and re-typing it but stll no luck. If I comment out the insert statement everything works normall. The query pulls all the data I need perfectly. But as soon as I add that statement back in it always gives me the same error: Msg 156...
  16. arodri

    Insert Statement not working

    Can you explain the date style I should use? I'm not familiar with them so I'm not sure what you mean. But yes, the select statement alone without any insert statements works just fine. That's why I'm so confused as to why adding a simple insert statement would mess up the query.
  17. arodri

    Insert Statement not working

    No luck :( Here is the message I get: Msg 102, Level 15, State 1, Line 67 Incorrect syntax near ')'. I already have the table created that this data needs to go into, so I took out the #SWTable and just put the following code right after SET @SQL = ' Insert Into...
  18. arodri

    Insert Statement not working

    I thought about the quotes too, but I don't think that's the problem. I tried taking out one of those quotes but I still get the same error. Also, the query works perfectly if I take out the Insert into statment and the "Select* INTO #SWTable From " So I don't think quotes are the problem. I...
  19. arodri

    Insert Statement not working

    Yeah I tried that and that's not it. Thanks for the idea though.
  20. arodri

    Insert Statement not working

    Sure, sql tried to execute the query for a few seconds then gives me the following error: Msg 156, Level 15, State 1, Line 70 Incorrect syntax near the keyword 'Insert'.

Part and Inventory Search

Back
Top