Arun,

You did a great job by including the table creation script and insert statements to populate it.

I have seen too many times a question asked without making the effort. You...

There is a similar discussion at

h[font="Courier New"]ttp://www.sqlservercentral.com/Forums/Topic655509-8-1.aspx[/font]

I was going to ask if you really need unicode character set (ntext) but if you are storing sanskrit characters then ntext would...

OK, this is fixed.

Had nothing to do, just a stupid programming mistake in the loop that parses the OD lines. I am too embarrassed to describe it.

Thanks to all who...

Thanks.

I'll Gail's bl;og a try.

Regards

Christopher,

The composite index had caused problems for me earlier when I was inserting data in a table when for some records the data on the two columns indexed was not...

Christopher,

This is a 5000 line long SP. I was afraid to even attempt to get the SQL Profiler involved...

I'll give it a try but I am now stuck on something...

Jack,

I already tried creating indexes on columns fk_PO_ID of each table. Instead of the 5000-line SP completing in 3.1 minutes, it was still running after 4.5 minutes, at which point...

i need to sum the values from Exp_5 (900) and replace them in onother table st.total

In your onother table, is there ONLY a SINGLE record, which is overwritten with...

Sounds like the beginning of a flame war.

Let's keep our cool here.

Regards

Hammer and Chisel?

Funny Jeff!

How about:

PCM (Puff Cloud Modulation)

Writing it on snow (don't eat the yellow snow)

Skywriting

No offense intended to anyone.

Philip Horan (1/29/2009)

---

Hi. I have would like to substitute NULL in query output with 0 (if possible).

I have tried:

(SELECT

SUM(CASE WHEN soi.ItemValue = NULL THEN 0 ELSE soi.ItemValue END)

WHERE...

When I fisrt started sending e-mail from the SQL Server, the stroed proc I used worked fine, except that there was nothing - NO error message, NO e-mail received.

I found...

The OP has ignored repeated requests as to the WHY of it.

On top of that he has been warned repeatedly that is a bad idea.

If all he wants is a...

Another thing I just thought of:

At the first PRINT, abort the stored proc by entering the command

RETURN -666

So you can immediately get the the results, without having a few hours...

At not even 100 lines, your beast is...