Considering a few factors:

1. I am not independently wealthy

2. I do not work for a corporation because I enjoy it

3. My...

The requirements for this questions don't seem to support the given answer. Upon reading the question, my initial reaction was that the results would be 0,1.

Upon opening...

I am very confused as to why the comments stated:

"This is one of the reasons to rely on checking 'equality' rather than 'inequality'". The result was generated as expected.

Another good option to be aware of is that you can assign values directly from your SELECT statement...

SELECT @valueA = Field1 FROM someTable WHERE...

This offers the ability to assign multiple...

If I could only wake up from that dream 🙂

Long live the geek. Could you imagine Dilbert in a management role?:-)

SSRS 2005

Time to enjoy the wonderful aspects of home and family.

If the value is for display purposes, and not required to be a decimal data type, you could format it as a string like below:

DECLARE @Input DECIMAL(16,6)

DECLARE @precision...

It sounds as though your proc is sending the email since you receive the message when running the proc directly from query analyzer.

If you are receiving the email with empty...

amdavis (4/20/2009)

---

Hello,

I'm currently using psloglist to export some security logs to csv format then importing them into a sql 2005 database.

Use Apr09

bulk INSERT Ramses

...

I guess I should have read all pages in the thread before the last two posts to reduce post redundancy:-)

GilaMonster (4/13/2009)

---

There's a lot more to consider than performance.

Truncate deletes all the data in the table. Delete can have a where clause allowing conditional deletes.

Truncate does not fire triggers, delete...

Correct me if I'm wrong, but as far as I'm aware, you can't perform a conditional TRUNCATE,...

How about using this option, to preserve your datetime format:

SELECT TALLY_NAME FROM TALLYS WHERE LAST_UPDATED_DATE < CONVERT(DATETIME,'15/04/2009',103)

--103 STANDARD