Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
Articles & Videos
Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.
Any advice or tool suggestion is helpful and will get points!
I'm currently in an IT services role where I'm creating client facing statements of work that are composed of various blocks of steps. …
I'm trying to write a query with the following code:
left outer join APVENMAST on PROCUREGRP.VENDOR_GROUP=AP
But get the following erro…
I have an existing Oracle database on a server that I need to copy to a new server. The old server is running version 11g Release 22.214.171.124.0. The new server is running version 12c Release 126.96.36.199.0. …
I have a table in SQL Server with a number of fields, i have created a composite PK of LoanNumber, BorrowerName, LenderNumber; I need to compare a new data set that contains these and other fields to …
I have 2 tables, tbINVOICE and tbFEE. tbFee contains fees that get populated at the end of an invoice. As a result of a setup error, I have some invoices that are missing a fee that should have been a…
I use Ubuntu 14.04.1 Desktop and in PhpMy Admin I see this:
Database client version: libmysql - 5.5.50
But when I do this in the terminal:
I get ver. 5.5.52
Also in S…
I want to create a spreadsheet that only has a few drop-down boxes or text fields where a person can select their name from the list, enter their data and have it automatically added to the sheet that…
I have a c# asp.net application. Related to this application I have a complex query that gets data from a remote database, call it query-remote. I need to place all of the query-remote results from…
My client uses an application called Amazing Charts. We recently had them upgrade the SQL software from 32-bit to 64-bit as the performance was taking a hit. They have a MS database that all the com…
Any assistance would be greatly appreciated. BIG THANKS!!!
Delete items that are no longer available in the database:
1) I would like a query to compare the 'Item Number' column fr…
I am copying information from one table to another. There is one field which is an nvarchar and should in fact contain dates in the following format: mm/dd/yyyy or mm/dd/yy
I am going to copy that…
I read a little bit in internet but I'm not sure to understand what ISQL? Is it like an ODBC driver forLinux?
We have 'MySQL Workbench' v6.2 and want to access MySQL databases hosted in other remote web locations. How can we do this?
I have a table "AccountNumbers" In this table there a 4 fields, ID, OriginCountry, DestinationCountry, AccountNumber
I also have a table of Countries with 95 records (all the countries)
I need t…
We have two contact forms, billing and contact. I am going to store recipient emails into a database so the manager can configure who she wants to receive emails.
Should I have a table called billi…
A vendor has asked me to create an extract file.
In this extract file, certain fields need to be in a particular position.
Employee Position 1-8
Employee First Name Position 9-26
How do I change all highlighted to D: drive in SQL with one query.
SQL 2014 Enterprise installed on Server 2012 R2
8 cpu core's & 24 gb mem
SQL instance is dedicated to ONE application database. DB is 210 gb in size.
6 tempdb’s spread across C:\, …
I have quickbooks point of sale on one computer installed it on another computer and want to use quickbooks on this computer as well.
When I open quickbooks a window opensasking Specify your serve…
I will be involved in a migration event from our SQL servers our local office to a data centre and I have been asked to create a list of health checks. Other than creating lists of current u…
I have a table with an order and many details, and a second table with all the items on the order.
The order number ties them together.
Right now I have to run the order, with the total of all items…
I am going to buy this:
SQL and Relational Theory: How to Write Accurate SQL Code:
I am working with a large .csv file (about 8 gigs) that I exported from a database. When I try to open using CSV edit, I get an error "file is empty". Does anyone know if there is a maximum number …
I am getting an error "Corresponding select-list expressions are incompatible.
Can anyone tel by looking at this?
Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Usin…
DATE and TIME ... don't be scared, just do it right DATE,TIME,MS SQL Server,MySQL,Oracle Introduction: I presume you all have already worked with databases and qu…