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,776 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,358 views
0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

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

How to compress Excel buffer into ZIP buffer?

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

Average TIME Calculation differs between Excel and PowerBI

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

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

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

Downloading Tableau data into Excel (scientific notation column)

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

Send message using excel to whatsapp web reloading

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

Convert CASE WHEN logic from SQL to EXCEL

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

How to get the JasperReports into Excel format with proper alignment

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

Excel web query to login into a website

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

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

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

Reading/parsing Excel (xls) files with Python

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

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

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

Delete all the records

Sep 19, 2022 in Database • 1,492 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,748 views
0 votes
1 answer

Using ORDER BY and GROUP BY together

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

IN Clause with NULL or IS NULL

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

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

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

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

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

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

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

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

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

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

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

INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server

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

Escape Character in SQL Server

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

Function to Calculate Median in SQL Server

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

Highest Salary in each department

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

SQL Server: IF EXISTS ; ELSE

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

Best way to do nested case statement logic in SQL Server

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

How can I set an SQL Server connection string?

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

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

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

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

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

How to check SQL Server version

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

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

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

How to format datetime in SQL SERVER

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

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

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

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

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

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

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

SQL like search string starts with

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

Not equal <> != operator on NULL

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

Multiple SQL Joins error in W3Schools Tryit Editor

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

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

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

SQL Server: Multiple table joins with a WHERE clause

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

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

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

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

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

How to print SQL statement in codeigniter model

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

SQL - Update multiple records in one query

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

Finding duplicate values in a SQL table

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

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

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