I'm sure that this does what you want, but why not convert the function to a DLL? You could use sp_addextendedproc to create an exenteded stored procedure and then...

Try this:

select <col1>, <col2>

from <table_name>

where ( <col1> between 1500 and 1598 or <col1> between 3500 and 3599 or <col1> between 3900 and 3999 )

and .... /* Other...

Do you have the same settings in the RAID Manager eg for read through, write through etc?

Jeremy

In you destination db, right click the tables table and then import data. You will then be able to transfer one or more tables from a source database.

Jeremy

Try this:

select convert(decimal(10,2),2.49084932)

Jeremy

Within stored procedures, you can use:

return <numeric_value>

which you client app should be able to trap espically if you are using ADO.

You can put any numeric value for...

Have you looked at Bill Wunder's tool in the the Freeware section?

Jeremy

Another way is to do it is thorugh a self join matching every column to itself.

For example:

select a.*

from table a, table b

where a.col1 =...

There is probably no right answer to this.

In general, set based processing is usually quicker than individual row based processing. Nobody would dream of count the rows in a...

A couple of ideas depending on how much data there is.

1. In the ASP, use GetRows to put the entire recordset into an array. Then loop through...

I think the problem is that in the statement

SELECT organisation.*,

(SELECT LTRIM(RTRIM(orgname_name))

FROM Organisation_name

you need to change this to:

SELECT organisation.*,

(SELECT LTRIM(RTRIM(orgname_name))

FROM Organisation_name as organisation

Jeremy

Make the temp table a global temp table ie ##test. This will persist for the duration of the connection or until you drop the table.

Jeremy

Try this:

create procedure [proc1] @cursor_name cursor varying output

as

declare @string nvarchar(1000)

set @string = 'declare cursor_name cursor for

select blah from foo ' + char(13)

if len(@p_vcwhere) <> 0 set @string = @string...

The problem might be the scope of the temp table. xp_sendmail runs from the master database whereas you are executing the proc from your user database and the temp...

where oper_year between 2001 and 2002

and oper_month between 01 and 09

The problem is that you are only selecting months 01 to 09 so you are not getting anything for the...