Thank this author by sharing:
By Theo Ekelmans,
It's a common problem we all share from time to time, and i thought my solution is worth a post :)
You have 2 datasets and you wonder..... has anything changed, and if so, did it change in A or B?
In my example i show a way to compare 2 sets of employee data and output the changes in one TSQL statement
As you can see, the output shows additions, removals and changes.
Sr MS-SQL DBA @ Ordina.nl
How to void displaying ''1900-01-01 00:00:00.000" if datetime data is null?
where is that display...
want only 1980-12-17 instead of 1980-12-17 00:00:00.000
i work with sql server 2005 and i 'm a beginner
I have a table with a column datetime.
Does anyone recognise the data type for the following string? 2004-05-13 00:00:00.000
Here is the part of the query that it taking too long (temp tables involved run in few seconds whic...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.