Search results for query: *

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

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.

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

...from the drop down list, it will pull up ALL values in the report Wash - This will pull up the values in the report where TERMINAL not like "l*" - I basically need the report to pull all values that do not start with the letter "L" Lube - This will pull up all of the values in the 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...

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

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

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

Maybe I'm missing something but how would converting my field help in selecting all 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...

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

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

...the same, the only thing that will change is the date. I need a script that will change the name of the file no matter what the date is, so I need to use a wildcard for the date part. I tried using an * "CW_EmailUnsubs*.txt" but it is invalid. Any suggestions would be really appreciated...

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.

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

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.

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

...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 didn't add any extra quotes when I added the two statements. I did Print(@sql)...

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

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