These three links should prove useful.

http://bit.ly/1h7OqYJ

http://msdn.microsoft.com/en-us/library/ms188038.aspx

http://technet.microsoft.com/en-us/library/ms187348.aspx

Seems like it should work. However, you should NOT use select * when populating your variable. You should ALWAYS use the actual column name. Consider what happens if at some...

You would have to add a dateformat to your script for this to work.

SET...

Or maybe this??

where ISNUMERIC(SomeValue) = 0

ISNUMERIC is rather useless because it can return some false positives too. http://www.sqlservercentral.com/articles/ISNUMERIC%28%29/71512/%5B/url%5D

Make sure you read to discussion too.

Do you want any rows that do not contain any numbers? It is not entirely clear what you want here.

with someData as

(

select '1.51922e+015' as SomeValue union all

select '1.53122e+015' union all

select...

jbalbo (4/17/2014)

---

Thanks worked great and I learned something new today 🙂

CASE WHEN charindex('@T_750_finalscorestatus = "Draft"', Assessment_data) > 0 THEN 'Draft'

...

You fix it by using datetime instead...

jbalbo (4/17/2014)

---

Wow Sean, and I tried real hard on this one... LOL 😀

I guess size really doesn't matter..

what I need are the 5 characters following the...

You gave us some business rules but...

You might want to take a look at this blog post from Gail. She goes over how to handle catch-all type queries. This is very close to that type of...

wendy elizabeth (4/17/2014)

---

I have a few questions about the following t-sql 2008 r2 sql code listed below that is calling a stored procedure:

DECLARE@return_value int,

...

OK. I need to understand some of the business rules here. Let's start with the first order and the first item on it.

select *

from Orders

where SalesOrderNumber = 'S19856'

and ItemNumber...

rootfixxxer (4/17/2014)

---

Hehehe, i just forgot to save the @Percentage value for each row, or at least when the first insert statement doesnt run... But nice to pointing that out. 🙂

Thanks...

Starting a new thread on the same topic with the same lack on information is not going to provide a better answer. You have to keep in mind that we...

Without going into great detail you need to use the datetime datatype for dates. Using numeric(8) for dates is going to be a serious pain to deal with. I realize...