i resend test mail and mail showing unsent in "select * from msdb.dbo.sysmail_allitems" and i checked as below :-
select * from sys.transmission_queue ;
select * from msdb.dbo.sysmail_sentitems;
select * from msdb.dbo.sysmail_faileditems;
result are...

Thanx John,

can i know what i need to do if i add more item dimension like "Total Height","Piercing Dia","Outer Dia" & "Height" AND more qty columns like upto 15

WITH Inners...

i attached below sample excel image to describe how user's software screen looking to entering data into the table through :-

it is surprised for me that no one know solution of this problem.

Neel

Hi Chris,

Firstly thanx for your reply.

I have written below mentioned query that contain six tables:-

LEFT OUTER JOIN on PROD_REQR with three tables (MTP_ISSUE, MTP_TSTK_A & MTP_FGSTK_A ).

EQUAL JOIN on PROD_REQR...

Hi Gail,

Thanx for your reply.

As i already explained in my post why i want to Shrink DB.

I have deleted Table that is occupied 10GB space in DB, so why DB...

Hi GilaMonster,

Firstly lot of Thanxxxxxx for your suggestions.

I created clustered index on ROWID this column never used in Where Clause.

And i created non clustered index on those columns which are...