See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
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'm part of a domain with an OU that I administer... I need to create a query for disabled users by user name with a wrm in it.. I have this..
I'm trying to figure out this query.
If I run:
Then I receive a data set like
So that's what is expected exce…
I am currently working on a fixed width report for my client. Per the spec's, they need this field to be padded by 0's and the two decimal places are implied.
With that being said, '55.00' should …
I have a SyBase database and when I select the field I get
9/19/2016 4:05:00 PM
I want to return only the the time portion in HH:MM 24 hour format....desired return is: 16:05…
I'm struggling creating a simple stored procedure within Oracle. What am I missing from this query?
Basically in my report, I want user to be able to input a transaction date.
I would like to combine the columns of two tables, Table1 and Table 2. I used the inner join, but it returned me more rows. I also tried group by the tuple (the 5 columns below) but it still gives me …
I am writing query where I need to get the users to has completed at least 3 classes and the last grade received for the third grade should be today's date.
Here is the query I came up with, but i…
I have to produce a fixed width column file for my client. Issue is in this particular section of code.
Let me try to explain this the best way I can. A patient can have a single form of insurance…
I have designed the following query in design view and it worked fine, however when I copy the SQL and try to paste it in new query I get an error "Join expression not supported", what …
I have already created a Visio drawing involving tables/fields that currently match a database. Each set(s) of tables has a tab. I could not use reverse engineering so this was done m…
Is there a way to run the following SQL statement in Microsoft Access. I have over 1000 row needed to update like this and I can't find a way to do in Access just like I would in MS SQL Management Stu…
I am trying to convert a datatype char(32) to decimal(5,4) but I know that this field has some values that cannot be converted to a decimal. So I am trying to just ignore those using the following met…
Hi, I was using the below query for a refreshable workbook and it suddenly stopped working.. the error when validating it in powerpivot is : "The SQL statement is not valid. There are no columns detec…
When I put
at the end of the below query I got a performance problem. As I understood from the EXPLAIN when the select sees the OR at the where section it goes over all t…
I'm trying to figure out a query to count the IP field and tell me how many of the same IP there are in the table.
Then I need to delete the duplicates from the table and only leave 1 record for …
In the query below, if personOne is null, I want to output personTwo as "personOne". Can someone assist? I tried using this but it does't work
I am playing around with stored procedures and ran into a problem. I followed the example and it runs fine with the Command(s) completed successfully. I open the table and I can't find the record - …
I'm in middle designing a SQL dynamically by code and need a way to
1- Proper construct the SQL
2- To have it done in a clear manner
here is an extract of the statement.
I need to calculate averages miles driven for the car on the day of the week and the overall average. The result need to be displayed on one line. I am using PIVOT table but seems no able to get it to…
Anyone up for a bit of a challenge? I have a query like the one below.
timeIn is a datetime column
timeOut is a datetime column
carType is a string
limitTimeToCheckIn is a number of min…
I am working on a Fixed Length Query and need help when the value is NULL. In this section of code below, the Attending Doctors Middle Initial is almost always missing; however, because it is NULL, I …
hello everyone. i'm sure this can be done and i'm sure i can figure it out with enough time, however i'm asking all you experts out there for a quick reference.
i've got a table, 3 columns: Process…
I have an MS Access Table MYTable which has the field MyPath
The Sample entries in MyPath (The values corresponding to a folder structure that has several subfolders
I use Access 2010.
I have two tables and I want to delete all records from one table that correspond with the second table.
The select query of the records that I want to delete is:
'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…
Pawan Kumar Khowal
Railway Road Gurgaon, Haryana, India
6,500 points this week
Melbourne, Victoria, Australia
6,062 points this week
crystal (strive4peace) - Microsoft MVP, Access
3,132 points this week
3,000 points this week
Northampton, Massachusetts, United States
2,100 points this week