Find the second work day of the month

Just some fun with T-SQL.
Recently someone asked me to write a code which answers the question if today is the second business day of the month or not.
Here is a version of the code. If you have better ideas for doing this, feel free to post a comment.

 

?View Code TSQLdeclare @SecondDayOfMonth datetime
declare @Year int
declare

Continue reading […] Find the second work day of the month […]

 

SQL SERVER TRANSACTION ISOLATION LEVELS

SQL SERVER TRANSACTION ISOLATION LEVELS

by Mukiibi Ivan

On a busy day, our streets are given order by the traffic police, they keep the traffic flowing and they also keep motorists safe. Maximum safety can be ensured by only allowing one person to use a junction at a time.
Unfortunately, if there is heavy traffic the safer and

Continue reading […] SQL SERVER TRANSACTION ISOLATION LEVELS […]

 

SQL Server Interview Questions and answers - earning the honor of thinking - Book Review

Reading books is a very labor-intensive task (well, at least when taken seriously!).

It is not easy for several reasons:

We have to figure out the level of the book according to our knowledge level
We have to question the book’s title
We have to question the structure and the content

And why we have to question, you would ask.

Continue reading […] SQL Server Interview Questions and answers – earning the honor of thinking […]