SQL Server Education (by the geeks, for the geeks)
Hi Friends, Yesterday I was answering some questions on TechNet Forum when I saw an interesting and genuine problem. The user wanted to calculate the number of leaves taken by an …
SQL Server T-SQL | Calculate Number of Leaves – excluding weekends Read MoreHello Folks, You have been well known about the iFTS previously. Well, if somehow you don’t, then you should not be worry about this anymore!! History…a little bit 🙂 SQL Server …
SQL Server 2008 Integrated Full Text Search – Part 1 Read MoreHi Friends, In a multi-valued, self-conatined subquery, the inner query (also called as the inner select) returns multiple values. The outer query consumes and validates the list of values returned by …
SQL Server: Multi-valued subquery with nesting Read More