Microsoft SQL Server

157K

Solutions

183

Articles & Videos

43K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Refine results

SELECT DISTINCT Building,
          BuildingName,
          StudentId,
          --SECTION_KEY,
            PEIMS_Sequence,
            StudentName,
            CASE PEIMS_Sequence
            WHEN '0' THEN COURSE
            ELSE …

617 views
Microsoft Certification Exam 74-409
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

I have TableData.txt with the following data:
(CODE)

I need help to create a Proc which will read the data from C:\MyFolder\TableData.txt to create a table with the data shown. The name of table …

620 views

Assuming I have a table containing the following information:

FK | Field1 | Field2
=====================
1  | ABC    | *NULL*
2  | *NULL* | DEF
is there a way I can perform a select on the …

414 views

Hi

We are going to implement new Cashless catering system. The Company who is going to implement has asked me to build a server with the following server specification the given spec as follows.

519 views

Hello,

There is a UPPER and LOWER commands to run in SQL Studio Manager to convert text.

Is there one for PROPER CASE? (Or Title Case)

EG for UPPER:
UPDATE
  CUSTOMERS
SET
  CustomerTitle…

210 views

select
 min(COURSE1) as id,
  StudentId,
 CourseName
from #tmpRCX

Example:
0211      A0900474        ALG 1A  * Remove the first occurence
0211      A0900474        ALG 1B

id      StudentId      CourseName
8013      …

526 views

I am using SQL Server 2016 and have just started using temporal tables for auditing purpose. However, I am not getting a way to insert the operation type in the history table along with the version of…

49 views

I have a VPN to a customer.

I can "trick" my SSMS into opening through a command prompt in Windows Authentication mode through that VPN
CMD>C:\Windows\System32\runas.exe /netonly …

826 views

Hi,

In order to remove snowflake dimensions from a star data warehouse schema, I would like to flatten the hierarchies so that I can then load the data into a dimension.

The tables that are …

331 views

I need a SQL that will list products in family have different descriptions.  Every product within the same product family should always have the same description 01 and description 02 values.  I need …

513 views
Comprehensive Backup Solutions for Microsoft
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

I dont know why but I have a column and whatever i call it it says its an invalid name and not sure why. Ive created it called 'CalcPer' and its in the table column list but when i do a select its …

513 views

Hello,

How can I modify this sql statement to replace \ by - on select statement :
set nocount on; SELECT DISTINCT REPLACE(REPLACE(REPLACE(name,'[',''),']',''),' ', '') FROM msdb..sysjobs

421 views

Ive amended some code from an expert but I get a divide by zero error that makes sense but not sure how to stop that previously it was using int and just subtracting to get a variance ive changed to a…

2316 views

Hello,

The following script returns the error :

Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '+'.
Msg 319, Level 15, State 1, Line 11
Incorrect syntax near the keyword 'with'. If…

214 views

I am trying to update the value of table a.EID of that of table b.id, below is the query with the join, but I seem to have a syntax error, any help is appreciated.

(CODE)

214 views

I need help with a Stored Proc in Sql Server 2012.

I get an error with the following code.  Please tell me what I am doing wrong (see code below):

(CODE)

411 views

How could I go back a fiscal year for a given date?

My organization use the format of the Fiscal year as follows:

'FY2015', 'FY2016', 'FY2017'

I need to get these values automatically  using …

431 views

I need to calculate average of the survey given for one client by others. The other have different roles (boss, direct report, self , etc) ,So the average need to be by role.Also I need the count for …

2140 views

I had this query in access which gave output specifically only where an item went from no value to a value or either value changed
(CODE)

AbiCode               minYM          maxYM      Tprev      Tchange
81140561      …

321 views
Optimizing Cloud Backup for Low Bandwidth
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

hi,

I keep hearing about SQL server vNext, I am not sure if it is talking about SQL 2016 or SQL 2018, please suggest.

I read that:

1829 views

I need to find all rows created in the last 6 months using a TEXT column containing the create date.  This column is a text column not a date column.  Use this text column how can I find the rows that…

438 views

I have a stored procedure that works and pulls in Leads information.

I would like to pass in a CustomerID Paramater    (INT)

If null ... ignore

If it is an integer > 0

Add
WHERE …

762 views

I'd like to know the most efficient way of doing the following.

I've a table with following columns:

EngagementKey uniqueidentifier (PK)
EngagementDate DateTime
ContactKey uniqueidentifier

923 views

(CODE)

I want to result like:

(CODE)

I am able to get the Present/Absent status of a user for a single  date. But my question here is that I want to get all the users that are present/absent …

1121 views

I am trying not to show records where the data change went from a value to 0 but whatever i try fails as the variance is a whole number and not sure how to get around that.

(CODE)

0      72.4      201701      …

69 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Microsoft SQL Server 2005
    (71,565)
  2. Microsoft SQL Server 2008
    (49,077)
  3. Query Syntax
    (47,623)
  4. Databases
    (53,715)
  5. .NET Programming
    (131,953)
  6. Microsoft Access
    (216,192)
  7. Microsoft Development
    (47,952)
  8. ASP.NET
    (123,364)
  9. SSRS
    (8,800)
  10. Visual Basic.NET
    (92,137)