Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
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.
We are looking for a query builder tool for end users which can dynamically create parameters, export to excel, adhoc report capability. Please suggest if there are any. Has any one us…
Our application usually has very long query within the stored procedure and within a procedure, there can be a sometimes multiple stored procedure inside the procedure, my questions is when th…
I have an MS Access database. I need to get a count of the number of records which have unique results.
There are over 5000 records in the DB. The field is StandardTitle from tblContractJournals,
this is the query :
why i am getting this error ?
I have a report which is generated based on a querystring.
Querystring is identified at the beginning of code.
ChartID = Request.querystring("Chart
Now I need to use this same query…
I have a query that returns this:
I'm having trouble with a SQL update statement, getting a syntax error. When I go thru other code in my application, I see similar statements that get no error. WS-ID is defined as SHORT TEXT in the…
what is wrong with my sql sentence?
I use phpMyAdmin simple sql statement
UPDATE bayibilgileriiki SET verginumarasi='9070045
the error message is :
#1064 - You have an e…
I have a query that was written in SQL. I need to bring the query into Access and am having a lot of trouble with the left joins. I'm getting a lot of errors saying missing expression, etc…
I am trying to SELECT all sys.messages that contain the text string 'NULL'.
First query shows there is at least 1, message_id = 515.
Second query does not return this record. I assume there …
I have a membership database. One of the fields is "Email". That field CAN be blank. I'd like to query the database and find all member records with no data in the Email field. That we can reach o…
I have 2 problems here.
Courses aren't grouping together. My results have the same course listed several times with different count(*) per row. Each identical course_name and course_number shou…
I want to script out the SQL server Import and Export task. See the attached image. If I don't want to use the Wizard, just wrting the script, do you know the fast way to do that? AM I able to script …
I have a table with these fields
document_id, document_source_patch, document_destination path....
document_id is the the document name but file name has no extension. For example
I have a table. I want to insert a huge records into it. For fast performance, I want to know if I should set up an index, is better or completely no index is better?
How to have a script to commit…
I am consistently getting this error and I can't find any reason. can anyone help?
I've been given 13 different spreadsheets that are currently used for tracking our companies contracts. They look like they were created by 13 different monkeys. No consistency between them, no data …
Below is my code. After it is a screenshot.
I want only rows 10 - 18. As you can see, the difference between these rows and the others is that you have more than one "DocumentNumber". …
I have two sample tables, how can I come up with the result that shows everything from V and left 3, 5 in S as null
SELECT v.vid, v.vname, s.sid, s.sname
FROM service s LEFT JO…
Not sure how to explain this but will try. So I have some purchase order with 1 or more lines. Not sure how to go about to write this query so that it take the last line with a "PART_ID" and put it …
How can I round to 2 decimal spaces on my VisitPercent column best?
The following query returns all my patients seen by the practice for a given day (PatientVisitId for the Patient Visit and the PatientProfileId for the distinct patient). What I need is a field added …
Experts, I have the basically two tables and one view to get the desired result set--
SOXDEFINITION, SOXPRICE and COMPVIEW
need to tie "SOXDEFINITION" to "COMPVIEW" by using the VALUE of the Alias…
in a table I got columns values Code, Desc01, Desc02, Desc03, Desc04 up to 15
in another table, I got columns: Code, Qty01, Qty02, Qty03, Qty04 ... all to Qty15.
my question is, I…
'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…
slightwv (䄆 Netminder)
5,200 points this week
4,000 points this week
Eden Prairie, Minnesota, United States
4,000 points this week
Seattle, United States
4,000 points this week
3,000 points this week