Explore SQL on Experts Exchange

Expert Solutions for Your Tech Problems

SQLSQL

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....

Read more
  • 61K Content
  • 7.8K Contributors

Expert Spotlight
COG Lead Engineer

I'm Shaun Vermaak. I love tech and how it improves life and business. Did you find what you were looking for?

Advice Solution

Configuring SSRS to work in a Cluster

1

I have set up a cluster with two nodes and have installed SQL in the cluster which is working as

Troubleshooting Solution

SQL related query

3

How to merge 2 columns namely First Name and Company name such that I want to be displayed in the

Advice Solution

SQL password hashing techniques

3

SQL passwords hashed

 

When I am in SSMS and I create a new login and I enter a password, is that

Troubleshooting Solution

SQL query with parameter substitution.

1

This version works:

ALTER LOGIN Billy
WITH PASSWORD = 'Password99!';
 

This version does not:
DECLARE

Troubleshooting Solution

Loop through a set of records and extract first matched value

4

HI Everyone

 

I would like to be able to loop through a set of records and if a value exists (either Y

Advice Solution

SQL Server add Dummy Column and fill its values with the content relevant to its value.

3

Going to try and explain this one the best I can.

 

 



Label
Casablanca_Records

Mercury_Records

Advice Solution

Return all months between a given date range

bySteve
8

How do I write a query in SQL Server to return all months between two datetime fields?

 

Example:

Start

Troubleshooting Solution

Loop through records in a table to compare

4

Hi

 

I would like some help on how to write my query in SQL.  The examples I have given are based on a

Advice Solution

PostgreSQL

2

SELECT
   column_name,
   data_type
FROM
   information_schema.columns
WHERE
   table_name = 'trjtud_rec';

Troubleshooting Solution

can't restore MS SQL database from backup

12

MS SQL database restore

Troubleshooting Solution

Get total of hours between date fields and midnight.

bybfuchs
14

Hi Experts,

I am trying to get the count of hours between a given date/time field and 12 midnight.

The

Troubleshooting Solution

Recursive CTE and Cursors in SQL

3

Hello Experts, I need to write a cursor and a recursive CTE in SQL. I'm using Snowflake. 

 

Here's

Troubleshooting Solution

Find the value that is NEXT in the series of values as they occur.

4

Accession Question.docxThe accession Code below may or may not have a following code for a patient.

Advice Solution

Excel convert column to alpha

2

I have a spreadsheet that I need to import into a SQL table. One of the fields is DOCNUMBR.

 

In the

Troubleshooting Solution

Summarize SQL table

1

Hello Experts, I have the following table:

ID PLACE_OF_SRVC SRVC_CATGY CATEGORY PROC_CD SEQ
A241880451 Home
Research Solution

ISeries FOR EACH ROW ... UPDATE question

3

iSeries: When I add a FOR EACH ROW … UPDATE timestamp column to a table, does that column get

Troubleshooting Solution

Visual Studio 2022 - Database Schema Compare (Install Missing Packages) and ('System.Data.SqlClient' is not registered)

5

Trying to use VS2022 for database schema comparison.
Installed [Data storage and processing]
With all

Advice Solution

Combination: python and powerbi, python and sql

7

Dear experts,

 

Just to a give a brief background:

 

Current status:

I have sort of understood python

Advice Solution

SQL Server - Looping through table and matching Profile IDs together and updating or inserting records into table.

8

Hello, everyone.

SQL Server 2019

1 database

7 tables.

(In case it is needed, I am developing this under

Troubleshooting Solution

PowerShell - Azure SQL Properties

byREIT
2

Hi all,

 

I have a requirement where I need to pull all Azure SQL Servers and Databases, and return

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more