Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
Articles & Videos
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.
I need to use DATEDIFF using three dates. I need to add two dates, receiving date and ship date and subtract the time we have been waiting on quote approval for units. I am already using datediff with…
Hi. I am using the following SQL Statement to get a Unique list of the combination of Date and Shift. Is this correct or will it only give me a unique list of [Date]?
SELECT DISTINCT [Date], …
I have the following in an Access query and it works fine:
I need to add another If statement... if InventoryProfile.MAPPricin
Working on a query. Here are the details:
Columns: StartDate, EndDate, Type, Hours, Status, EMPLID
Columns: ID, FULLNAME, MGRID, EMPLID
I would like to:
I have the following query:
When I run it though I getting the following errors:
Database name 'TempDB' ignored, referencing object in tempdb.
What is causing this error…
what's the best way to (performance wise) or other to write this query to get all the fields that are 25 days old
select 1, 2
hi i have the following cursor in my 12c database
am geting the above error but in 11g is ok am running this in plugable database
I am trying to build a SQL statement from an Excel spreadsheet where the user selects several cells which contain addresses.
The resulting statement would look like this
Select * From …
I am in a job where I sometimes need to make a "hot fix" to the live production database, and have been told we need to start using transactions to reduce the risk of causing a bigger problem than we …
Where can I find a tutorial on ServiceCenter IR Query expressions? What language does service center use for IR Query? I need to built a custom query for all tickets open for a primary assignment …
I have two tables one with fields I need such as ID, clientID, table andCustomerID the second table has the ID of the record in table and a total column. I am trying to get a subtotal …
I am looking to place the contents of 6 fields into 2 fields as follows.
We have Date1 Column (Datetime) and Results1 column (varchar(50), then Date2 column and Results2, and Date3 …
The following statements return numbers from a-z but I need a new column to calculate the change as a number.
For example, if the letter for Q1 is B and Q2 is D, then the output would be +2. If Q1 …
I want to get four query results, not two:
select count(*) as SecondYearInterestIsNo from APSecondYear where SecondYearInterest='No'
select count(*) as SecondYearInterestIsNO from APSecondYear…
We have a database that information is fed into and at 4:30am every day we want to be able to append the information for the prior day (4am-4am) to another table in another database. We want to be …
I have a server with multiple ODBC connections.
I want to create a connection string that will connect to all those ODBC (each for one database), so that when I run a query it will query all …
I see a working query with the following select statement:
, hfext.Family_id, 0 IsAPStartMatching, MAX(ack.AgreedDate) StartMatchingDate
what function does the '0' server …
I have a scenario where I have to run a query on multiple databases from a database "A" using database links from "A" database.
I have a table in "A" database which should insert the pulled data from…
I have some data that I was to parse or separate out, that is initially in 1 row and want to separate into
different rows. As seen in the data samples below. I was looking at examples but they…
In this code I am trying to do 2 things. The first is to bring back in single rows a combination of header and detail information. The second is to create a ranked line number in …
I have 3 queries like follows: I am not sure how to make the union due to the cte...I was thinking the cte might have to be a temp table and the the unions some how combined that way..Please help …
Can we can query the email header (message detail) in the email activity record?
Our goal is to use the Office 365 transport rule to add the contact name to the subject line of an email and then …
The AuPair table has a non-primary key called AuPair. APNo.
I am getting incorrect syntax.
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to descri…
In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and te…
Zürich, Kanton Zürich, Switzerland
6,000 points this week
3,900 points this week
3,168 points this week
3,000 points this week
3,000 points this week