And why not do this instead:

DECLARE @ld_TestDate datetime

SET @ld_TestDate = CONVERT(datetime, '2009-03-06 00:00:00')

SELECT * FROM tbldeals

WHERE trade_date >= @ld_TestDate

AND trade_date < @ld_TestDate + 1

i.e. do...

About the use of the GOTO: this is not a religious issue.

Yes, GOTO can generally be avoided but there are exceptional cases where it is useful. For instance to terminate...

Not good enough.

I want the satisfaction.

In fact, a knife would be even more personal.

OKay ...

Yes I did learn something here, about a star symbol being entered by an implicit conversion. All the more reason to condemn "tricks" like assigning an integer to a...

Is there like a point to any of this ?

Unless there is a darn good reason I cannot fathom, this kind of programming is to be condemned.

Especially since even a...

Why is an SS2K5 question posted in this SS2K forum ?

If users keep mixing forum contents, pretty soon it will become that much more difficult to find something in the...

Simple. Add a loop continuation condition in your WHILE statement.

[font="Courier New"]DECLARE @lb_Exit bit

SET @lb_Exit = 0

WHILE (@@FETCH_STATUS = 0) AND (@lb_Exit = 0) BEGIN

...

For anyone else interested, this is what I found out:

0. Out of curiousity, tried the IFCode function to format the code so I would not lose the indentation. Learned something...

Thanks for your help.

I completely missed checking what the "Location" was for. Too much in the Microsoft mindset of "Save as Type".

Learn something everyday.

Best regards

OK,

I am working in Entreprise Manager / Microsoft Management Console.

In there, I see no option allowing to save as VB file. How do I go aout it ?

Regards

-> Steve Jones

Imagine you have an established product that produces profit for your company. You decide to launch a new product. The new product likely will suck out profits as...

-> mhaskins

I like you icon !

More on that larger issue.

HR:

You need a to hire a person in your department. But you are not allowed to place an ad...

Way back when the PC came out, there was this big engineering firm with an IT department (it was not called this way, I do not remember the exact name).

That...

If are unsure of your data, you might identify the offensive values with something like this:

[font="Courier New"]SELECT whatever

FROM wherever

WHERE ISNUMERIC (whatever) = 0[/font]

Since it takes just one single bad apple...

Why did you post a question related to SS2K5 in this SS2000 forum ?