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
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...
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...
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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.