Query Syntax

47K

Solutions

11

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.

Refine results

Need to combine these two queries:

(CODE)

and

(CODE)

630 views
Anonabox PRO Tor & VPN Router

PRO is the most advanced way to fortify your privacy and online anonymity by layering the Tor network with VPN services. Use both together or separately, and without needing to download software onto your devices.

Ok I have (May Not Be The Right or Best Way) 2 different tables set up currently. One Is called (CODE) and the other is called (CODE).  The Table (CODE) keeps track of all the products and is the basi…

1015 views

How do I have the "animalage" display as months and days?

SELECT ss.Location, ss.OriginalName, s.Species, ss.SoftSlip, b.Breed, ss.Sex, ss.DOB, Placements.Kennel, Placements.PlacementEndDate, Anima…

923 views

I hope you can deduce what i am asking from the excel spreadsheet
it has 3 tables listed and the desired results.  I don't know how to write this query.

the problem area is the gallons table.  
 …

726 views

I have the following substring issue..and not working for me


So the DiscussionTypeNumber has a prefix of 3 characters that needs to be removed to join to the c.nid value.
The DiscussionTypeNumbe…

910 views

I am trying to update the table. where I have following columns:
folioNo,pgPos,PgName,

folioNo is the order
pgPos is either right or left (if folioNo is odd then put L (left) if even put R(right…

526 views

what is the sql sentence to copy a column to the a new coloumn?
I want to create a copy of a column

315 views

Hi all,

from time to time our TEST DB will reported to have data lost from users/tester, e.g. they enter the data yesterday or hours ago and it gone.

I found out sth like if the tempdb has conte…

2360 views

Lets say I have one table. with n number of columns.

I would like to create a new table that made a new row for each column name and the value of that row would be the value from that column

So …

2114 views

Hello:

Yes, I have twelve files embedded.  And, yes, once again I'm having trouble with very simple T-SQL syntax.

A lot of the files that I have attached are for background purposes.  What I'm h…

1538 views
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

I want to create a stored procedure with the following script below. Reason being I want schedule this procedure as a job. How can I do this?

(CODE)

836 views

How would i use OPENDATASOURCE to insert the records from a table in one database table to an identically named table in another Sql server instance on another server?

813 views

I need help to create a query/formula in Access

credit:IIf( [Customers]![CreditAmount] >0)  then "limit" else "Not Available"

I know how to do this in Crystal reports but not Access

617 views

Heyas,

I have the following query:


SELECT bd.data_timestamp
       ,bd.*
       ,wbd.*
       ,CAST( CAST(wbd.DATA_TYPE as XML ).value('.','varbinary(max)') AS varchar )

FROM MSGS bd, W…

2731 views

I have a main query that has many other fields being listed.
One of last remaining fields I need is the summation of the hours in a 12 month period.
The code I have below works, but I'm having a har…

936 views

I am using a proprietary front end application to connect to a SQL Server database.
I want to pad a field with a constant string, by using the code below it works with one minor issue * see below:

1025 views

I'm using the following code to format the ssn#s :
to_char(replace(emp.fica_nbr,'-'),999999999) SSNBR

The only issue is if a ssn# starts with 0, it is being omitted.
How can I adjust the code to …

217 views

I have a field that is set up as a number 13,4.
I need to format it so that it looks like the following: 9999999V99.

I was trying to use the following formula, but its not working:
to_char(emp.pr…

1022 views

I need some help with a SQL Server query that will summarize data and compute an average average like shown below.

I need the output to look like this:

Supplier ID     Base Model Avg    Image A…

314 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Hello Experts,

Is there a way to search an Oracle 12c database to find a specific value in a specific column for all tables that have that column? For example, if the column name is CASE_ID and the…

826 views

Hi Everyone,

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…

1637 views

I need to get the next and a previous instructor for the session, I got the code working with one little thing The instructor have to distinct.

(CODE)

526 views

I have one table which contains one or multiple entries with dates.
I have another table that has ONE field for ONE date.

I am running a query that will take the date from the first table and co…

2172 views

I am having an issue where SQL Server does not see a Foxpro DBF file when I attempt to import using SSIS. I see all other files except WOYTRN01.dbf. I am able to update with the following statements b…

1114 views

Experts, is the below correct?  I dont get a syntax.  I get a #error when I add the Max part.  I had no issues with the formula until I tried to add Max.  

=DSum(Max("[Cumulative Drawn]"),"[Q_Avail…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS Access
    (214,891)
  2. MS SQL Server
    (156,023)
  3. MS SQL Server 2005
    (71,385)
  4. MS SQL Server 2008
    (48,410)
  5. Databases
    (53,323)
  6. MySQL Server
    (46,181)
  7. Oracle Database
    (77,638)
  8. PHP
    (116,767)
  9. Visual Basic Classic
    (163,428)
  10. ASP
    (80,582)