When sending HTML tables via DBMail I used the following:

EXEC msdb.dbo.sp_send_dbmail
    @profile_name = XYZProfileName',
    @recipients = 'Test@test.com',
    @subject = 'Your Subject Here',
   

You are not missing anything.  It is reported on MS Connect as an issue.  Please use this link to vote for this to be fixed.

Here is what you need, I think.  Union All works but in order to get the results you want you need to add some NULL columns.  It's a weird work...

You maybe able to use a count function and count the Number of ProductID's and filter out > 1.

c'mon man!  Group By is 5th in the list and Having is 7th.  7, by my reckoning, still comes after 5.  Having is the correct answer.  :blink:

I also used IDrive.  I took advantage of a cheapskate offer from CNET and got the physical drive for free.  It's been perfect for me and the wife with just...

acmedeepak, 

In order to help you we need more information along with some sample data and expected output. 
We also don't know how you have translated the query...

Shawn,  I've encountered similar situations when dealing with data that had "lived in" another system at some point (DB2 in my case) and hidden characters were imported into varchar fields. ...

My original thought was that since there was no PK there where no indexes either.  Sorry that won't work.
My only other thought is to do the opposite of what you...

I think that you need a Numbers or Tally Table here.  You can use it to define your dates, week and between dates for you where clause.  Jeff Moden has...

I think I would do this in VBA inside the XLS file.  Basically it's for each tab save as using the existing tab name.

Tacy,

Assuming you are not in a position to add a PK I would suggest adding an Index on your Date Field and depending how "wide" you data is...

I would at it after the Commit and Rollback statements, respectively.