This tutorial will help you to get started with SQL Server Reporting Services (SSRS)...

Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....

How can scalar functions cause performance problems when used in the select list, join expression, or where clause?...

<p>Hi,</p> <p>You will need some form of recursive element to get the groups, so I suggest a recursive CTE.  From there you can use SQL Server xml functionality.</p> <p>I dont remember the code to post TSQL So please forgive me :). Here is one possi...

<<What will define an "exact match"? (already asked in the forum but with no reply yet...): An exact match can be defined as a case insensitive match, but all characters must be represented... no more... no less. <<What will be the allowed leading an

@GoBlando, Think of this problem in most simplistic terms. The solution should replace the keyword, with a HTML hyperlink. There really should be no outstainding issues here. If an exact keyword exists in the text, replace the keyword; otherwise do n

@EOstrander, Think of the table variable as a real table that already contains all the necessary data. The solution file should include the sample table and data scripts.

This is a very interesting challenge which we saw in one of the online forums. The task involves generating HTML tags (hyper links) around certain keywords in the value of a column.

Submit A Solution This challenge is derived from a reali...