Explore SQL Server on Experts Exchange

Expert Solutions for Your Tech Problems

SQL ServerMicrosoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Se...

Read more
  • 169K Content
  • 16K Contributors

Expert Spotlight
IT Supervisor

I am passionate software developer and also a competent Systems Admin.
Actively looking for 2nd part time remote-competitive-
 job in Greece

Troubleshooting Solution

Powershell help for creating accounts

Hello Experts,
I need help with the below :

#Requires -Module ActiveDirectory # Utility …

SQL Server Calendar Table

A demonstration of SQL Server T-SQL script that will build a calendar table, and demonstrate ways to easily query it to perform what would otherwise be complex date expressions.

I'm glad to see Liquidweb is a new topic here. They have …

I'm glad to see Liquidweb is a new topic here. They have been my web host of choice since about 2008…
Troubleshooting Solution

Know which batch is in stock on a selected date



I have a problem with this query that I just realized, with the test data everything seemed fine,


The Course of the Month for May: Comp TIA A+!  Prepare for …

The Course of the Month for May: Comp TIA A+!
Prepare for the 220-901 & 220-902 exams in the month…
Troubleshooting Solution

Contract a DB Professional

I have two databases that I "designed"...poorly to say the least.  They primarily display race …
Troubleshooting Solution

Adding different values from a table to find a specific sum value

There are times when I need to find a certain value out of a number of records. For example, assume …
Troubleshooting Solution

Change values


How do I add this condition in SQL
If BrnId='101' then print 'Branch 1'
If BrnId='104' then print

Troubleshooting Solution

Search specific field name


Is it possible to search a specific field name in multiple tables using query or from menu options

Troubleshooting Solution

Classic ASP insert Accented Characters from Czech do not insert with the ř


Hello All.

Working with Classic ASP, and trying to insert accented characters like this do not work.

Troubleshooting Solution

Sql query result for a year ago


what is the best way to pull a count of  a value on a given day and the same day a year ago in one

Troubleshooting Solution

T-SQL script to generate a calculation based on some numbers


Hello Experts,

I have a table with column containing these values. I need to create a SQL Script for

Research Solution

Windows cluster setup + SQL server 2019 AG of 2 x nodes.



any easy to follow procedure on how to setup :

1) Windows cluster.

2) SQL server 2019 AG of 2 x

Advice Solution

TSQL:  String Rotate 13


Hi All,

I need to obstrificate some text between SQL Server (TSQL) and PHP.  Both sides need to be

Troubleshooting Solution

I need to JOIN two tables based on not-quite-matching (seconds/milliseconds) time stamps


I'm working with an industrial system that is collecting data from a wide variety of sources and, in


Is it just me or is NoSQL Overapplied? It seems like in an …

Is it just me or is NoSQL Overapplied? It seems like in an effort to be as trendy as possible people…
Troubleshooting Solution

Issue with T-SQL COUNT(*) counts NULLS but I don't want to count NULLS in row count


Hi Experts,

I have a scenario where I'm trying not to count a row where it has a zero, blank or NULL.

Troubleshooting Solution

TSQL Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.


Hi I am getting the below error while I use the sub query but no error when I comment out the

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more