Mastering SQL queries for SAP Business one :: utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business /
Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook.
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Pub.,
2011.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook. |
| Beschreibung: | 1 online resource (1 electronic resource (331 pages)) : color illustrations |
| ISBN: | 9781849682374 1849682372 1283349582 9781283349581 9786613349583 6613349585 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBU-ocn742282647 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 110724s2011 enka of 001 0 eng d | ||
| 040 | |a N$T |b eng |e pn |c N$T |d E7B |d OCLCQ |d UMI |d COO |d OCLCQ |d DEBSZ |d OCLCQ |d DKDLA |d OCLCQ |d YDXCP |d OCLCQ |d OCLCF |d OCLCQ |d AGLDB |d OCLCQ |d OCLCO |d JBG |d CNNOR |d OCLCQ |d OCLCO |d MOR |d PIFAG |d OCLCQ |d U3W |d STF |d WRM |d BRL |d OCLCQ |d CEF |d NRAMU |d NLE |d INT |d VT2 |d AU@ |d UKMGB |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d A6Q |d UKAHL |d HS0 |d BOL |d UKCRE |d VLY |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 016 | 7 | |a 018015094 |2 Uk | |
| 019 | |a 794554424 |a 961691066 |a 962725284 |a 988499353 |a 992062749 |a 1037784632 |a 1038665705 |a 1039187470 |a 1045582167 |a 1055347169 |a 1058228876 |a 1081240207 |a 1083554514 |a 1103262032 |a 1114371565 |a 1129356308 |a 1153015657 |a 1162530245 |a 1192337930 |a 1228528816 |a 1240508861 | ||
| 020 | |a 9781849682374 |q (electronic bk.) | ||
| 020 | |a 1849682372 |q (electronic bk.) | ||
| 020 | |a 1283349582 | ||
| 020 | |a 9781283349581 | ||
| 020 | |a 9786613349583 | ||
| 020 | |a 6613349585 | ||
| 020 | |z 9781849682367 | ||
| 020 | |z 1849682364 | ||
| 035 | |a (OCoLC)742282647 |z (OCoLC)794554424 |z (OCoLC)961691066 |z (OCoLC)962725284 |z (OCoLC)988499353 |z (OCoLC)992062749 |z (OCoLC)1037784632 |z (OCoLC)1038665705 |z (OCoLC)1039187470 |z (OCoLC)1045582167 |z (OCoLC)1055347169 |z (OCoLC)1058228876 |z (OCoLC)1081240207 |z (OCoLC)1083554514 |z (OCoLC)1103262032 |z (OCoLC)1114371565 |z (OCoLC)1129356308 |z (OCoLC)1153015657 |z (OCoLC)1162530245 |z (OCoLC)1192337930 |z (OCoLC)1228528816 |z (OCoLC)1240508861 | ||
| 037 | |a CL0500000140 |b Safari Books Online | ||
| 050 | 4 | |a QA76.73.S67 |b D8 2011eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 082 | 7 | |a 005.756 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Du, Gordon. | |
| 245 | 1 | 0 | |a Mastering SQL queries for SAP Business one : |b utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / |c Gordon Du. |
| 246 | 3 | |a Mastering Structured Query Language queries for SAP Business One | |
| 260 | |a Birmingham : |b Packt Pub., |c 2011. | ||
| 300 | |a 1 online resource (1 electronic resource (331 pages)) : |b color illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 340 | |g polychrome. |2 rdacc |0 http://rdaregistry.info/termList/RDAColourContent/1003 | ||
| 347 | |a text file |2 rdaft |0 http://rdaregistry.info/termList/fileType/1002 | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables | |
| 505 | 8 | |a Important table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 2:Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders | |
| 505 | 8 | |a Step 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 3:Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement | |
| 505 | 8 | |a DISTINCT-duplicated records can be removedTOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report | |
| 505 | 8 | |a ORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge | |
| 520 | |a Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook. | ||
| 546 | |a English. | ||
| 630 | 0 | 0 | |a SAP Business one |v Handbooks, manuals, etc. |
| 630 | 0 | 7 | |a SAP Business one. |2 blmlsh |
| 630 | 0 | 7 | |a SAP Business one |2 fast |
| 650 | 0 | |a SQL (Computer program language) |v Handbooks, manuals, etc. | |
| 650 | 6 | |a SQL (Langage de programmation) |v Guides, manuels, etc. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 655 | 7 | |a manuals (instructional materials) |2 aat | |
| 655 | 7 | |a handbooks. |2 aat | |
| 655 | 7 | |a Handbooks and manuals |2 fast | |
| 655 | 7 | |a Handbooks and manuals. |2 lcgft |0 http://id.loc.gov/authorities/genreForms/gf2014026109 | |
| 655 | 7 | |a Guides et manuels. |2 rvmgf | |
| 758 | |i has work: |a Mastering SQL queries for SAP Business One (Text) |1 https://id.oclc.org/worldcat/entity/E39PD3VDCtkjhb3hKXWYXm44fV |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Du, Gordon. |t Mastering SQL queries for SAP Business one. |d Birmingham : Packt Publishing, 2011 |z 9781849682367 |w (OCoLC)773258124 |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBU |q FWS_PDA_EBU |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=369133 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26944015 | ||
| 938 | |a ebrary |b EBRY |n ebr10477269 | ||
| 938 | |a EBSCOhost |b EBSC |n 369133 | ||
| 938 | |a YBP Library Services |b YANK |n 6939153 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBU | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBU-ocn742282647 |
|---|---|
| _version_ | 1816796902251823104 |
| adam_text | |
| any_adam_object | |
| author | Du, Gordon |
| author_facet | Du, Gordon |
| author_role | |
| author_sort | Du, Gordon |
| author_variant | g d gd |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.73.S67 D8 2011eb |
| callnumber-search | QA76.73.S67 D8 2011eb |
| callnumber-sort | QA 276.73 S67 D8 42011EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBU |
| contents | Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables Important table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 2:Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders Step 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 3:Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement DISTINCT-duplicated records can be removedTOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report ORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge |
| ctrlnum | (OCoLC)742282647 |
| dewey-full | 005.756 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.756 |
| dewey-search | 005.756 |
| dewey-sort | 15.756 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06938cam a2200745 a 4500</leader><controlfield tag="001">ZDB-4-EBU-ocn742282647</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">110724s2011 enka of 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">N$T</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">N$T</subfield><subfield code="d">E7B</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UMI</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">DKDLA</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">JBG</subfield><subfield code="d">CNNOR</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">MOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">U3W</subfield><subfield code="d">STF</subfield><subfield code="d">WRM</subfield><subfield code="d">BRL</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">CEF</subfield><subfield code="d">NRAMU</subfield><subfield code="d">NLE</subfield><subfield code="d">INT</subfield><subfield code="d">VT2</subfield><subfield code="d">AU@</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">A6Q</subfield><subfield code="d">UKAHL</subfield><subfield code="d">HS0</subfield><subfield code="d">BOL</subfield><subfield code="d">UKCRE</subfield><subfield code="d">VLY</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018015094</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">794554424</subfield><subfield code="a">961691066</subfield><subfield code="a">962725284</subfield><subfield code="a">988499353</subfield><subfield code="a">992062749</subfield><subfield code="a">1037784632</subfield><subfield code="a">1038665705</subfield><subfield code="a">1039187470</subfield><subfield code="a">1045582167</subfield><subfield code="a">1055347169</subfield><subfield code="a">1058228876</subfield><subfield code="a">1081240207</subfield><subfield code="a">1083554514</subfield><subfield code="a">1103262032</subfield><subfield code="a">1114371565</subfield><subfield code="a">1129356308</subfield><subfield code="a">1153015657</subfield><subfield code="a">1162530245</subfield><subfield code="a">1192337930</subfield><subfield code="a">1228528816</subfield><subfield code="a">1240508861</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849682374</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849682372</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1283349582</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781283349581</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9786613349583</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">6613349585</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849682367</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1849682364</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)742282647</subfield><subfield code="z">(OCoLC)794554424</subfield><subfield code="z">(OCoLC)961691066</subfield><subfield code="z">(OCoLC)962725284</subfield><subfield code="z">(OCoLC)988499353</subfield><subfield code="z">(OCoLC)992062749</subfield><subfield code="z">(OCoLC)1037784632</subfield><subfield code="z">(OCoLC)1038665705</subfield><subfield code="z">(OCoLC)1039187470</subfield><subfield code="z">(OCoLC)1045582167</subfield><subfield code="z">(OCoLC)1055347169</subfield><subfield code="z">(OCoLC)1058228876</subfield><subfield code="z">(OCoLC)1081240207</subfield><subfield code="z">(OCoLC)1083554514</subfield><subfield code="z">(OCoLC)1103262032</subfield><subfield code="z">(OCoLC)1114371565</subfield><subfield code="z">(OCoLC)1129356308</subfield><subfield code="z">(OCoLC)1153015657</subfield><subfield code="z">(OCoLC)1162530245</subfield><subfield code="z">(OCoLC)1192337930</subfield><subfield code="z">(OCoLC)1228528816</subfield><subfield code="z">(OCoLC)1240508861</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000140</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.73.S67</subfield><subfield code="b">D8 2011eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051170</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.756</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Du, Gordon.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Mastering SQL queries for SAP Business one :</subfield><subfield code="b">utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business /</subfield><subfield code="c">Gordon Du.</subfield></datafield><datafield tag="246" ind1="3" ind2=" "><subfield code="a">Mastering Structured Query Language queries for SAP Business One</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Pub.,</subfield><subfield code="c">2011.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1 electronic resource (331 pages)) :</subfield><subfield code="b">color illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="340" ind1=" " ind2=" "><subfield code="g">polychrome.</subfield><subfield code="2">rdacc</subfield><subfield code="0">http://rdaregistry.info/termList/RDAColourContent/1003</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield><subfield code="2">rdaft</subfield><subfield code="0">http://rdaregistry.info/termList/fileType/1002</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Important table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 2:Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Step 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 3:Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">DISTINCT-duplicated records can be removedTOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">ORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">SAP Business one</subfield><subfield code="v">Handbooks, manuals, etc.</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">SAP Business one.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">SAP Business one</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield><subfield code="v">Handbooks, manuals, etc.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">SQL (Langage de programmation)</subfield><subfield code="v">Guides, manuels, etc.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">manuals (instructional materials)</subfield><subfield code="2">aat</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">handbooks.</subfield><subfield code="2">aat</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Handbooks and manuals</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Handbooks and manuals.</subfield><subfield code="2">lcgft</subfield><subfield code="0">http://id.loc.gov/authorities/genreForms/gf2014026109</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="a">Guides et manuels.</subfield><subfield code="2">rvmgf</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Mastering SQL queries for SAP Business One (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PD3VDCtkjhb3hKXWYXm44fV</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Du, Gordon.</subfield><subfield code="t">Mastering SQL queries for SAP Business one.</subfield><subfield code="d">Birmingham : Packt Publishing, 2011</subfield><subfield code="z">9781849682367</subfield><subfield code="w">(OCoLC)773258124</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBU</subfield><subfield code="q">FWS_PDA_EBU</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=369133</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26944015</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10477269</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">369133</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">6939153</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBU</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| genre | manuals (instructional materials) aat handbooks. aat Handbooks and manuals fast Handbooks and manuals. lcgft http://id.loc.gov/authorities/genreForms/gf2014026109 Guides et manuels. rvmgf |
| genre_facet | manuals (instructional materials) handbooks. Handbooks and manuals Handbooks and manuals. Guides et manuels. |
| id | ZDB-4-EBU-ocn742282647 |
| illustrated | Illustrated |
| indexdate | 2024-11-26T14:49:03Z |
| institution | BVB |
| isbn | 9781849682374 1849682372 1283349582 9781283349581 9786613349583 6613349585 |
| language | English |
| oclc_num | 742282647 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (1 electronic resource (331 pages)) : color illustrations |
| psigel | ZDB-4-EBU |
| publishDate | 2011 |
| publishDateSearch | 2011 |
| publishDateSort | 2011 |
| publisher | Packt Pub., |
| record_format | marc |
| spelling | Du, Gordon. Mastering SQL queries for SAP Business one : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / Gordon Du. Mastering Structured Query Language queries for SAP Business One Birmingham : Packt Pub., 2011. 1 online resource (1 electronic resource (331 pages)) : color illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier polychrome. rdacc http://rdaregistry.info/termList/RDAColourContent/1003 text file rdaft http://rdaregistry.info/termList/fileType/1002 Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables Important table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 2:Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders Step 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 3:Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement DISTINCT-duplicated records can be removedTOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report ORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook. English. SAP Business one Handbooks, manuals, etc. SAP Business one. blmlsh SAP Business one fast SQL (Computer program language) Handbooks, manuals, etc. SQL (Langage de programmation) Guides, manuels, etc. COMPUTERS Programming Languages SQL. bisacsh SQL (Computer program language) fast manuals (instructional materials) aat handbooks. aat Handbooks and manuals fast Handbooks and manuals. lcgft http://id.loc.gov/authorities/genreForms/gf2014026109 Guides et manuels. rvmgf has work: Mastering SQL queries for SAP Business One (Text) https://id.oclc.org/worldcat/entity/E39PD3VDCtkjhb3hKXWYXm44fV https://id.oclc.org/worldcat/ontology/hasWork Print version: Du, Gordon. Mastering SQL queries for SAP Business one. Birmingham : Packt Publishing, 2011 9781849682367 (OCoLC)773258124 FWS01 ZDB-4-EBU FWS_PDA_EBU https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=369133 Volltext |
| spellingShingle | Du, Gordon Mastering SQL queries for SAP Business one : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables Important table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 2:Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders Step 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 3:Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement DISTINCT-duplicated records can be removedTOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report ORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge SAP Business one Handbooks, manuals, etc. SAP Business one. blmlsh SAP Business one fast SQL (Computer program language) Handbooks, manuals, etc. SQL (Langage de programmation) Guides, manuels, etc. COMPUTERS Programming Languages SQL. bisacsh SQL (Computer program language) fast |
| subject_GND | http://id.loc.gov/authorities/genreForms/gf2014026109 |
| title | Mastering SQL queries for SAP Business one : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / |
| title_alt | Mastering Structured Query Language queries for SAP Business One |
| title_auth | Mastering SQL queries for SAP Business one : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / |
| title_exact_search | Mastering SQL queries for SAP Business one : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / |
| title_full | Mastering SQL queries for SAP Business one : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / Gordon Du. |
| title_fullStr | Mastering SQL queries for SAP Business one : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / Gordon Du. |
| title_full_unstemmed | Mastering SQL queries for SAP Business one : utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / Gordon Du. |
| title_short | Mastering SQL queries for SAP Business one : |
| title_sort | mastering sql queries for sap business one utilize the power of sql queries to bring business intelligence to your small to medium sized business |
| title_sub | utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business / |
| topic | SAP Business one Handbooks, manuals, etc. SAP Business one. blmlsh SAP Business one fast SQL (Computer program language) Handbooks, manuals, etc. SQL (Langage de programmation) Guides, manuels, etc. COMPUTERS Programming Languages SQL. bisacsh SQL (Computer program language) fast |
| topic_facet | SAP Business one Handbooks, manuals, etc. SAP Business one. SAP Business one SQL (Computer program language) Handbooks, manuals, etc. SQL (Langage de programmation) Guides, manuels, etc. COMPUTERS Programming Languages SQL. SQL (Computer program language) manuals (instructional materials) handbooks. Handbooks and manuals Handbooks and manuals. Guides et manuels. |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=369133 |
| work_keys_str_mv | AT dugordon masteringsqlqueriesforsapbusinessoneutilizethepowerofsqlqueriestobringbusinessintelligencetoyoursmalltomediumsizedbusiness AT dugordon masteringstructuredquerylanguagequeriesforsapbusinessone |