I am the only one who is using this table..i can...

Koen Verbeeck (9/20/2012)

---

Your mistake is in using the OLE DB Command for doing updates, which is very, very slow.

Try writing the rows to a staging table and do an UPDATE...

Sean Lange (9/4/2012)

---

Charmer (9/4/2012)

---

Mark Eckeard (9/4/2012)

---

If you need this added to a query where you don't always know the value, try this:

select replace(YourColumnNameHere, '.00', '0.00')

This worked when I tested it...

Mark Eckeard (9/4/2012)

---

If you need this added to a query where you don't always know the value, try this:

select replace(YourColumnNameHere, '.00', '0.00')

This worked when I tested it using this code:

with...

Adi Cohn-120898 (9/4/2012)

---

Do you always have space before the decimal point? If the answer is true you can use the replace function to replace ' .0' with ' 0.0'....

ChrisM@Work (8/30/2012)

---

Thanks for the feedback. The original table had an unnecessary join which the new query eliminates, and if you can remove the DISTINCT now, then you remove a memory-hogging...

ChrisM@Work (8/29/2012)

---

Try putting the FOR XML PATH stringinator into a CROSS APPLY, where it can crunch up the rows of PSFDOC separately from the rest of the query. You might...

Thank you so much, Pal...I really appreciate your suggestions

Yes, order is must because...

GSquared (8/28/2012)

---

The only way I see to possibly avoid tempdb on this one would be to build permanent tables, do the work in them that tempdb is doing in worktables,...

Phil Parkin (8/24/2012)

---

If you're using full cache, I am not certain that the index will help (it's loading all the columns into memory anyway) - but worth a test.

The index...

It's hard to tell without knowing your data.

Partial cache is good if you know that certain rows are going to be looked up many times. But if the lookup is...

i read the article Phil,

Could you please give me your idea for my condition?

My situation is , Look up or reference...

Lynn Pettis (8/17/2012)

---

Charmer (8/17/2012)

---

Lynn, what about trailing spaces.....? they are char data type .....so if data is less than the exact length, automatically the reamining length will occupied with empty...

Lynn, what about trailing spaces.....? they are char data type .....so if data is less than the exact length, automatically the reamining length will occupied with empty spaces right? ...then...