{"id":3791,"date":"2014-11-04T13:38:27","date_gmt":"2014-11-04T12:38:27","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=3791&#038;lang=en"},"modified":"2024-05-27T09:37:47","modified_gmt":"2024-05-27T08:37:47","slug":"queries","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=3791","title":{"rendered":"Useful Queries"},"content":{"rendered":"<p><strong>Queries<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/sdna.lu\/?p=7132&amp;lang=en\">Query: Attach SQL Database<\/a><\/li>\n<li><a title=\"Query: Display triggers\" href=\"https:\/\/sdna.lu\/?p=2140&amp;lang=e\">Query: Display triggers<\/a><\/li>\n<li><a title=\"Query: How to see connected users\" href=\"https:\/\/sdna.lu\/?p=1240&amp;lang=en\">Query: How to see connected users<\/a><\/li>\n<li><a title=\"Query: How to drop a field\" href=\"https:\/\/sdna.lu\/?p=1254&amp;lang=en\" target=\"_self\" rel=\"noopener noreferrer\">Query: How to drop a field<\/a><\/li>\n<li><a title=\"How to change a Sql Server database collation\" href=\"https:\/\/sdna.lu\/?p=913&amp;lang=en\">Query: How to change a SQL Server database collation<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=2515&amp;lang=en\">Query: Useful VersionLink Queries<\/a><\/li>\n<li><a title=\"Query: Useful Query Examples\" href=\"https:\/\/sdna.lu\/?p=3760&amp;lang=en%20\">Query:\u00a0Useful Query Examples<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=3779&amp;lang=en\">Query: <\/a><a href=\"https:\/\/sdna.lu\/?p=3779&amp;lang=en\">FAIA &#8211; Historical default values<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=5482&amp;lang=en\">Query: How to create a unique index<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6173&amp;lang=en\">Query: How to mass create job numbers<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6455&amp;lang=en\">Query: How to create job numbers based upon job number<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6460&amp;lang=en\">Query: How to create jobs based upon job<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6529&amp;lang=en\">Query: How to delete unused Security records<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6543&amp;lang=en\">Query: How to select unbalanced accounting entries on all the databases<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6835&amp;lang=en\">Query: How to update a query in VersionSql table<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7022&amp;lang=en\">Query: Create SQL Database<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7093&amp;lang=en\">Query: Create UserOption<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7221&amp;lang=en\">Query: Select Countries and Translations<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7233&amp;lang=en\">Query: Select Companies having double VAT Number<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7474&amp;lang=en\">Query: Keep only last currency rate per year<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7482&amp;lang=en\">Query: View Groups for a specific Right<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7596&amp;lang=en\">Query: Delete all Currency rates that are not End of Year<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7599&amp;lang=en\">Query: Delete all Currency rates that are not End of Month<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=11606\">Query: Update UserGroup<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=12107\">Query: Count all records from all tables<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=12113\">Query: Delete queries to create a standard Database<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=12152&amp;lang=en\">Query: Balance on all accounts<\/a><\/li>\n<\/ul>\n<p><strong>Queries after upgrade:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/sdna.lu\/?p=11515\">Queries: Issues with GLCaption<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6642&amp;lang=en&amp;preview=true\">Query: Select records with missing SecurityGLA<\/a><a href=\"https:\/\/sdna.lu\/?p=6642&amp;lang=en&amp;preview=true\">ccountId<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6866&amp;lang=en\">Query: Select missing Language records<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6937&amp;lang=en\">Query: Remove time from AccInterest.ToDate<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6948&amp;lang=en\">Query: Select TimeReport records with JobTaskId = -1\u00a0<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=6981&amp;lang=en\">Query: Select GLBankStatment with BCyAmount = 0<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7103&amp;lang=en\">Query: Select double GLAccountName numbers<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7176&amp;lang=en\">Query: Select Company with missing LegalName<\/a><\/li>\n<\/ul>\n<p><strong data-rich-text-format-boundary=\"true\">Queries after upgrade V9:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/sdna.lu\/?p=7394&amp;lang=en\">Query: Select Reltype with no InvRelType<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7754&amp;lang=en\">Query: Address LPrimaryKey<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7759&amp;lang=en\">Query: Forex LPrimaryKey<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7761&amp;lang=en\">Query: InvoiceFDetail LPrimaryKey<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7763&amp;lang=en\">Query: LVATCaseDesc LPrimaryKey<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7765&amp;lang=en\">Query: LVATGroup LPrimaryKey<\/a><\/li>\n<li><a href=\"https:\/\/sdna.lu\/?p=7767&amp;lang=en\">Query: ReminderDetail LPrimaryKey<\/a><\/li>\n<\/ul>\n\n\n<p class=\"wp-block-paragraph\"><strong>Queries after upgrade V11:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/sdna.lu\/?p=12239\" data-type=\"link\" data-id=\"https:\/\/sdna.lu\/?p=12239\">Query: Security purchase \/ sale check broker<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Queries Query: Attach SQL Database Query: Display triggers Query: How to see connected users Query: How to drop a field Query: How to change a SQL Server database collation Query: Useful VersionLink Queries Query:\u00a0Useful Query Examples Query: FAIA &#8211; Historical default values Query: How to create a unique index Query: How to mass create job [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3791","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/3791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3791"}],"version-history":[{"count":88,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/3791\/revisions"}],"predecessor-version":[{"id":12241,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/3791\/revisions\/12241"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}