Questions by Kithuzzz

0 votes
1 answer

Runtime error 438 while importing data in excel from secured website using VBA

Sep 22, 2022 in Others • 2,255 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

Sep 22, 2022 in Others • 6,281 views
0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

Sep 22, 2022 in Others • 3,834 views
0 votes
1 answer

How to compress Excel buffer into ZIP buffer?

Sep 22, 2022 in Others • 2,300 views
0 votes
1 answer

Average TIME Calculation differs between Excel and PowerBI

Sep 20, 2022 in Others • 4,940 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Sep 20, 2022 in Others • 2,196 views
0 votes
1 answer

Downloading Tableau data into Excel (scientific notation column)

Sep 20, 2022 in Others • 2,229 views
0 votes
1 answer

Excel vba domdocument parsing xml from TNT tracking system: in some pcs object load return no document

Sep 20, 2022 in Others • 2,412 views
0 votes
1 answer

Send message using excel to whatsapp web reloading

Sep 20, 2022 in Others • 9,263 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

Sep 20, 2022 in Others • 2,776 views
0 votes
1 answer

How to get the JasperReports into Excel format with proper alignment

Sep 20, 2022 in Others • 5,977 views
0 votes
1 answer

Excel web query to login into a website

Sep 20, 2022 in Others • 4,311 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Sep 20, 2022 in Others • 2,632 views
0 votes
1 answer

Reading/parsing Excel (xls) files with Python

Sep 19, 2022 in Others • 2,040 views
0 votes
1 answer

ERROR 1064 (42000): You have an error in your SQL syntax;

Sep 19, 2022 in Database • 11,871 views
0 votes
1 answer

Delete all the records

Sep 19, 2022 in Database • 1,803 views
0 votes
1 answer

How can I create a unique constraint on my column (SQL Server 2008 R2)?

Sep 19, 2022 in Database • 2,172 views
0 votes
1 answer

Using ORDER BY and GROUP BY together

Sep 19, 2022 in Database • 1,706 views
0 votes
1 answer

IN Clause with NULL or IS NULL

Sep 19, 2022 in Database • 1,895 views
0 votes
1 answer

What is the difference between a primary key and a surrogate key?

Sep 19, 2022 in Database • 10,902 views
0 votes
1 answer

How do I obtain a Query Execution Plan in SQL Server?

Sep 19, 2022 in Database • 3,216 views
0 votes
1 answer

How to retrieve the current version of a MySQL database management system (DBMS)?

Sep 19, 2022 in Database • 1,865 views
0 votes
1 answer

How do I do multiple CASE WHEN conditions using SQL Server 2008?

Sep 19, 2022 in Database • 3,761 views
0 votes
1 answer

java.sql.SQLException: Column count doesn't match value count at row 1

Sep 19, 2022 in Database • 4,110 views
0 votes
1 answer

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

Sep 18, 2022 in Database • 13,074 views
0 votes
1 answer

Escape Character in SQL Server

Sep 18, 2022 in Database • 2,542 views
0 votes
1 answer

Function to Calculate Median in SQL Server

Sep 18, 2022 in Database • 3,125 views
0 votes
1 answer

Highest Salary in each department

Sep 18, 2022 in Database • 3,467 views
0 votes
1 answer

SQL Server: IF EXISTS ; ELSE

Sep 18, 2022 in Database • 5,756 views
0 votes
1 answer

Best way to do nested case statement logic in SQL Server

Sep 18, 2022 in Database • 10,360 views
0 votes
1 answer

How can I set an SQL Server connection string?

Sep 18, 2022 in Database • 1,694 views
0 votes
1 answer

What does SELECT COUNT(1) from table_name on any database table mean

Sep 18, 2022 in Database • 1,880 views
0 votes
1 answer

How to find third or nᵗʰ maximum salary from salary table?

Sep 18, 2022 in Database • 2,464 views
0 votes
1 answer

How to check SQL Server version

Sep 18, 2022 in Database • 2,256 views
0 votes
1 answer

Is there a combination of "LIKE" and "IN" in SQL?

Sep 17, 2022 in Database • 6,741 views
0 votes
1 answer

How to format datetime in SQL SERVER

Sep 17, 2022 in Database • 2,777 views
0 votes
1 answer

How to upsert (update or insert) in SQL Server 2005

Sep 17, 2022 in Database • 1,929 views
0 votes
1 answer

How to find top three highest salary in emp table in oracle?

Sep 17, 2022 in Database • 13,278 views
0 votes
1 answer

Why do I need to configure the SQL dialect of a data source?

Sep 17, 2022 in Database • 2,571 views
0 votes
1 answer

SQL like search string starts with

Sep 17, 2022 in Database • 5,420 views
0 votes
1 answer

Not equal <> != operator on NULL

Sep 17, 2022 in Database • 2,030 views
0 votes
1 answer

Multiple SQL Joins error in W3Schools Tryit Editor

Sep 17, 2022 in Database • 4,826 views
0 votes
1 answer

Oracle PL/SQL - ORA-01403 "No data found" when using "SELECT INTO"

Sep 17, 2022 in Database • 10,565 views
0 votes
1 answer

SQL Server: Multiple table joins with a WHERE clause

Sep 17, 2022 in Database • 2,111 views
0 votes
1 answer

SQL Server: Extract Table Meta-Data (description, fields and their data types)

Sep 16, 2022 in Database • 2,036 views
0 votes
1 answer

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Sep 16, 2022 in Database • 9,837 views
0 votes
1 answer

How to print SQL statement in codeigniter model

Sep 16, 2022 in Database • 7,081 views
0 votes
1 answer

SQL - Update multiple records in one query

Sep 16, 2022 in Database • 5,578 views
0 votes
1 answer

Finding duplicate values in a SQL table

Sep 16, 2022 in Database • 2,039 views
0 votes
1 answer

What is the equivalent of 'describe table' in SQL Server?

Sep 16, 2022 in Database • 2,998 views
Page:
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.