Are you trying to get the error message details given by system stored procedure sp_displayoaerrorinfo into a variable?

You can either first create a table and do a

insert into (cols) select... or select into * from (select)

--uncomment following line if executing second time in same...

I certainly agree with Jeff and normalization is the solution.

Mine was just a work around.

Use group by instead of CASE, see attached script

See attached script, which contains one way of doing it

Context is not clear. See whether following helps

If you just want to store only the language name then can't you just use the varchar datatype and store the culture...

Can't you use suser_sname() system function ?

You can create a function something like below

--==========================================

CREATE FUNCTION dbo.fnGetCurrencyRate

(

@p_year int,

@p_translation_code varchar,

@p_business_unit varchar

)

RETURNS decimal(27,10)

AS

BEGIN

-- Declare the return variable here

DECLARE @m_value decimal(27,10)

SELECT @m_value = CASE MONTH(GETDATE())

...

It depends on what users want to do with the excel sheet.

If they just want to see the data in excel sheet, you can see alternatives I or II

otherwise see...

I am not sure sql * server allows you to use alias to calculated/normal columns in the where clause.

One alternative is to repeat the calculated column expression in the where...

Try the following example. It is similar to the one in the original problem. I am trying to write to a log table for each insert. You can run it...

Just thought following might help in resolving your problem

When a statement with in sp executes in sql server, and there is a error, whether the next statement will execute or...

It could be due to the fact that the default SET OPTIONS that are set when you connect via query analyzer

and via ODBC.

It looks like in your case the specific...

sp_prepexec does two things

1. Prepares the Stored procedure execution plan

2. Executes the stored procedure

Now the first step usually takes some time depending on the complexity...

As you are saying, there is a user table which maintains security information.

Hence one alternative is as follows.

In Login.Asp Page

- Let us say user details are...