make sure you understand the code incase the business rules change.

the last post of mine will always replace the 3rd last char...

try this one:

SELECT STUFF(@String,(LEN(@String)-2),1,'V')

Or

SELECT REVERSE(STUFF(REVERSE(@String),3,1,'V'))

here are all 3 example:

DECLARE @String VARCHAR(100)

SET @String = '234$123,N,N'

SELECT STUFF(@String,CHARINDEX('N',@String),1,'V') as [Replace 1st N]

SELECT STUFF(@String,9,1,'V') as [Replace 9th Char]

SELECT STUFF(@String,PATINDEX('%[A-Z]%',@String),1,'V') as [Replace 1st Alpa char]

is the query gonna always replace the first 'N' in your string with V or is your query gonna always replace the 9th position with V or will it always...

Hi Again,

Sorry I have been on holiday for the last 2 weeks 🙂

Do you still an explanation?

Thanks

Chris

Then I would says that what Lynn and I have posted with regards to the cross apply is what you looking for.

HOWEVER. because you going to be using multiline functions...

ok I see...

Would it be possible to see the function?

That way we can help you optimise the query.

sorry miss understanding.

When you say you can't get ride of the tvf! why is that?

I'm saying don't change or delete or alter the tvf. just leave it in the DB...

use the tally solution

try this

CREATE TABLE InputFields

(

InputFieldsID INT,

InputFieldName VARCHAR(100)

)

-----------------------------------

INSERT INTO InputFields

SELECT 1 ,'Name' UNION ALL

SELECT 2, 'Claim #' UNION ALL

SELECT 3, 'Email'

CREATE TABLE InputValues

(

InputValueID INT,

InputFieldsID INT,

InputFieldValue VARCHAR(100),

RowValue INT

)

---------------------------------------------------------------

INSERT INTO InputValues...

P.S if you wanted to use the function method then you would need something like a cross apply.

select *

from @tblDriver

CROSS APPLY dbo.tvfGetNumbers (StartNum)

However this would not be great code...

Would this work?

It requires a tally table but does not require a function

SELECT

RecNo,

StartNum + N -1

FROM @tblDriver, Tally

WHERE N < 4

I'm not sure how your data is in your table but I think this is what you looking for:

DECLARE @YourTable TABLE

(

ct_code INT,

type CHAR(1),

gm_id INT,

gl_id INT

)

INSERT INTO @YourTable

SELECT 201,'D', 1, NULL...

if it's null it's because there are no costs for that column.

You could use isnull around the cost values to so Zero or add a where clause to exlude rows...

Hi Jack,

Yeah concurrency is a problem with the solution provided.

The DBCC reseed to 0 then a reseed will always give you the next avaible seed value.

However I am with...