plain wrong.

Ok, Jeff, I'll tell you Ever fumbled around with index fill factors? There are times when they have to be adjusted. How should a maintenance plan...

I'm afraid you missed the goal

or do you think, i'm payed per line of code?

definition : of course - just overpaced while planning dinner 

But with the query, it is still NOT clear, whether inner or outer joins are meant. The...

I wonder, why people always confuse CURSORS and LOOPS or whether they even know the difference...

One solution:

BEGIN TRAN

DECLARE @OrderID INT,

  @OrderAmount FLOAT,

  @OrderAmountScheduled FLOAT

WHILE @myAmounttoSchedule > 0

BEGIN

 SELECT

  @OrderID = OrderID,

  @OrderAmount = OrderAmount,

  @OrderAmountScheduled...

DDL = data description language, which means the creation statements for your tables in this case.

Is the following, what you mean? :

On an event, multiple races take place(e). 

For...

Post the DDL please. For now, I recommend, you qualify your joins. SQL Qyery Optimizer interprets, true, but are your joins MEANT to be what is interpreted? e.g. INNER, LEFT...

>P.S. What a stupid idea to have date and time 1st - separated, 2nd - in varchar!<

True. But I know where it originates ...

Why make things simple when there are so many beautiful ways of complicating them?

I suppose, your Calendar doesn't use correct datetime-format either ...

SELECT

SUM(DATEDIFF(ss,convert(datetime, RecvdDate + ' ' + RecvdTime),convert(datetime,...

Have you checked, whether the object is really created?

Next, are you sure, that you don't have to initiate some method on your object? I mean, you pass a parameter, do...

Serqiy is completely right, as far as design is concerned, but if you can't change design anymore, there's still another solution:

Since you will not have an infinite number of...

That's the >furthermore< script, monsieur, illustrating what  - CETERIS PARIBUS - is meant by the omission of an unnecessary grouping and ordering, not the proposed statement.

I suggest you cast only one of them, the one with the extended time information. You don't have to care about the format, since internally there's no difference in the...

I'm afraid, the table has no fields as well

Do you have a primary key that incorporates some logic, sort of identity-like procedure?

Otherwise, if...

No, I still don't! For an obvious reason - there's no need to

Have a look at the whole thing: I did NOT...