Rajesh (11/19/2008)

---

I am sorry, little confused with the reply. Could you be specific, what's the input and what needs to be the op with few examples. If the the volume...

SQLBOT (11/19/2008)

---

Peter,

I think you'll like the next article which is about knowing what is the DBA's responsibility and saying "NO!" to what's contradicts CIA and the systems you have...

mpdillon (11/19/2008)

---

A friend suggested the following. It seems to be cleaner than mine.

Where cast(varchar(8),EndDt,112) <= Format('01/02/2009',"yyyyMMdd") Sorry for mixing T-SQL and VB.

However, both Jeff and Lynn bring up the issue...

Lynn Pettis (11/19/2008)

---

And doing this can result in your query not taking advantage of indexing on a table. If your tables are small, you...

Zactly... 🙂

Hey, Naked Ape and BitBucket... thanks. It's folks like the two of you that make this all worthwhile. 🙂

GilaMonster (11/19/2008)

---

Jeff Moden (11/18/2008)

---

consider the answer that one wiz kid gave...

"You should be using derived column transformation, and use substring or available string functions. This would help." ... and...

Not what I asked for... I...

I've just gotta ask... what did you need the 1 Billion row numbers table for?

Ok... I think I found an answer that's good enough... the feature list at the following URL says that "Distributed Queries" are supported in SQL Server Express...

http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx

... and BOL says...

Dugi (11/19/2008)

---

wOOOps I didn't see the nr of records for deletion! Sorry for that! This is the reason that the suggestion must tested on the test environment to be sure...

The answer is that you probably want to line up decimal points among all values with commas, anyway. So, do this...

[font="Courier New"]SELECT REPLACE(STUFF(STUFF(STUFF(STR(1234.7656422,16,4),9,0,','),6,0,','),3,0,','),' ,',' ')[/font]

Still want to know...

karthikeyan (11/18/2008)

---

Hi All,

I have the below scenario.

select convert(varchar(30),convert(decimal(18,4),234543242.7656422),1)

is showing

234543242.7656

Since i need the result set with comma seperated i used the below query.

select convert(varchar(30),convert(money,234543242.7656422),1)

is showing

234,543,242.77

But.... The problem is it is...

If you want to delete only 37,000 rows, it should take only six seconds. Do you have any triggers on the table? Does anyone have an uncommitted transaction...

Adi... the link in your signature line is broken... it should be...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Notice... no trailing square bracket.

And, thanks for including it. Wish we could get everyone to do that...