|
|
-
nocat50 Commented 4 Months ago through Blogs
*N.B.* This example works for the **datetime** data type. It does not work for the **date** data type.
And I wholly disagree that knowing this **is *not* useful**.
Novice developers often make the mistaken assumption that an allowed calculation is...
|
-
nocat50 Liked 4 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
<p>The challenge is to find the employees with the second highest salary in each department. However, it is a little more complicated because if two employees have the same salary, you need to list both of them.</p>...
|
-
nocat50 Submitted 4 Months ago through TSQL Beginners Challenges
This solution starts with a table variable, which a CTE then uses
The final query selects from the CTE....
|
-
This solution produces factors and their factorials via a recursive CTE....
|
-
Solution to TSQL Beginners Challenge 15...
|
-
This challenge is to reverse the order of words within a sentence. ...
|
-
Solution to TSQL Beginners Challenge 5...
|
-
<p>This challenge has been taken from a forum. The challenge is all about searching the closest number in a collection of numbers. Let’s have a look into the sample data.</p>...
|
-
Solution to TSQL Beginners Challenge 3...
|