Search results for query: *

LNBruno, Msg 102, Level 15, State 1, Line 29 Incorrect syntax near ','. here is the line: ELSE ('Elbow','Femur','Glenoid','Great Toe','Hum. Stem','Lesser Toe','PLATE','Plug','Prime Pin','Prm Screw','Prox Screw','Rad. Stem','RES

still no go.. getting same error even when I replace the double quotes with singles

THE ERROR IS ON THIS LINE (PROBABLY THE FIRST ","): ELSE ('Elbow','Femur','Glenoid','Great Toe','Hum. Stem','Lesser Toe','PLATE','Plug','Prime Pin','Prm Screw','Prox Screw','Rad. Stem','RES

I GET THIS ERROR: Msg 102, Level 15, State 1, Line 29 Incorrect syntax near ','. HERE IS MY QUERY: SELECT SOP10200.SOPTYPE, SOP10100.VOIDSTTS,SOP10100.SOPNUMBE, IV00101.ITEMNMBR, RM00101.CUSTCLAS, SOP10100.SALSTERR, SOP10106.USRDAT01, SOP10100.CUSTNMBR, IV00101.USCATVLS_1...

I am trying to figure out how to use these CASE statements. I have a Stored Procedure that is capturing some incorrect data. I need to to filter out base on 2 criteria: If USCATVLS_1 = "Latitude" then USCATVLS_2 = "Hum. Stem" else If USCATVLS_1 = "RHS" then USCATVLS_2 = "Rad. Stem" else...

WORKED LIKE A CHARM

Thanks, i will give it a try

I understand this, but can't I create a temp tables with these headings, then populate it with some kind of "do while" or something to that effect. I know it can be done, i am just not sure how to do it. I remember doing something like this with "C" programming back in college, but that was...

I first apologize if this is in the wrong forum. I am new to SQL and I have a stored procedure question. I have 2 tables that I need to combine into one temp table. Table One (Distributor Information): DistributorID Tables Two (Item Information): Item Number, Class ID I need to create a...

Probably at the most 100..

I think I have read every thread on this subject but none really pertain to what I am trying to accomplish. I have a report that uses 2 subreports, one that totals all unposted sales and one that totals posted sales. I set up shared variables in both reports that i use to creates a total in...

John, that is exactly what I needed. Thanks. And I truly apologize for coming off sounding like a jerk. I know this could have been a much better report with Pivot Tables, but this is what I had to work with and it had to be done by 4pm today (its 3:11) Thanks again for your replies

Because I am using the original information to calculate values on a separate worksheet, which is ALREADY formatted.. I can probably figure it out, but I was hoping to save sometime by asking here. I know it can be easily done in a pivot table, but I don't want to recreate the wheel on a...

Sorry, that can't work because I am using this worksheet to created a 2nd sheet with formatted text. It has to be a formula that I will use in a cell

Sorry I meant to say: I need to add up the "Qty" when the "P/N", "L/N", and "From" are equal to others in the same column. For instance Rows 2 and 3 match so the total Qty would be 21. Thanks in Advance

I need to add up the "Qty" when the "P/N", "L/N", and "From" Here is my data: P/N L/N Qty From To sta-d1 k09714 1 N-FG STA-K21 STA-D1 K09714 20 N-FG STA-K21 STA-D3 K08949 3 N-FG STA-K21 STA-D2 K09720 5 N-FG STA-K21 MTP-PS2L 2 N-CNSBLK MT00092 MTP-PS2R 2 N-CNSBLK MT00092 MTP-PS3L 2 N-CNSBLK...

There actually some more formatting that needs to be done. It should actually look like this (but I wanted to keep it out of this thread for simplicity sake) @@batchload iclotr02.p "Part Num" "Amount" - - - - "100"...

I have a spreadsheet in Excel where I will need to create a seperate worksheet with all the data in rows so I can import into our MRP program. Here is what my data looks like: P/N L/N Qty From To STA-P1 K09713 50 N-FG 1s1300 STA-D2 K09555 50 N-FG 1s1300 I need it to look like this...

Sometimes you just need a second set of eyes... Dang that was dumb of me... I knew I was close.. Thanks

I am trying to populate 2 fields with formulas for month and year. I can get them to use the numeric value for month, but I would like it to show the "mmm" format, but change the format in the VBA code rather than having to format the cells in excel. Here is my current code that makes the...