Hey Bob. another awesome avatar you have there this time.

I'm being gracious today. Here is some code for you to check out. The clustered index on the temporary table IS REQUIRED as is.

Code has to be attached,...

I think...

Because I said so! 😛

dmw (9/2/2009)

---

A small correction ...

declare @ThisDate datetime;

set @ThisDate = getdate();

select

getdate() as CurrentDateTime,

dateadd(mm, datediff(mm, 0, @ThisDate) + 1, 0) as BeginningOfNextMonth, -- Beginning...

Try this:

with MyNavAttempts as (

select top 1000

isnull(shippingcost,0.00) as shippingcost

from

dbo.NavAttempts

)

select

sum(shippingcost)

from

MyNavAttempts;

I know what the problem is. Here is your code:

select top 1000

convert(varchar(30), convert(money, isnull(sum(shippingcost),0))) as "Total Navigation"

from

dbo.NavAttempts

The problem is that the...

Duplicate post. Please post replies here.

Please do not cross post.

Duplicate post. Please post replies here.

Please do not cross post.

Can you please show us what you are trying to do, what code have you written so far?

Duplicate post. Please post replies here.

Please do not cross post.

Check the data, run this:

select top 1000

shippingcost

from

dbo.NavAttempts

I'd start by showing us what you have tried so far. hard to know what you are doing wrong in your code without seeing it.

Give this code a spin. It is untested as you did not provide the DDL for the tables or any sample data. To see how you really should...

select replace(convert(varchar(8),getdate(),5),'-','');

Try the above.