You can also do a 2-step: import the data into (var)char field, then use the REPLACE() function to strip out the commas while converting to your decimal field.

update imported

set decField...

You can also do a 2-step: import the data into (var)char field, then use the REPLACE() function to strip out the commas while converting to your decimal field.

update imported

set decField...

You might also considering storing this value as a denormalized column on your table. You can add a CHECK constraint to enforce your business rule. Since you're trying...

If you use the decimal() data type and specify (for example) decimal(16,2), all your amounts will be stored in cents all the time. Round will occur in the calculations...

Replying to me own post ;; tsks tsk

On indexes- keep in mind that they're data too. When you insert a row in a table, every index on that table...

quote:

---

Hello evrbody,

how can I increase max size of varchar type..

---

If this is a SQL server...

quote:

---

Non-clustered indexes are "normal" indexes, you can have as many as you want.

---

Actually you can...

Your link to your protected server keeps us from seeing your pretty picture.

EM drops and recreates objects when you use it just to edit a view or proc. Once an object is created, use ALTER to change its contents and not...

If you are wanting to create a view from the output of a stored procedure, I don't know of any way to do that. If you want to write...

We have a couple of ways of dealing with this. You have to accept that this is "denormalized" data and provide a way to update it when your org heirarchy...

If you want to keep track of what's been replicated, set up another data base on your same server as a replication subscriber. When replication completes, you will have...

This is similar to what was already suggested but different enough to warrant posting:

Create a table-valued user-defined function that returns the keys for the table. This UDF takes the...

I'd say the underwhelming response speaks volumes.

way to obvious an answer. I wish I'd thought of it.