Thanks Paarthasarathy.Now it is working fine.

Thanks everyone.

Regards,

Sumanta

This is my procedure.Please help.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

/*--------------------------------------------------------------------------------

PURPOSE :

DEVELOPER :

DATE ...

Dear Sir,

While executing procedure i want the output should display like

0000001005 1900-01-01 0010 SPLM 6800 ERR MSG 247387 //Desired output

But now i am getting output(wrong output)

0000001005 1988 0010 SPLM 6800...

Dear Sir,

I should get the out put like this

00000010051900-01-010010SPLM 6800 ERR MSG247387 //Desired output

But now i am getting output(wrong output)

000000100519880010SPLM 6800 ERR MSG247387 //wrong output

The...

Thank you very much Lynn Pettis!!!.

Now It is working properly.

Regards,

Sumanta

Dear SSCommitted,

I want the Output Which should be like

/* desired output

12345TPLM-50000T

12346APLM-50013A

123474PLM-500244

12348TPLM-50000T

34512TPLM-50000T

*/

That means when the join condition not satify then display IPC.[STATUS] But not dispaly the null value.

Please...

Dear Lynn Pettis,

Please suggest me how i will get the correct output in your query.

Thanks,

Sumanta Panda

Dear Sir,

For Example

SELECT PER_NR,STATUS,SOC_MAPPING FROM INBOUND_PLM_CHCM

12345 0 PLM-5000

12346 ...

Thanks everyone for your prompt response.

The solution which you have provided to me is working fine.

Once again thanks for your valuable time.

Regards,

Sumanta

Thanks a lot.It is working fine.

Regards,

Sumanta

Dear All,

In the SQL SERVER ,i have seen an artile to metioned how will you prepare the execution paln.

SET SHOWPLAN_ALL - SET SHOWPLAN_ALL will instruct SQL Server not to execute...

Hi All,

We are not retriving the query without condition in the WHERE Clause.But i am facing problem in some of the query i am using this table.It takes many time.

Please...

Dear All,

As per your advise i am using MS Upgrate tool it will report the details we need to change database level.It is ok to implement it.

But in my java...

Yes i am looking for the location of the SQL database files themselves.

Thanks!!!

Regards

Sumanta Panda

Dear All,

As your valuable advise(To use SQL Server Upgrade tool) really helped me to finding the necessary changes because of SQL Server 2005 migration.

Apart from that i am facing some...