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.
| Author |
Topic |
|
dtrivedi
Posting Yak Master
153 Posts |
 Posted - 2011-02-08 : 10:58:19
|
| I have this sql statement how do i start creating a view for it? SELECT ALL PDLCN AS LOC, DATE(DIGITS(PHDLVM)||'/'||DIGITS(PHDLVD)||'/'||DIGITS(PHDLVY)) AS HEXPDATE, DIGITS(PDDLVM)||'/'||DIGITS(PDDLVD)||'/'||DIGITS(PDDLVY) AS EXPDATE, DIGITS(PDPCHM)||'/'||DIGITS(PDPCHD)||'/'||DIGITS(PDPCHY) AS PODATE, PHVNDP AS VENDORNUM, PHVNDA AS VENDORNAME, PDPON AS PONUM, PDCMP AS COMPLETE, PDORDQ AS ORDERQTY, PDOPNQ AS OPENQTY, PDEXTC AS OPEXTCST, PDEXTR AS OPEXTRTL, IXPBSN AS B, IXPGRP AS G, IXPDPT AS D, ITITMN AS ITEMCODE, ITDSC1 AS ITEMDESC1, ITDSC2 AS ITEMDESC2, PHBYR AS BUYER, PDCNLF AS CANCEL, PHRFR AS REF, ITINVM AS STKCD, PHRFR AS HEADREF, PDLIN AS POLINE, IXITYP AS INSTTYPE, PDCTL AS SERIALNUM, PDPCHM AS POMONTH, PDPCHD AS PODAY, PDPCHY AS POYEAR, ITMFGN AS MFG, IXPRPR AS PROPFLAG FROM APODTAMAC/APOPODM T01, AICDTAMAC/AICITMJ T02, APODTAMAC/APOPOHM T03 WHERE PDITMN = ITITMN AND PDPON = PHPON AND( PHDLVY >= 2006 AND PDCMP <> 'Y' AND PDCNLF <> 'Y' AND PHCNLF <> 'Y' AND PHCPLF <> 'Y') |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2011-02-08 : 12:03:10
|
| You must be an Oracle programmer.Creating a view in sql server is easy.Create View MyView asselect.......Also, I highly that you rewrite your sql to use standard JOIN syntax, rather than the outdated method of linking tables in the WHERE clause.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
 |
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2011-02-08 : 12:50:07
|
| Thanks the reason we use this way is because our database is in as400 so join statements make matters difficult |
|
|
|
|
|
|
|
|
creating a view from sql statement