Query Syntax

47K

Solutions

12

Articles & Videos

17K

Contributors

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Related Topics

  1. Microsoft Access
  2. Microsoft SQL Server
  3. Microsoft SQL Server 2005
  4. Microsoft SQL Server 2008
  5. Databases
  6. MySQL Server
  7. Oracle Database
  8. PHP
  9. ASP
  10. Visual Basic Classic
Refine results

I am using an ERP product called Epicor and trying to create a calculated field using their query tool.  The code as I understand is Progress.

I have a value in a number field of 24,165 which …

518 views
DevOps Toolchain Recommendations
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

The following query is returning the following error in MySql:
(CODE)

The error is:
#1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 …

2038 views

In a previous question (29012372) I got an answer to get list a load of transactions:-
(CODE)

It works fine, apart from the "where accNo" which displays all account numbers, not just …

114 views

Ive been working on a query which should show data from another transaction listing values and items, so something like:-


By using a query like:-
(CODE)

But my issue is Im getting duplicated …

215 views

I need to get all the fields from the main table and just a couple of fields from the 2nd table.
Can I do something like this:(CODE)

I need to do this on a couple of pages.  Some I don't need all …

210 views

Hello everyone,

I have two tables in MySQL. In the first table, I store people details and the second one is used as a "log" to record every time a person is contacted. How can I fetch all data …

618 views

This sql was authored for me by someone on this site.  It works well as a stored procedure and it returns the correct records in SSMS but as a sql query in a classic asp page it returns no data.  I am…

518 views

I am having issues with a crystal report not displaying values, not because of the crystal report, rather the SQL is missing in my file to populate the report.

Essentially, what I need in my SQL …

515 views

I have a SP that returns a JSON value.

This is the code of the SP:

(CODE)

This is how I run it on SQL :   EXEC api_cc_all_active_contacts

This is the result:

json_resultot  is the …

536 views

I need to get a count of values groups by year, based on the value of a certain date field.

What's the query?

Thanks

325 views
Free Tool: ZipGrep
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Hello,

I am trying to update [SeedTracker].[dbo].[DBLogNonResInt].Cassava (bit datatype) from a bit value from another table [SeedTracker].[dbo].[Location].Cassava joined by DBLogNonResint.Location…

516 views

Does anyone see anything wrong with this query syntactically?  I am trying to convert a stored procedure query to an "in page" classic asp query in order to get a json/jquery page to work.

Thanks …

536 views

I have a param I pass in that is a number representation of the day of Week. It will be either 1 - 5 for Mon - Friday

Its in my Where clause so I am trying to set it to the day of week

heres …

627 views

I had to move several Views and Stored Procedures from one database to another, I need a way to find which views and SP contain a specific value in the where clause (i.e Where LOCCODE='CENTRAL')

2130 views

I have a SP that will compare a datetime field with today's date
I also want to extract the time only for a separate column

I tried the following:

(CODE)

The first one will return todays …

212 views

I have a Where Clause that works fine but now I need to check for status 2 and get statusid 2,7 and 10 but im having a little trouble

It was...
(CODE)

and now it is...
(CODE)

any help would…

636 views

I am trying to select reminders for 'today'
the date is saved in a datetime field, and is for example:

2017-04-18 00:00:00.000

I am trying the following but I get no results. I imagine its …

813 views

We have table A which is table ZIPS_us that has all 40000+ zip codes with a geography column for their lat & long coordinates.
Table B has a bunch of users who have an address with a ZIP code.  
We …

741 views

I have a stored procedure that inserts a record, one of the fields is "Order Number".
Let's say user has 50 items and they want to insert the item and enter order number = 25

Currently they end up…

1115 views
Free Tool: Site Down Detector
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi
Let me start out by apologising for being a complete novice when it comes to MySQL. I have dabbled with MS Access but I am rusty on MySQL

I am trying to get my head around some logic and I am …

322 views

Hello:

The second piece of code below is the "full" stored procedure that I'm attempting to modify.

Specifically, the first piece of code is the only part of the stored procedure that I'm trying…

329 views

I have the following Stored Procedure which returns data in JSON format, but the syntax is incorrect. Perhaps someone can help check on this ?

(CODE)

The result is:

(CODE)

The error I …

222 views

I have a query that returns the total ordered of an item between a selected date range as shown below.  

select GK_ITEM_ID
                        , GK_STORE_ID
                , sum(case when USER_ORDER_QTY is …

321 views

So this is a 2 part question. I may save the 2nd part for another thread as i haven't even begun to think how to do it yet.

Ok so I have a table that has item, ordersize, userOrdersize, and …

532 views

The following code works, but I did not like because in order to get selected sql data I have to add a gridview control!!
Is there a way to get the returned data in a variable

         …

732 views
Show more content
201506-LO-Top-001

Query Syntax

47K

Solutions

12

Articles & Videos

17K

Contributors

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Related Topics

  1. Microsoft Access
  2. Microsoft SQL Server
  3. Microsoft SQL Server 2005
  4. Microsoft SQL Server 2008
  5. Databases
  6. MySQL Server