Explore

Predicting the Lifespan of Communication Devices : Overview of life cycle of Machine Learning project for manufacturing industry to predict life of their products.

This is a simple sql command that I want to run: CREATE TABLE USERMNGR.AUTHORIZED_CLIENT ( ID BIGINT (8) DEFAULT J NOT NULL, AUTHORIZED_CLIENT_STATUS CHAR (10) DEFAULT 'Y', CLIENT_NAME VARCHAR (40) DEFAULT 'N' NOT NULL, NATIONAL_CODE CHAR (16) DEFAULT 'N' NOT NULL, PRIMARY KEY (ID) ); It has some whitespaces but I don't think they pose any problems. Running the script using IBM Data Studio,...

SQL Server 2019 I'm trying to start stored procedures from a trigger (so that the trigger stays lean) to process data in some production facility. Working with queues/messages etc is new to me I've created a queue and service: CREATE QUEUE [dbo].[StoredProcedureQueue] CREATE SERVICE [StoredProcedureService] ON QUEUE [dbo].[StoredProcedureQueue]; ALTER QUEUE dbo.StoredProcedureQueue WITH ACTIVATION ( PROCEDURE_NAME = dbo.ActivationProcedure, MAX_QUEUE_READERS = 1, EXECUTE AS OWNER) The...

I have written a SQL query to find prev year sales one using lag and with nested CTE, and another just without nested CTE. I am seeing difference in output in SQL Server environment. Without nested CTE (correct output): WITH cte AS ( SELECT * FROM (SELECT category, product_id, DATEPART(YEAR, order_date) AS order_year, SUM(sales) AS sales FROM namastesql.dbo.orders GROUP BY category, product_id, DATEPART(YEAR, order_date))...

INSERT INTO MANPOWER.VIPBADGE ( DOC_SRL, GRP_CD, DOC_TYPE, REC_TYPE, MV_MT, VESS_NAME, VESS_TYPE, IMO_NO, CALL_SIGN, REG_PORT, AGENCY_FUN_CD, AGENCY_CD, EX_VESS_NAME, EX_CALL_SIGN, VESS_FLAG, SAT_ID, SATCOM_ID, FREE_BOARD, VESS_BLD_DT, VESS_BLD_PLACE, DT_OF_DELI, PERMANENT_VALIDTY, SHIP_REG_CERT_NO, SHIP_REG_VALDT, SAFETY_MGMT_CERT_NO, SAFETY_MGMT_CERT_VALDT, VESS_HT, ISPS_COMPL, CAP2_CERT, BEAM, LOA, LBP, MAX_DRAFT, PARL_BODY_LN, BOW_TO_MANIFOLD, GRT, NRT, DWT, SUMMER_DEAD_WT, TEU_CAP, SBT, REDU_GRT, VESS_OWN, EMAIL_ID, CLASSFN_SOCIETY, HULL_INS_COMP_NAME, HULL_INS_COMP_VALDT, ENGN_TYPE, NO_OF_ENGN, ENGN_POWER, PROPULSION_TYPE, NO_OF_PROPELLERS, NO_OF_BAYS, NO_OF_ROWS_ON_DECK, HATCH_COVER_TYPE, NO_OF_HATCH, MAX_MAN_SPEED, BOW_THRUSTER, BOW_THRUSTER_NO, BOW_THRUSTER_POWER,...

I know I can do describe table a_table to describe the columns in a table in Snowflake. However, I'd like to limit the columns that are returned to, say, name and comment to create a codebook of that table with only this information. How can I achieve this?

I believe you all are doing well! I am trying to execute a nested query in MySQL to retrieve information from two different tables and while executing this getting 1241 error which says "OPERAND SHOULD CONTAIN 1 COLUMN(S)" which I'm unable to understand and perform any correction in my code and due to that seek your assistance in resolve this query. Here is the...

SELECT id, user_id, item_id FROM questionnaire_answer_old_0 WHERE item_id IN ( SELECT item_id FROM questionnaire_answer_old_0 GROUP BY user_id, item_id HAVING COUNT(user_id) > 1 AND COUNT(item_id) > 1 ); The code provided above executes the subquery normally. The issue arises when attempting to run the entire query, which results in no response and no error messages; it just shows as 'query in progress.' Removing the GROUP...

We have an issue with a select query being deadlock victim when run from entity FW. The query is fine in SSMS. The query looks like this SELECT DISTINCT A:URN FROM TABLE1 A JOIN TABLE2 B ON A:URN = b:URN WHERE CONTAINS(B.[COMPANY_NAME], '"Finance"') AND A:REGION = 3 The exception is @ExceptionType=N'EntityCommandExecutionException',@ExceptionURL=N'https://osd-dev.data-studio.co/api/Dashboard/ChartsData?dashboardId=28&DomainId=undefined',@ExceptionSource=N' at system.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Execute(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteReader(CommandBehavior behavior)...

I have a table that continues Client IDs and records a score based on their result. What I'm struggling with is I need to show the scores by month, but carry over scores from previous months where the Client didn't complete a Test in the month that has passed or the current month. For example, ClientID 1 did Tests in Nov 2023, Jan 2024,...

You are a researcher, potentially in the life or social sciences, and your organization offers you access to a fast machine with many CPUs and lots of memory, potentially as part of a CPU cluster. You are familiar with Linux and use Python/Pandas and/or R to manipulate and analyze your data. You sometimes use SQLite...

The basic principle of the shuffle algorithm is to bucket the input data, where each bucket’s data can be processed independently and output results. This reduces the size of the hash table when aggregating data.Taking the group operator as an example, there are two implementation methods: sort group and hash group....

I have an SQL query that returns a column of values, e.g.: id | 1 val01 | 2 val02 | ... Now I want to write another query that will use the values from the first query above and execute multiple times while having the results of each query in a separate column, e.g.: column1 | column2(based on val1) | column3(based on val2) |...

Jeffy's search dilemma highlights the importance of knowing when to give up during developer searches. By navigating the quagmire of information overload and effectively utilizing documentation and source code, developers can optimize their search process and find solutions efficiently. Remember: sometimes you gotta RTFM and sometimes you gotta bail.

Oftentimes, colleagues from different departments need quick access to specific datasets. The traditional method of exporting Excel files from databases is inefficient and time-consuming. A more effective approach involves creating new user accounts in the database. This allows colleagues to seamlessly connect to the database using tools like Power BI or Power Query.

First off all, I am relatively new to databases, especially with higher complexity. I am working on a database to store information that we want to use to standardise our workflow. The project is for an engineering company, and the information that I want to store is IO data from the hardware modules. I have made a "Main" table that has all the "required"...

I'm able to use VBA, or VBScript, or python-docx, or pandas (when saving a Word file in a HTML format) to get plain text from tables in a Word document. This text further can be stored to MySQL database. But I need to get also the text's formatting, like bold/italic text, subscript/superscript etc. Is there a way to save text as plain text with...

I am having an interview question related to query optimization in sql server and the questions are. How you debug Stored Procedure having optimization issues How do you perform your unit testing 3)How can we perform unit testing via Automation inside SQL Server? As per my knowledge I can check sql profiler or execution plan and based on that I can build indexes. It...

Kindly help to make query employee detail records change with different DateStart 1 month Example Data enter image description here Expected Result enter image description here

I am trying to select same substring of multiple rows without specifying the substring first. Basically find the common part in a string. The common parts in a string range from 2 to 5 words. Here is what I am trying to achieve: id item required value 1 DEP Item 1 DEP Item 2 DEP Item 10 DEP Item 3 DEP Item 11 DEP...

here is the task. Calculate how much on average a customer with a bracelet (field bracelet_id) 145863 spent on hot dogs with ketchup and mayonnaise added at the same time or on hot dogs with sausage meat. If ketchup and mayonnaise are added, the mayonnaise and ketchup fields contain the value 1. RESULTS i make something like this and code isnt working, the feedback...

I would like to calculate the fraction of rows fulfilling some criteria. So something like this: (SELECT COUNT(*) FROM table WHERE col_name > crit) / (SELECT COUNT(*) FROM table) However, this creates a syntax error when I tried it. How can I realize what I want?

I have the below SQL query, where I want to return all rows of the table if -1 is passed as the value for @statusParam. And rows that matches the @statusParam value if something passed other than -1. The status column is a int type column. set @statusParam = -1; SELECT * FROM `db`.table_name where `status` = -1 or `status` = @statusParam; The above...