By tag: Sql Server 2005
0
kicks
Generate weekdays in sql server
In this post, I am sharing simple code to generate weekdays using Recursive CTE.
0
kicks
Retrieve only the first record from a LEFT JOIN
Recently I was working on a project where I had to return a simple list of products, and if they had images associated with them, return information about only one along with the product. Times like these, a simple left join or inner join just doesn’t cut it if there are more than one image/record p...