You will need to import the data you need from the Sybase database to a temporary or staging table and then use that table in your function(s)/query(ies).

Also, what table(s) does this view access: vWorkflowTransition?

I am basing my assumption that this is a view due to the naming convention used in the name.

sorry, crushed you will be.

Hmm, backwards I should walk with my light sabre out...

Why can't you modify the query?

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....