It's easier than you think - you're already on the right track. Try this:

declare @utcdate as float, @cvdate as datetime

set dateformat mdy

set @utcdate = 38279.813344907401

set @cvdate = @utcdate

select @utcdate...

Missed that. I have no idea what the as() function does. Any ideas, anyone?

Phil

Brett, you have created a calculation in your SELECT clause and given it a column heading of 'dnpisimport'. You are not giving the calculation an alias of 'dnpisimport' (this cannot...

No problem. I did a search on the web and found the following link about the FPT function ... do you think that is it?

http://www.basis.com/docsonline/commands/fpt_function.htm

If I create a user...

I've not heard of BBX, but this looks like straight BASIC to me. Having said that, I have no idea what the FPT function does, please elaborate.

It should then...

Thanks very much, I'll try that.

... tried it now and works a treat - thanks v much.

Phil

I'm sure that we can help you do, but you'll have to provide a bit more info before anyone can give you anything specific.

The general form of query that you'll...

Thanks - the returned recordset contains the info I need, but how do I query it as part of my script? sp_helpdevice itself returns just 0 (success) or 1...

Something like this?

select distinct a.ordernumber

from tblorder a

where a.ordernumber not in

(select distinct b.ordernumber

from tblorder b

where right(b.itemnumber,3) 'rtd')

Hi Brett, try putting single quotes around DNPISIMPORT and running this again.

Regards

Phil

Exactly right. Of course, if there might be more than 4 messages, you might have to go dynamic ...

Phil

Hi Karen

I think you'll have to add the Oracle server as a "linked server" - this can be done from Enterprise Manager in SQL Server - and then you'll be...

Something like this should do it:

declare @msg1 as varchar(50), @msg2 as varchar(50), @msg3 as varchar(50), @msg4 as varchar(50)

declare @client as char(6)

set @client = 'a10051'

set @msg1 = (select msg from tblMsg...

If you really have got full design freedom, then here is how I would create the tables:

1) Product (ID (PK), Description, {+ other product info fields})

2) Distributor (ID (PK), Description,...

MAX works fine on string columns.