There were some changes in the query that you have provided but it helps a lot and sort out my problem.

Thanks a lot for your prompt reply.

I have modify the query but not getting desire result.

Can anyone have a look both query and let me know if i am missing anything?

DECLARE @keydoc INT

SET @keydoc =...

I have to combine them using column and join condition.

It's little bit difficult, that's the reason i have attached query.

Thanks a lot for your help.

That works for me.

Greatly appreciate your help.

sqlzealot-81 (2/22/2012)

---

SELECT number into #TempInts FROM iter_intlist_to_table(@keyPlantOperatingStatusExt)

This is the easy way to create a temp table.Use this temp table(#TempInts) for the query.

Apart, I would recommand you to use Exists instead...

I have created temp table as below

Create PROCEDURE [dbo].[s_PowerProjects_getRecentUpdates_]

-- Add the parameters for the stored procedure here

@keyPlantOperatingStatusExt varchar(max)...

It's already there in SP.

If i use that function then logical reads goes very high.

I am not sure but can you please help me with

creating a temporary table...

Any update?

Can anyone please help with this?

It's little urgent....

It doesn't make any difference.

I have used both option.

Most probably the problem occurs from iter_intlist_to_table function.

Is there any way i can rewrite this function better way?

Please check the .SQL plan,...

Can anyone reply on this?

Thanks

Actually this table has already few rows for Primary key

Let say from 1 to 20,000.

But i need to insert data from two different tables and new key value will...

Is there any way you can script that out for better understanding?

I think i am not getting it correctly.

Thanks for your prompt reply.

Basically we are trying to have those agents not running during the Sunday (On DEVDB2) and we just want to make sure that we don't alert on (PRODDB3/R1)these during...

Error we are getting is there is no current database backup.

We never change recovery model and current database backup is there.

Attached screenshot for the error.

Thanks for quick reply