Has something to do with the null value. Change it an integer value you get the first values inserted into @s-2.

ColdCoffee (3/22/2012)

---

The problem is the CROSS JOIN. why do u want to do a cross...

I can't answer this myself. I can get the answer 2,4,7 if I flip the order of the inserts in the the table @s-2 such that 2,4,7 is inserted...

What is your expected output and what are you getting. I cut/past the code and it appears to work fine for me. Not sure if the results are...

Still haven't heard from the OP why he needs this.

From Books Online:

status

tinyint

The bitmask of the article options and status, which can be the bitwise logical OR result of one or more of these values:

1 = Article is...

Two things. One, increase the amount of disk space available to the databases. Two, if tempdb is on its own disk(s) you may want to look at using...

Since you are using DB Mirroring, you can't change from full recovery model to bull_logged model.

Only thing that comes to my mind is finding a way to spread out the...

Mirror, mirror on the wall, just what could be wrong?

Can't help you. We can't see from here what you see there. Please post the code, the whole code and nothing but the code.

What do you test your code on during development? You don't have a development or test database to work with?

But then again, he did just ask for a solution. Next I should probably be more explicit in a situation like this and be sure to provide info on...

Well, true. But he went further than just what was suggested. That to me indicates that he wasn't necessarily thinking clearly and definately did a Ready, Fire, Aim....

I made a minor change to the code, not sure how it will affect performance as I have nothing to test it against.

with t as

(

SELECT --COUNT(*)

...

danielfountain (3/22/2012)

---

Hey all,

I have a percentage stored as a decimal as per this:

87.41 is 87.41%

It is stored in a decimal (10,7).

Now the majority are whole numbers. Some have two...