today I created indexed view but it also did not help, still zooms around 30 seconds. So I have released this approach, Still waiting for any revolutionized idea to bring...

Please find the attached query plan.:cool:

Hi Megha,

I have applied that also, But result is same. I am just going to share execution plan as need to modify table and field name will take some time...

As I said temp table is consumed in another procedure in which complex business logic is written and based on the data in this temp table various things happen in...

I have stored procedure in which this simple query is being used to fetch records into temp table then consuming that table in another procedure and doing some grouping and...

What you would like to suggest if I create a view of tables including columns used in select query and then create unique clustered index on PartitionID of first table..

Sorry, I cannot share execution plan..else I would like to help with whatever possible like any info on this further. I dropped the primary key clustered index and create a...

Table 1

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

CREATE TABLE [dbo].pp(

[PartitionID] [bigint] NOT NULL,

PID [int] NOT NULL,

[Date] [date] NOT NULL,

CID [int] NOT NULL,

PPID [int] NOT NULL,

LE [decimal](38, 8) NOT NULL,

SE [decimal](38, 8) NOT NULL,

GE [decimal](38, 8) NOT...

;

in fact title of the Question is answer :w00t: :hehe:

Really nice question.

AND ANSWER IS

IF OBJECT_ID('test_parent_table') IS NOT NULL

DROP TABLE test_parent_table

CREATE TABLE test_parent_table

(idINT,

nameVARCHAR(30)

)

GO

IF OBJECT_ID('DataError') IS NOT NULL

DROP TABLE DataError

CREATE TABLE DataError

(ErrorNoINT,

ErrorDescVARCHAR(1000),

ErrorProcVARCHAR(100),

ErrorLineNumberINT,

ErrorDateTimeDATETIME2(7)

)

GO

IF OBJECT_ID('ThrowError') IS NOT NULL

DROP PROCEDURE ThrowError

GO

CREATE PROCEDURE ThrowError

AS

BEGIN

DECLARE@errorNoINT,

@errorDescVARCHAR(1000),

@errorProcVARCHAR(100),

@errorLineNumberINT,

@errorDateTimeDATETIME2(7)

SELECT@errorNo=ERROR_NUMBER(),

@errorDesc=ERROR_MESSAGE(),

@errorProc=ERROR_PROCEDURE(),

@errorLineNumber=ERROR_LINE(),

@errorDateTime=GETDATE()

DECLARE @id INT...

Hi,

OK.

Kindly check whether teh sql service account has permission to execute the cmd commands and the user who is executing xp_cmdshell have granted permission to execute this procedure ..

---

Ashok

Yes, Great, I found a solution for it.

that is :-

exec msdb.dbo.sp_send_dbmail

@recipients = xyz.abc@abc.com',

@subject = 'hello Yo Yo Honey Singh ',

@file_attachments='E:\temp\Blue_hills.jpg',

@body= 'Suno Mere Veero Ajj Meri...