<div>
update tbl_2 
set downtimecode = t1.downtimecode 
from tbl_2 t2 
inner join tbl_1 t1 on t1.startdate = t2.startdate 
where t2.downtimecode is not null
</div>

<div>
Just make sure you have indexes on the two tables for t1.startdate = t2.startdate columns and if you have large number of rows to UPDATE then do it in batches - you can use SET ROWCOUNT for that
</div>

<div>
I added it to a stored procedure and executed it. &nbsp;Runs fine bur does not update table 2?
</div>

<div>
based on the records you showed, there's no update needed. &nbsp;tbl2 already has the downtime codes that are in tbl1
</div>

<div>
no, i want to input the downtime codes from tbl1, they won't already be there
</div>

<div>
can you post some sample records from each table to show what should be getting updated?
</div>

<div>
Attached is a small extract
</div>

<div>
oops, sorry 
<a href="https://filedb.experts-exchange.com/incoming/2014/02_w09/837512/extract.xls" target="_blank" class="file-inline" title="Extract (16 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>extract.xls</a>
</div>

extract.xls

<div>
I don't see any reason this shouldn't work to update tbl2. &nbsp;Looks like the tbl2 record with startdate 2014/01/26 14:50 should get its downtimecode set to null 
 
update tbl_2 
set t2.downtimecode = t1.downtimecode 
from tbl_2 t2 
inner join tbl_1 t1 on t1.startdate = t2.startdate 
where t2.downtimecode is not null
</div>

<div>
I think i seem to have caused some confusion 
 
table 2 should be updating table 1 where startdate in table 2 is not null and startdate in table 1 is null
</div>

<div>
that makes a little difference, lol... 
 
update tbl_1 
set t1.downtimecode = t2.downtimecode 
from tbl_1 t1 
inner join tbl_2 t2 on t2.startdate = t1.startdate and t2.downtimecode is not null 
where t1.downtimecode is null
</div>

<div>
I get an error on the SET line 
 
The multi-part identifier &quot;t1.DowntimeCode&quot; could not be bound.
</div>

<div>
update tbl_1 
set downtimecode = t2.downtimecode 
from tbl_1 t1 
inner join tbl_2 t2 on t2.startdate = t1.startdate and t2.downtimecode is not null 
where t1.downtimecode is null
</div>

<div>
runs successfully but still does not update table 1
</div>

<div>
update MachineData 
set downtimecode = Temptbl_Stops.downtimecode 
from MachineData 
inner join Temptbl_Stops on Temptbl_Stops.startdate = MachineData .startdate and Temptbl_Stops.downtimecode is not null 
where MachineData .downtimecode is null
</div>

<div>
Same result, runs successfully but updates nothing
</div>

<div>
Is there anything else i can try?
</div>

<div>
This works in a select command to get the same results but i need an update command. 
 
SELECT &nbsp; &nbsp; dbo.tbl_MachineData.ID, dbo.tbl_MachineData.Date, dbo.tbl_MachineData.ShiftType, dbo.tbl_MachineData.ShiftID, dbo.tbl_MachineData.Machine, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbo.tbl_MachineData.ProductCode, dbo.tbl_MachineData.Batch, dbo.tbl_MachineData.CavitationStd, dbo.tbl_MachineData.CavitationAct, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbo.tbl_MachineData.CycleTimeStd, dbo.tbl_MachineData.CycleCount, dbo.tbl_MachineData.ScrapCount, dbo.tbl_MachineData.CycleTimeAct, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbo.tbl_MachineData.StopCount, dbo.tbl_MachineData.RunStatus, dbo.tbl_MachineData.StartDate, dbo.tbl_MachineData.StopDate, 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CASE WHEN dbo.tbl_MachineData.DowntimeCode IS NOT NULL 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; THEN dbo.tbl_MachineData.DowntimeCode ELSE dbo.temptbl_Stops.DowntimeCode END AS DowntimeCode 
FROM &nbsp; &nbsp; &nbsp; &nbsp; dbo.tbl_MachineData LEFT OUTER JOIN 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbo.temptbl_Stops ON dbo.tbl_MachineData.StartDate = dbo.temptbl_Stops.StartDate 
 
You have to excuse me as i am a novice but thanks for the help so far
</div>

<div>
Tried this, no error but still no update when running stored procedure 
 
UPDATE dbo.tbl_MachineData 
SET DowntimeCode = (SELECT CASE WHEN dbo.tbl_MachineData.DowntimeCode IS NOT NULL THEN dbo.tbl_MachineData.DowntimeCode ELSE dbo.temptbl_Stops.DowntimeCode END AS DowntimeCode 
FROM dbo.tbl_MachineData 
LEFT OUTER JOIN dbo.temptbl_Stops ON dbo.tbl_MachineData.StartDate = dbo.temptbl_Stops.StartDate) 
END
</div>

<div>
I really don't understand why this code doesn't work, i have atached both full tables 
 
UPDATE tbl_MachineData 
SET DowntimeCode = temptbl_Stops.DowntimeCode 
FROM tbl_MachineData 
INNER JOIN temptbl_Stops 
ON tbl_MachineData.StartDate = temptbl_Stops.StartDate 
<a href="https://filedb.experts-exchange.com/incoming/2014/02_w09/837572/extract.xls" target="_blank" class="file-inline" title="Both tables (38 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>extract.xls</a>
</div>

<div>
I will try it but i don't import from excel, i just pasted into excel so the experts could see what my tables look like
</div>

<div>
Again it executes without errors but updates nothing - i am totally stumped 
 
If i create a select as above it works fine, is there no way to get that select into an update?
</div>

<div>
Hi, 
 
Of course I don't expect you to do the import from excel - I was explaining why the table names where different in my code to your code. I expect you'll have to edit the table names - removing the $ - and then it will work for you. 
 
Regards 
&nbsp; David
</div>

<div>
Hi, 
 
Does the select show this: 

<pre><code class="code-10 nolinks" id="code-20-39896919-1">DowntimeCode	DowntimeCode
NULL	3
NULL	3
NULL	3
NULL	3
NULL	3
NULL	3
NULL	3
NULL	3
NULL	1
NULL	1
NULL	1
NULL	2
NULL	2
</code></pre>
 
or this: 

<pre><code class="code-10 nolinks" id="code-20-39896919-2">DowntimeCode	DowntimeCode
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
1	1
1	1
1	1
2	2
2	2
</code></pre>
 
How do you know that it updates nothing? It works for me with the data you provided. 
 
Regards 
&nbsp; David
</div>

<div>
Hi David, 
 
Because my downtime column in table_MachineData is still all NULLs 
 
I have never ran the select, you have to understand i am a novice so you may have to explain exactly how to run it, do i just uncomment it? &nbsp;where will the results show? 
 
Thanks for the patience
</div>

<div>
I am not sure if this was right but i.... 
 
Commented out the update and set lines 
Uncommented the select line 
Ran the select 
Did the opposite 
Ran the update 
Did the opposite 
Ran the select 
 
Same result, all run but table never changes 
 
I have to go out now for a while but thanks for your help so far, maybe you will be back on line sometime later.
</div>

<div>
Anyone got any idea what i may be doing wrong?
</div>

<div>
Hi David, 
 
The result of the SELECT is similar to the first table 
 
DowntimeCode &nbsp; &nbsp; Exp1 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; 
NULL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2
</div>

<div>
Hi, 
 
 
 
This is the query I posted. 
By highlighting or selecting everything from the select, this is what will run when clicking on the execute button. 
 
Otherwise with nothing selected the entire query will run and the select line will be commented out. 
 
HTH 
&nbsp; David
</div>

<div>
This is really bizzare..... 
 
If i run this code in a view, it works perfectly 
 
UPDATE d 
SET DowntimeCode = s.DowntimeCode 
FROM dbo.tbl_MachineData d 
INNER JOIN dbo.temptbl_Stops s 
ON d.StartDate = s.StartDate 
 
If i run the same code in a stored procedure, it does not update tbl_MachineData, stored procedure is attached 
 
USE [OEE] 
GO 
/****** Object: &nbsp;StoredProcedure [dbo].[stp_UpdateTemptbl_Stops] &nbsp; &nbsp;Script Date: 03/01/2014 18:38:11 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
 
ALTER PROCEDURE [dbo].[stp_UpdateTemptbl_Stops] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-- Add the parameters for the stored procedure here 
AS 
BEGIN 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-- SET NOCOUNT ON added to prevent extra result sets from 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-- interfering with SELECT statements. 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET NOCOUNT ON; 
 
UPDATE d 
SET DowntimeCode = s.DowntimeCode 
FROM dbo.tbl_MachineData d 
INNER JOIN dbo.temptbl_Stops s 
ON d.StartDate = s.StartDate 
 
END 
 
I really just need a little guidance as to why this is the case and what is the basic thing i am doing wrong?
</div>

<div>
I undertstand, the question i had was where do i see the results of the select on the screen, when in a view its at the bottom but where does it print to when running a stored procedure?
</div>

<div>
Hi, 
 
&gt;&gt;&nbsp;When I run this in a view ... 
To clarify, a view in sql is an object like a procedure is an object - it is a script that is stored in the database in effect. 
 
Now a view can have one select statement - there can be sub-selects and correlated subqueries, but overall it is one statement. 
 
Now when you execute the query and see the results in the bottom of the screen, that is the default. I like to use different tabs myself. 
 
The code you ran as a procedure is the code to create or alter the procedure. You then need to execute that like this 
 
execute [dbo].[stp_UpdateTemptbl_Stops] 
 
HTH 
&nbsp; David
</div>

<div>
Where do i put that? 
 
Normally i execute stored proedures from vb express 
 
In this case i have been simply pressing the execute ! at the top of the screen, does this not really execute the procedue?
</div>

<div>
Hi, 
 
The code that you execute 
 
create procedure dbo.SomeProcedure ... 
 
merely creates an object within the database. 
 
In SSMS you can navigate to it under the database in question - Programmability | Stored Procedures. 
 
So what you are executing is the script to create the procedure. 
 
The line I wrote above should be in another query and you need to execute that script (by clicking on the above button) 
 
So we have two different T-SQL queries - one to create or alter the procedure, and the other to execute it. (Of course you can use my technique as per the above and simply comment out one and highlight the other in the same script, but lets not get too confusing.) 
 
No idea how you are executing the procedure from VB - and at this stage, since you are still developing the procedure, executing from SSMS (instead of VB) is likely the better option. 
 
HTH 
&nbsp; David
</div>

<div>
Hi David, 
 
You have been incredibly patient and for sure deserve the points but can you list the complete copde in your execute query because mine still does not give the correct result (or any result for that matter). 
 
I have only been using SQL for a couple of weeks so i am seriously struggling with some basics. 
 
I have tried to execute the stored procedure via vb which i do with other stored procedures and it again does not error but does not update.
</div>

<div>
Ah its ok, i used execute to and then the ! symbol and that worked fine.... 
 
Sorry for being a pest.
</div>

<div>
Very patient person, thanyou very much for the help
</div>

<div>
Hi, 
 
No worries. 
 
If you're coming from a programming background and procedural environments, it takes some getting your head around the function environment that is a rdbms and SQL. 
 
That is, in vb you describe step-by-step what to do. In SQL you say what you want the results to be and SQL figures out how to do it. 
 
And then there is the set vs row thing as well. 
 
So what I did. 
I have on my workstation a database called Experts Exchange which is what I use for answering questions here. 
 
In SSMS I right-clicked on ExpertsExchange and selected tasks and import data. Stepping through that wizard got your data into the database. I wondered when the wizard said that it imported a number of rows from MachineData, so I took a look and deleted the null rows. 
 
Although out of sequence, I'm going to rename the tables 
 
I then edited your update script. 
 
I then created a reset update and commented it out. 
 
Here is my complete code. 

<pre><code class="code-10 nolinks" id="code-20-39897724-1">--
use ExpertsExchange
go

select *
from [dbo].[tbl_MachineData]
;

/*
delete [dbo].[tbl_MachineData]
where
	ID is null

*/

UPDATE d
SET DowntimeCode = s.DowntimeCode
-- select d.DowntimeCode, s.DowntimeCode
FROM dbo.tbl_MachineData d
INNER JOIN dbo.temptbl_Stops s
	ON d.StartDate = s.StartDate 
;

/*
-- reset
UPDATE d
SET DowntimeCode = null
-- select d.DowntimeCode, s.DowntimeCode
FROM dbo.tbl_MachineData d
INNER JOIN dbo.temptbl_Stops s
	ON d.StartDate = s.StartDate 
;

*/
</code></pre>
 
In executing this code, I often select just the pieces of the script that I want to execute as per a previous screen-shot. 
 
Now if you need that packaged as a stored procedure 

<pre><code class="code-10 nolinks" id="code-20-39897724-2">use ExpertsExchange
go

-- =============================================
-- Create stp_UpdateTemptbl_Stops
-- =============================================
-- Creating the store procedure
if exists (select name 
	 from sysobjects 
	 where name = N'stp_UpdateTemptbl_Stops'
	 and 	 type = 'p')
 drop procedure dbo.stp_UpdateTemptbl_Stops 
go

create procedure dbo.stp_UpdateTemptbl_Stops
-- =============================================
-- stp_UpdateTemptbl_Stops
-- =============================================
--

-- Author	David Todd
-- etc
--

			
-- =============================================
as
	set nocount on
 ;

	UPDATE d
	SET DowntimeCode = s.DowntimeCode
	-- select d.DowntimeCode, s.DowntimeCode
	FROM dbo.tbl_MachineData d
	INNER JOIN dbo.temptbl_Stops s
		ON d.StartDate = s.StartDate 
	;

go

-- =============================================
-- Grant execute rights to Public for the store procedure
-- =============================================
grant execute on dbo.stp_UpdateTemptbl_Stops to Public 
go

-- =============================================
-- example to execute the store procedure
-- =============================================
execute dbo.stp_UpdateTemptbl_Stops
go
</code></pre>
 
Running this select before 

<pre><code class="code-10 nolinks" id="code-20-39897724-3">select d.DowntimeCode as Data_DowntimeCode, s.DowntimeCode as Stops_DowntimeCode
FROM dbo.tbl_MachineData d
INNER JOIN dbo.temptbl_Stops s
	ON d.StartDate = s.StartDate 
;

-- results
Data_DowntimeCode	Stops_DowntimeCode
NULL	3
NULL	3
NULL	3
NULL	3
NULL	3
NULL	3
NULL	3
NULL	3
NULL	1
NULL	1
NULL	1
NULL	2
NULL	2
</code></pre>
 
executing the create procedure/execute procedure script from above gives this result 

<pre><code class="code-1 nolinks" id="code-20-39897724-4">Command(s) completed successfully.
</code></pre>
 
and then re-running the above select 

<pre><code class="code-10 nolinks" id="code-20-39897724-5">Data_DowntimeCode	Stops_DowntimeCode
3	3
3	3
3	3
3	3
3	3
3	3
3	3
3	3
1	1
1	1
1	1
2	2
2	2
</code></pre>
 
Note in the create procedure script that it checks and deletes the existing version of the procedure. The script uses go as the batch terminator. That is, the script isn't submitted in one chunk, but in multiple batches to SQL. 
 
Note that in the selects I've aliased the columns, so when looking at the results it is more obvious which column is which. 
 
HTH 
&nbsp; David
</div>

<div>
<div class="content wysiwyg-content">
In SQL server 2008 express. 
 
I need to lookup each instance of startdate from tbl1 in tbl2 and insert the downtime code from tabl1 into tbl2 only where the downtime in tbl2 is not null. 
 
tbl_1 
 
ID &nbsp; &nbsp; StartDate &nbsp; &nbsp; &nbsp;StopDate &nbsp; &nbsp; &nbsp; StopTime &nbsp; &nbsp;DowntimeCode 
 
1 &nbsp; &nbsp; &nbsp; 2014-01-01 &nbsp; 2014-01-02 &nbsp; &nbsp; &nbsp; &nbsp; 24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 
2 &nbsp; &nbsp; &nbsp; 2014-01-02 &nbsp; 2014-01-03 &nbsp; &nbsp; &nbsp; &nbsp; 31 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6 
3 
 
 
tbl_2 
 
ID &nbsp; &nbsp; StartDate &nbsp; &nbsp; &nbsp;StopDate &nbsp; &nbsp; &nbsp; StopTime &nbsp; &nbsp;DowntimeCode 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2014-01-01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2014-01-01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2014-01-02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6 
 
Thankyou very much for your assistance.
</div>
</div>

In SQL server 2008 express.

I need to lookup each instance of startdate from tbl1 in tbl2 and insert the downtime code from tabl1 into tbl2 only where the downtime in tbl2 is not null.

tbl_1

ID     StartDate      StopDate       StopTime    DowntimeCode

1       2014-01-01   2014-01-02         24                     3
2       2014-01-02   2014-01-03         31                     6
3


tbl_2

ID     StartDate      StopDate       StopTime    DowntimeCode
         2014-01-01                                                          3
         2014-01-01                                                          3
         2014-01-02                                                          6

Thankyou very much for your assistance.

Upadte SQL table based on records in another table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.