That's exactly what it does and utilises that value in a later stage of the SP (which I didn't include in the code).

The while loop is horrendously slow compared to...

But thats what I want, I want to pull the value from the table incase it has changed, instead of it being hard-coded in the formula.

Is there another way round...

How can I make my function deterministic ?

I don't pass any parameters into it and it always returns the same result, so why is it non-deterministic ?

Andrew

Thanks.

Tried that and got this:

Cannot create index because the key column 'IX_CSD_NomIPTBLB' is non-deterministic

Thats the bit I'm stuck on.

I've written a function like this to return the value 6450 from the DB:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[fn_GetTLB] ()

RETURNS char(4)

as

BEGIN

DECLARE @TLB...

You already got it at the beginning of thread:

[CSD_NomIPTBLB] AS (case when ([CSD_LoanType_ContOrItemOwner] = 'I') then (convert(char(4),[CSD_IIPTBLB])) else (case when ([CSD_CIPT_Confirmed] = 1) then (convert(char(4),[CSD_CIPTBLB])) else (convert(char(4),'6450')) end) end),

I...

oops sorry

will do

??

No completely lost now.

Can I replace the last else with a function ?

You've lost me talking about CREATE TABLE in place of the computed column

Can you give an example, as I tried it without much success.

Thanks

Andrew

Yep, I know how to do all of that. Thought you were somehow suggesting using the view in the calculated column formula.

I need this value writing up into the...

Thanks. I suspected as much.

Can you expand on the use of a view, not clear to me where I need to use it.

Andrew

Solved it.....

EXEC ('INSERT INTO [' + @Filename + '] remainder of query')

A similar concept would work for an INSERT, but because I specify the column names in the insert statement my insert statement exceeds the size limit for the @cmd variable.

Any...

Found one way round it using SELECT (pasted below) now going to try something similar with INSERT.

ALTER PROCEDURE [dbo].[aiidb2_DRAc_Copy_DRAcCURRENTData_To_DRAc_Archive_File]

@FilenameVARCHAR(20)

AS

DECLARE @cmd AS NVARCHAR(1000)

SET @cmd = N'SELECT * INTO ' +...

Yes. That does the trick.

Thanks