Microsoft SQL Server
Articles & Videos
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.
SELECT DISTINCT Building,
WHEN '0' THEN COURSE
I have TableData.txt with the following data:
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 …
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 …
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.
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:
min(COURSE1) as id,
0211 A0900474 ALG 1A * Remove the first occurence
0211 A0900474 ALG 1B
id StudentId CourseName
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…
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
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 …
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 …
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 …
How can I modify this sql statement to replace \ by - on select statement :
set nocount on; SELECT DISTINCT REPLACE(REPLACE(REPLACE(na
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…
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…
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.
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):
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 …
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 …
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
AbiCode minYM maxYM Tprev Tchange
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:
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…
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
I'd like to know the most efficient way of doing the following.
I've a table with following columns:
EngagementKey uniqueidentifier (PK)
I want to result like:
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 …
Perplexed by SQL Server date styles (http://msdn.microsoft.com
The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who's ever used a computer for a sig…
Zürich, Kanton Zürich, Switzerland
40,805 points this week
15,532 points this week
9,011 points this week
Railway Road Gurgaon, Haryana
6,500 points this week
6,500 points this week