glad you figured it out, but it would be beneficial to others that read this post to know what the issue was, as there be others with a similar issue.

I am assuming that there was significant work done prior to the full backup.  A full backup does not truncate the transaction log, that is only done by the transaction...

I think I figured it out.  If you alias a COLUMN in your select statement, you can't prefix that ALIAS with a table alias.  Not a problem for me as...

I haven't used SQLUA, but I am wondering why it would issue a warnig FOR prefixing your columns in an order by clause?  By prefixing column names with a table...

True.

Never say never.  If the view only returns, say the TOP 10 PERCENT, the ORDER BY is used to determine which top 10 percent is returned.  Again, test, test, and...

Michael, I knew there had to be another way to get the upper bound for the where clause.

Try this:

where

datefield >= dateadd(mm, datediff(mm,0,

I'm just a little confused, what is the criteria for select records again?  My guess is you are looking for all records in the current month based on the value...

It depends.  If the select in the view is written SELECT TOP 100 PERCENT ..., then yes.  If it actually returns a small subset from the target table(s), then I...

Based on the OP, the question being asked is which car has both diesel and Petrol types.  The Skoda has only diesel, so fails the criteria where as the ford...

I played with it a little more, if you change the = to >= you will get the results you are expecting.

I just spent a little time playing with your query, and it is actually working the way it is supposed to work.  If you read BOL you will find that...

I'll second Jeff on this, and I'd even take it further.  It may be a good idea to alias columns even in single table queries.  You never know when a...

Guess I'll have to look at this more.  I have had queries fail for this very reason, so I wonder if there is something else I may be missing.