You're welcome. (And thank you for the compliment.)

I guess I'd have to see the database to figure out what you've got. I'm not following you on this. I don't think I'll be able to help....

And for the other part of your question, if you want numbers that have more than 2 decimal places:

where number * 100 > floor(number * 100)

Use Floor in this case,...

Cast(number as int) will do what you need.

Examples:

cast(8.7 as int) = 8

cast(-8.7 as int) = -8

cast(pi() as int) = 3

Convert will do the same, but has reversed syntax:

convert(int, 8.7)

convert(int,...

I don't know what you mean by "after every iteration table changes".

I pronounce it the same as I would for a really bad movie that comes out after a really good one.

My boss keeps talking about one day brushing up on...

I've run SQL 2005 Express and Dev Edition on both Vista Home Premium and Vista Ultimate.

The main thing to watch out for is, when installing, uncheck the boxes at the...

Okay. If you're in a position to do so, you might just want to double-check that point with the people who are going to be using it.

If I understand correctly, you are currently using SQL Server Express for the database. If that's correct, an upgrade very well might improve your applications speed a bit.

SQL Express...

I got completely lost when I tried to read this.

Are you saying that you have two tables, that they have the same columns as each other, but that the data...

I just took another look at your code, and, regardless of the effect of zeroes on it, are you sure you want to divide two different directions in the same...

Move the tests for 0 first in the Case statement. That should get it.

I've had trouble using BCP with procs, if I remember correctly. May not work that way.

Books Online has an article on importing/exporting XML at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/dff99404-a002-48ee-910e-f37f013d946d.htm

Check that out and it...

It looks like your main index on your Subscriptions table should be:

create index IDX_Subscriptions_Main

on dbo.Subscriptions (UserName, ChannelUniqueID, SubscriptionEnd, SubscriptionApproved,

FeePaid)

That will cover what you need for that query. You...

I haven't tried it, but I believe openrowset can write to files as well as read from them. You might try that.