Two questions I need answered first.  One, what is the format of the date in Created?  Two, what software are you going to use to zip the output file?

We are...

Try this against your sample data:

select

    item,

    vendor,

    sum(case when year(entered_date) = 2005 then sales else 0 end) as TotalSales2005,

    sum(case when year(entered_date) = 2006 then sales else 0 end)...

Unfortunately, I can't see your sample data.  If you can post it as a series of insert statements that could be cut and pasted like your table DDL, that would...

We could use additional info in order to help you.  The DDL for the table(s) and some sample data will go a long way to generate some suggestions to help...

First, the query without the dbo.MyTab works as expected in SQL Server 2005.  I also ran it under SQL Server 2000 and got the unexpected result you reported.  I then...

Sergiy,

You also seem to have trouble recognizing the humor in Jeff's and David's posts.

Sergiy,

Unnecessary and wrong are two different things.  It may not be necessary to explicitly drop temp tables at the end of a stored procedure, but that does not mean it...

Sergiy,

I have already admitted to being a Type A personality when it comes to my job.  I am very confident in my skills as a programmer and DBA.  I will...

Sergiy,

Let see, here is what I said:

You have never proved your point, nor will you ever prove your point.  You have consistantly gone off on tangents (really, what the heck...

Sergiy,

You have never proved your point, nor will you ever prove your point.  You have consistantly gone off on tangents (really, what the heck does the Catholic Church 400 or...

Sergiy,

You keep saying that the use of the Bankers Round function is illegal in NZ, that's fine.  That doesn't mean it is illegal every where else.  Just curious on the...

Sergiy,

Actually, in this case, I would round the weight (1.125 kg) to 1.13 kg.  I would use the the Banker Round function in the calculation (rate * weight) to determine...

Actually Sergiy, 0.1250 is precisely the value you get from the ratio 1/8.  Divide it out on paper after the 0.125, all you will ever get is zeros.

The variable @AOwner is no longer exists after the UPDATE statement, as you terminate the batch with a GO statement.  If you can determine the client by querying the database,...

That I can't really answer.  I know enough about hardware to support my computers at home and get in trouble at work, but if the disk is mirrored, I would...