Search this site for islands. There are several great articles and tons of forum posts on the topic.

If you have access to modify the dll you could probably make some value be your null/default. Something like -42 or some other value that is not possible during normal...

If you try to add a default in your create your will receive an error "Msg 10726, Level 15, State 1, Line 1

User defined aggregates do not support default parameters."....

By far the easiest way is to truncate your new table, change your ID to identity (if it isn't already), then just insert your data. Don't over complicated this, it...

Something like this?

;with data(INGREDIENT_COSTPAID)

as

(

select '0000567K' union all

select '-0000904J'

)

select cast((replace(replace(replace(replace(replace(replace(INGREDIENT_COSTPAID,'A','1'), 'B','2'), 'K','2'),'C','3'),'{','0'),'J','1') * 1) / 100.0 as numeric(9,2))

from data

FYI, the output and sample data are slightly off. In your original...

Not sure what difference it makes but...

Just replace the whole line "''ServerName'' = b.server_name " with ' + @ServerName + '. You don't need to name your columns in the...

kutemom09 (12/28/2011)

---

Hi,

Can someone please help me how to replace and convert the below value to decimal

Example

0000567K AS 56.71

-0000904J as -90.42

and so on

I tried this and got the error

select member_ID,amountPAID,...

WOW I don't know where to begin...so let's start at the top. The first thing that jumps off the screen screaming is @Where, @WherePay and @sort as parameters. This is...

Here is the challenge. You mention four search criteria:

Well, i am creating a search form for emp details where the emp details are filtered based on four conditions

1. unit

2....

suhailquadri (12/27/2011)

---

Thanks a lot bro. It helped me a lot but has a little issue back again..

How should i get employee details when i pass the unit id as...

I agree with the hierarchyid datatype being a better choice but you were so close it hurts...

All you really needed to do was to add an OR condition to your...

If you want some real help you are going to have to help us help you. You need to post ddl (create table scripts), sample data (insert statements) and desired...

And this is still another duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1226674-391-1.aspx

stourault (12/27/2011)

---

Thank you for the response and the code...I ran it on our test server and it seems to work great! It only takes a few seconds to complete and...

Dev (12/27/2011)

---

Sean Lange (12/27/2011)

---

Thanks Roy. I just hope the OP realizes how important it is to not run this in production. The first time I ran this on...