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

byAckles
284
Hello Experts,
I need help with the below :

#Requires -Module ActiveDirectory # Utility …
Article

SQL Server Calendar Table

28
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.
Video
Tutorials
Post

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

byrp
31

Hi,

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

Post

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

11
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

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

Change values

17

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

25

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 ř

21

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

bynatata
21

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

48

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.

47

hi,


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

21

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

32

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

Post

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

1
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

33

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.

22

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

Collaborate

Monitor your Site

Explore solutions and more