Nice to know, but as you were given several alternatives, what is your final solution?

Here is some code for you all to play with. Use at your own risk. I tested this with my Tally table.

create function dbo.tvf_EOM (

...

Years ago while attending Regis University for my BS degree, one of the courses I had to take was an Ethics class. Looking at things today, I think that...

Developer/Programmer of some sort. Maybe be in IT Management.

Show us what you are asking with a concrete example. Just from your description, I'm not sure what you are asking.

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?