XQuery
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
218 reads
In 2005 version of SQL Server, XQuerying was introduced. It’s a powerful feature and when used together with a CTE,...
2013-03-27
218 reads
I was working on a remote machine and while I was away, the machine was restarted. Lost the scripts I...
2013-03-20
104 reads
When you start working on a new project, one of the important tasks as a database developer is to get...
2011-04-04
98 reads
This one is an oldie in my blog drafts, but a goodie! So, I...
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with...
Let’s have devs look at their own query performance. Yes, please, sign me up...
I'm working on the same bakery problem... <g> Product--(1,M)--ProductIngredient--(M,1)---Ingredient Both Product and Ingredient are...
The SSRS report has a CountDistinct in the detail row grouping by Facility. It...
Hi All, Wonder if someone can clear something up for me and let me...