Tags: SQL

With-clause referenced two different from-clause elements

Benjamin Perkins C#

I believe if you are getting this error that there is more likely something wrong with your configuration than with NHibernate. I received this error when I wanted to create a nested join between 2 unrelated tables. Something like this in HQL: [sourcecode language=”sql” padlinenumbers=”true” autolinks=”false” gutter=”false” toolbar=”false”] select tbl.CODE, av1.NUM, al1.CODE from TABLE tbl […]

Read More →

How to sort by month in SQL Server

Benjamin Perkins C#

This is a older blog which I am migrating, you can see how the older website looked like here. You can see on the Blog.Archive() navigation bar on the right of this page that I present the Year, Month and number of blogs which I have written each month. Everything worked fine from October 2010 […]

Read More →