I'm confused, how is it you are expecting the name to be equal to something and nothing at the same time? You're comparing the same field to 2 completely...

To further clarify / agree with Bit, I'm reminded by my more math inclined buddies that even at 95% coverage, on average you're still only going to be doing 20...

Always happy to be disagreed with! :hehe:

I...

This is a known deficiency unfortunately. DBCC INPUTBUFFER is still around for this reason. I whipped up some test code to demonstrate some of this... and was rather...

OP, correct me if I'm wrong here, but let me attempt to explain this better. He's not just trying to round up every time. Here's a couple examples:

7.0449

This...

And even though these random string generators may be very good for what they do, none of them get you out of having to do a loop to create a...

Aside from the question of 'what makes that correct rounding', considering you are essentially rounding 44.9 up to 50(upwardly skewing your data), there are a few methods you could use...

Sharul Nizam (11/21/2009)

1. Me just want to see,...

Before we give you crazy solutions to accomplish this, could you share the reason for it and what you hope to accomplish?

I'm sorry, but how is that the same code? You've introduced half a dozen new variables, any one of which could be causing the problems. I'd debug the...

ISNULL(YourTable.DateField,GETDATE() ) DateField, ISNULL(CountField, 0) CountField

Note that that code displays the exact date with the time portion, you could also trim off the time portion to show just the date....

Edit: Silly late night forum lag.

Alas, it does not :/....

Oops, mine didn't handle NULLS or the fact that COL7 is actually a varchar. One sec...

Modified:

;WITH SEL AS(

SELECT T2.COLA COL1,...

The problem is the way SQL handles these. That will be an all at once operation, meaning that every line you insert will use the same MAX value +...