Extra column with custom text - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Extra column with custom text

Author

Topic

christosds
Starting Member

10 Posts

Posted - 2010-10-11 : 19:13:42

Hello
i have the next SELECT statement

SELECT A.CODE AS "product_sku", ISNULL(a.CODE2,'') AS "factory_code", ISNULL(A.CCCSUBCATEGORY,'999') AS "category_id", A.NAME AS "product_name",A.CODE1 AS "barcode",ISNULL(A.CODE2,'') AS "factory_code",A.NAME1 AS "endescr",A.ISACTIVE,A.MTRTYPE,A.MTRTYPE1,A.MTRACN,A.MTRCATEGORY AS "category",A.VAT AS "vat",A.MTRGROUP AS "group", A.MTRUNIT1 AS "mm",A.MTRMANFCTR AS "manufacturer",A.MTRMARK AS "brand",A.MTRMODEL AS "model",A.REORDERLEVEL AS "paraggelia",A.REMAINLIMMIN AS "elaxisto",A.MTRPLACE AS "wrhouse",ISNULL(A.PRICEW,0) AS "price",ISNULL(A.PRICER,0) AS "pricel",ISNULL(B.VARCHAR01,'') AS TEXT1,ISNULL(B.VARCHAR05,'') AS TEXT5,ISNULL(B.NUM01,0) AS X_08070B60,A.REMARKS,(REPLACE( A.REMARKS, CHAR(13)+CHAR(10), ' ')) AS NEWREM FROM MTRL A LEFT OUTER JOIN MTREXTRA B ON A.MTRL=B.MTRL WHERE A.SODTYPE=51 AND A.ISACTIVE=1 ORDER BY A.CODE, A.NAME

and when i run it and i get the results i want to add an extra column at the end with title "publ" and data for all rows "yes".
Any help ? Thanks

Skorch
Constraint Violating Yak Guru

300 Posts

Posted - 2010-10-11 : 19:28:06

Like this?


SELECT A.CODE AS "product_sku", 
ISNULL(a.CODE2,'') AS "factory_code", 
ISNULL(A.CCCSUBCATEGORY,'999') AS "category_id", 
A.NAME AS "product_name",A.CODE1 AS "barcode",
ISNULL(A.CODE2,'') AS "factory_code",
A.NAME1 AS "endescr",
A.ISACTIVE,
A.MTRTYPE,
A.MTRTYPE1,
A.MTRACN,
A.MTRCATEGORY AS "category",
A.VAT AS "vat",
A.MTRGROUP AS "group", 
A.MTRUNIT1 AS "mm",
A.MTRMANFCTR AS "manufacturer",
A.MTRMARK AS "brand",
A.MTRMODEL AS "model",
A.REORDERLEVEL AS "paraggelia",
A.REMAINLIMMIN AS "elaxisto",
A.MTRPLACE AS "wrhouse",
ISNULL(A.PRICEW,0) AS "price",
ISNULL(A.PRICER,0) AS "pricel",
ISNULL(B.VARCHAR01,'') AS TEXT1,
ISNULL(B.VARCHAR05,'') AS TEXT5,
ISNULL(B.NUM01,0) AS X_08070B60,
A.REMARKS,
(REPLACE( A.REMARKS, CHAR(13)+CHAR(10), ' ')) AS NEWREM,
'yes' AS publ
FROM MTRL A 
LEFT OUTER JOIN MTREXTRA B ON A.MTRL=B.MTRL 
WHERE A.SODTYPE=51 
AND A.ISACTIVE=1 
ORDER BY A.CODE, A.NAME

Some days you're the dog, and some days you're the fire hydrant.

christosds
Starting Member

10 Posts

Posted - 2010-10-11 : 19:41:03

YES! Thank you

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources