He's doing a statistical analysis based on a normal distribution. he's looking for the point in a normal distibution with an average and standard deviation commensurate with his set...

Tom.Thomson (9/7/2011)

---

Matt Miller (#4) (9/6/2011)

---

Tom.Thomson (9/6/2011)

---

Look, we are taking about extremely well known and standardised notation here. Any string that means "the number which is the limit of the...

Tom.Thomson (9/6/2011)

---

Look, we are taking about extremely well known and standardised notation here. Any string that means "the number which is the limit of the series whose nth term...

Evil Kraig F (6/2/2011)

---

mister.magoo (6/2/2011)

---

For anyone who thinks that an infinitely recurring number can simply be redefined as another number, I ask this question:

Does PI (3.14159 etc ) which never...

jbalbo (9/2/2011)

---

not sure if Im answering the ? right,

and I stink at this for a lack of better words..

but when I run it with data CUST_RID = ^ and wondeing...

Keep in mind that an index will be highly efficient for your query if it can "cover" all columns you actually need to have (i.e. if the index definition contains...

It will probably use the composite index if the single column passed in is the leading part of the composite index (i.e. the first column in the composite).

Otherwise, the composite...

This will work only if the #jobOrder table ever hold one single job at...

Since I'm assuming you might want to be able to pull up the firdt incomplete operation for any number of orders at the same time, you might care to leverage...

Sean Lange (8/30/2011)

---

I have known plenty of "dedicated sql specialists" who couldn't write decent sql to save their lives and developers who could write some of the most elegant and...

Sean Lange (8/30/2011)

---

I have known plenty of "dedicated sql specialists" who couldn't write decent sql to save their lives and developers who could write some of the most elegant and...

Then go back to your original statement and try this:

SELECT ISNUMERIC(DataValue) ,'DataValue' =

CASE

WHEN ltrim(rtrim(DataValue)) in('.', '-', '-.', '+', '+.') OR ltrim(rtrim(DataValue)) like '%[^-+.0-9]%'

THEN

cast(CAST(DataValue as varchar(25)) AS SQL_VARIANT)

ELSE...

I have to ask - why is it so important to reseed at all?

I am a little concerned that you are trying to reuse the ID's, which may...

harry.sh16 (8/30/2011)

---

No thats not what i want, i can do most of the stuff myself all i need to know is how to make/create a .mdb file dynamically on the...

Be careful with floor. Depending on how you understand the requirement, it will return the expected answer for positive numbers, but NOT for negatives.

It you're going from float or...