Recent content by etmccarthy13

Ok im running into the following issue with this Here is my current code REPORTFILENAME=N/A REPORTTYPE=xls SQLSTART: select '50000005000' as PARTN, '0001' as LGORT, WarehouseSku as MATNR, LotReferenceTwo as CHARG, SUM(QTYONHAND) AS MENGE, COALESCE (CASE WHEN UserConditionCode = '28' or...

PERFECT! Your the MAN!

I thought it would be that easy too but its erroring out "Incorrect syntax near the keyword 'or'."

Thanks Carnage!!! That works perfect!!! One more question- How can I have 2 instances when ## and ## then X I would Like PP and CP to place X's on the Output select '50000005000' as PARTN, '0001' as LGORT, WarehouseSku as MATNR, LotReferenceTwo as CHARG, SUM(QTYONHAND) AS MENGE, COALESCE...

IM using SQL SERVER.. I have to look into Code Tags.. Not sure how to use them lol

Here is the actual language REPORTFILENAME=N/A REPORTTYPE=xls SQLSTART: select '50000005000' as PARTN, '0001' as LGORT, WarehouseSku as MATNR, LotReferenceTwo as CHARG, SUM(QTYONHAND) AS MENGE, '' as INSMK, COALESCE (UserConditionCode, CASE UserConditionCode WHEN 'PP' THEN 'X' END, '') AS...

Ive tried both ways and still nothing

ODD.. Its taking it as a valid statement but is not changing anyhting on the output

OK im trying to write a report to pull this specific information (USING SQL) Sample DB PALLET#| QTY | HOLDCODE (IF APP)| 123 |100 | 124 |100 |pp 125 |100 |pp I want the following Output PALLET#|QTY|HOLD 123 |100| 124 |100|X 125 |100|X I have...

Ive figured this out.. I to link the actual orders in both data bases using a where clause Where ShipmentOrderDetail.OrderNumber = ShipmentOrder.OrderNumber This then Links all 3 tables by order Number ISSUE SOLVED! REPORTFILENAME=N/A REPORTTYPE=xls SQLSTART: select '' as Blank...

Ok Im not sure whats wrong with this Query but it is duplicating entries. One with the info im wanting and one with out the info... I want to get rid of the high lighted lines... Any Help is appreciated BElow is SQL Statement and a screen shot of the OutPut SQLSTART: select '' as Blank...

run IPCONFIG and see what that's putting out. Are you using a static IP?

Yea I got it but still need to get a keyboard for it... (I thought it came with the cover keyboard that is advertised in the commercials .. Do you recommend the Microsoft Surface keyboard or should I look another route for a Bluetooth key board??? Also Docking station is on its way Other...

just the 128 gb I5... I mainly use it for work so I don't need anything extremely robust

good read... thanks