Recent content by TanmedIT

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