please provide create table scripts,sample data and expected result .

HI

Try this method:

SELECT E1.Place, E1.Objective,E1.Year,E1.Month,E1.Exam1, E2.Exam2,E3.Exam3

FROM #tmpExam1 E1

inner join #tmpExam2 E2 on E1.objective = E2.objective

inner join #tmpExam3 E3 on E1.objective = E3.objective

please provide same Temp table and sample data.

clear give the exactly your expected values.

sure, please find the solution for this issue.

FIX 1:

USE tempdb

GO

IF OBJECT_ID('tempdb..#VersionFormat_tb') IS NOT NULL

DROP TABLE #VersionFormat_tbl

CREATE TABLE #VersionFormat_tbl

(

[FormatID] [smallint] NOT NULL,

[Description] [varchar](50) NULL,

[fileExtension] [varchar](10) NOT NULL,

[versionFormatTypeId] [tinyint] NOT NULL,

DisplayOrder SMALLINT...

yes you are right Gail Shaw, the suggestion you proposed is working fine.

thank you.

Thank you very much sgmunson.

Now i am clear on this.

Sample testing.

CREATE TABLE test11

(

id INT IDENTITY (1,1),

lastupdate VARCHAR(100)

)

INSERT INTO test11 DEFAULT VALUES

SELECT count(*) FROM test11

SELECT * FROM test11

(SELECT 42 AS tMask) AS X

Hi sgmunson,

can you please tell me how you inserted the below code in table format ?

(SELECT 42 AS tMask) AS X

Thanks

Bhanu

hi All,

Can any one tell me how to paste the code in box rather than plain text.

i mean i would like to paste the code in table format in the...

can u paste the table structure of Audit_Errors.

Then i will show u the issue.

Please check the table definition may by primary key on below columns.

State (null), Procedure (null), Line (null)

i tested it the with out primary key and it is working fine.The results...

thank you so much for your help.

Thank you for your detailed explanation.

hi,

for sample example i given this tamp table and sample results.

the original query is different in my project.

any other way to avoid this index scan.

i need solution for issue.

Thanks

Bhanu

as per your advise i created two non clustered indexes:

CREATE nonCLUSTERED INDEX ix_credate ON bhanu1(credate)

GO

CREATE nonCLUSTERED...