Here is my function we are already inserting into temp table inside the function.. this is taking some time to retrieve the results.. to see the actual timings I kept...

I am not selecting all columns from emp table

this is a function i am calling here to check the performance to see how it works for 10000 iterations.

select col1,col2,col3 from...

we have a job(ssis package) where it load data from different source and destination is temp table. from temp table I have to move to main table.

selecting rec from temp...

Then how I have to create error in the function?

how this function will fail? I am trying to create this eror condition inside the function.And this func is calling from...

Here we are returning 4 columns as I mentioned only one @NUM.

There is another reason to use table valued function.

Can you please modify the above one where to use THrow?

This didn't worked for me - Select * From table where SubString(ID,1,3) <> 'ING"

It still showing all the records that starting with ING

What do you mean by agreed?

I cannot keep these substring and stuff in where clause.

I am trying to get all the data from table where ID does not start with...

There is no simple statement other than substring?

like select data form table where ID not....?

The ID field data will show -

ING20162044285910

ING20162044285976

ING20162044285979

ING20162044285979

ING20162044285973

Now I need data -

20162044285910

20162044285976

20162044285979

20162044285979

20162044285973

How to remove the first 3 characters ING form this field?

select all the records where ID does not...

Set based approach? How to do this?

How to parse(split) this 9000430944:7|Information

-> 9000430944 - emp number

-- 7 - stud number

--Information - Description

How to split on pipe? and How to split...

In the stored procedure - I need to implement a loop based logic after update statement ..

Now I have to add a logic in this stored procedure

after update statement...

I want to exclude one column from select list how to do this?

Column is empname(need to exclude from selct *)