All the columns being used in the join are key columns and are indexed .This query was run in US and i am not sure how long it has taken...

SELECT

 dh.KNOWN_AS Banker_Name, 

 ha.TITLE Title,

 ha.active_location Location,

 org.division_name Sub_Division,

 hohh.group_code Group_Name,

 hohh.sub_group_code Sub_Group_Name,

 CASE WHEN dp.syndicate_number IS NOT NULL THEN 'Y' ELSE 'N' END Syndicate,

 CONVERT(varchar(10), dd.calendar_date, 105) Expense_Date,

 da.ACCOUNT_LEVEL1_DESC Group1_Name,

 da.ACCOUNT_LEVEL2_DESC Group2_Name,

 da.ACCOUNT_LEVEL3_DESC Account_Name,

 fe.DOLLAR_AMOUNT Trnsaction,

 fe.LOCAL_AMOUNT Transaction_Local,

 dc.CURRENCY_CODE Transaction_Currency,

 fe.LINE_NO Line_Item_Number,

         fe.comments...

Hi ,

The flow of the tasks within the package depends on the precedence constraints connecting them and not on the sequence no of tasks that was placed in the package

Hi Jules,

Thanks a lot for being so kind in responding.But still i am yet proceed the way you have told me as its a live database and i need to...

Thanks a lot for the reply

I would like to let you know one more thing that i had not mentioned in my previous posting.This problem had occured after restoring the backup...

Hi ,

I just feel that insert statement what you have given is wrong.The whole of insert statement is considered as a mixture of a variable and a constant so you...

The Blob Datatype cant be imported in DTS

This is what is found in MSDN

The Microsoft ODBC and OLEDB drivers for Oracle support the Oracle 7.3 BLOB data types, not...

Hi Arya,

Thanks for the reply,but unfortunately the problem with on error resume next is it ignores all the errors and will proceed further.

suresh

Hi Rookie,

I dont have the permission to stop the procedure or start the procedure as i am working on the terminals that are setup in canada.Is there any other that...

Hi Rookie,

Do u mean to say that i need to begin with

xp_stopmail

xp_startmail

and later the execute statement that you said

Thanks

Suresh

Hi ,

I tried sending the mail with an attachment and it gave an error xp_sendmail failed with a mail error 0x80004005.

But when i send the mail without an attachment it...

Hi Rookie,

Thanks a lot for your help , i wasnt trying the way you said.Well the help menu of sqlserver is that reliable with no good examples on that.Well i...

Hi Guys,

Thanks for the reply.

I have tried all the ways.Even though i pass the parameter for the attachment the xp_sendmail procedure works well to send the mail,but without any attachement...