I am using sql server 2008 R2. And I may have more than 1000 values in m y temp table and value pass this all to UDF.

Thanks , That's what I was looking for.

Thank you very much. I just jumped without checking book online.

I got it on my own.

Below is the Answer:

SELECT SUBSTRING(@desc, PATINDEX('%[$]%', @desc)-11,11)

And yes. I have 15-16 different color so right now I am repeating code for 15 times with different color in where condition.

Do you have any better way of...

Sorry for replying late.

And thanks for your awesome solution. It's what I wanted in my actual scenario.

Thanks Again

Thanks for your response.

But How Can I pass the values of temp table to the store procedure?

sample Source table is

CREATE TABLE #TABLEA

(

Id INT,

RowNo Int

)

INSERT INTO #TABLEA

SELECT 1,20

UNION ALL

SELECT 2,40

UNION ALL

SELECT 3,10

SELECT * FROM #TABLEA

and I need to compute 2 more column

Expected Result:

Id ...

No we don't have the start and end column.

I need to computed it on the fly and then insert into temp table with all 4 column.

From source ,only 2 column...

Also Sorting TableB on ID column for update.

Sorry for not giving the enough detail.

1)Importance in TableA is not repeating.

2) I am sorting on Importance column.

3) percent column total is exact 100.

4) I am using SQl servere R2

Thanks Gila,

Nice way of doing Insert and update auditing . I appreciate you solution.

But My requirement got changed and now I have to do it using stored proc so It...

Nice way of doing Insert and update auditing .

But My requirement got changed and now I have to do it using stored proc so It made my work so eazy.

Thanks

I solve it by my self through reading some articles.

Thanks

Can I create trigger on Table ?? I mean logic that check that any update statement occur on the table or not and if occur then insert old rows...