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 • 1,771 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 • 5,343 views
0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

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

How to compress Excel buffer into ZIP buffer?

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

Average TIME Calculation differs between Excel and PowerBI

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

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

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

Downloading Tableau data into Excel (scientific notation column)

Sep 20, 2022 in Others • 1,817 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,052 views
0 votes
1 answer

Send message using excel to whatsapp web reloading

Sep 20, 2022 in Others • 8,592 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

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

How to get the JasperReports into Excel format with proper alignment

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

Excel web query to login into a website

Sep 20, 2022 in Others • 3,969 views
0 votes
1 answer

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

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

Reading/parsing Excel (xls) files with Python

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

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

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

Delete all the records

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

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

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

Using ORDER BY and GROUP BY together

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

IN Clause with NULL or IS NULL

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

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

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

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

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

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

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

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

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

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

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

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

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

Escape Character in SQL Server

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

Function to Calculate Median in SQL Server

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

Highest Salary in each department

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

SQL Server: IF EXISTS ; ELSE

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

Best way to do nested case statement logic in SQL Server

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

How can I set an SQL Server connection string?

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

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

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

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

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

How to check SQL Server version

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

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

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

How to format datetime in SQL SERVER

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

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

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

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

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

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

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

SQL like search string starts with

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

Not equal <> != operator on NULL

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

Multiple SQL Joins error in W3Schools Tryit Editor

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

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

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

SQL Server: Multiple table joins with a WHERE clause

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

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

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

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

Sep 16, 2022 in Database • 8,944 views
0 votes
1 answer

How to print SQL statement in codeigniter model

Sep 16, 2022 in Database • 6,591 views
0 votes
1 answer

SQL - Update multiple records in one query

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

Finding duplicate values in a SQL table

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

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

Sep 16, 2022 in Database • 2,379 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.