That's why I asked for more info. I didn't really feel comfortable giving an answer with so little info to really go on.

Try this:

select

rwa_id,

'P'

from

leads_ce_work ce

left outer join common.dbo.acode ac

...

Alvin, congrats on figuring out what was needed. Of course, it won't make use of any indexes that may benefit the query if they exist. 😉

Still confused. You need to provide a better description of the problem and what you are trying to accomplish. Some sample tables (DDL to create), sample data (in...

For what it is worth, the following also returns the "correct" answer based on the original post:

create table #temp

(

week1 decimal(16,8),

week2 decimal(16,8),

week3 decimal(16,8),

gross decimal(16,8)

)

insert into #temp

select -9.12000000,-11.03000000,5.61690000,0

declare @a1 decimal(16,8),@a2 decimal(16,8),@a3 decimal(16,8);

update...

I refuse to post a link, but I really want to know what our favorite PhD candadate learned while in school for his current degrees.

I'm also curious how he manages...

karthikeyan (5/6/2009)

---

I tried the below code

DECLARE @Fixed1 decimal(8,4), @Fixed2 decimal(8,4), @Fixed3 decimal(16,8);

SET @Fixed1 = 5444.32;

SET @Fixed2 = 12121.03; <-- Problem is here. decimal(8,4) means you only have room...

What does the date represent, the end of the reporting period? How does it equate to the start of the period? Using the dates in your original post,...

Looks like a permissions issue. You may not have the proper permissions to access the files where they reside.

First, if you are willing to spend a little money, instead of downloading SQL Server Express (free) you may want to purchase SQL Server Developer Edition for about $50.00 USD....

mike brockington (5/6/2009)

---

@Lynn

Maybe I should have made it explicit that my comments were based on experience, not on conjecture.

If the OP thinks it works well, I would be interested to...

Set based queries. Stay away from cursors! With that, they need to think differently when accessing data, they need to think in sets, not rows.

Yep, just confirms what I said, the snow just...

Only problem I see based on the above is...

Please do not double post. It will simply fragment any responses you may receive.

Please post any replies here.