[font="Verdana"]Do one thing, first comment all the mail shooting sp's which are working fine except the faulty sp and try to dig around it.

Also let us know, can't you...

[font="Verdana"]Instead of merging the duplicates, you need to remove it. You need to do this work around for the other dependent objects as well which are dependent on Customer's table....

[font="Verdana"]create procedure xxxxxxxxxx

begin

exec ril_pandl_stock_dtls 'abc',@fin_year,@fin_prdcode

end

If this is not the complete SProc code then please provide. Or check whether you have declared atleast @fin_year, @fin_prdcode variables.

Thanks,

Mahesh[/font]

[font="Verdana"]

Right now table B has a number of 987..but in the source table A it was changed to 123. Since table B is the final table I want to...

[font="Verdana"]this article might help you bit.

http://www.oracle.com/technology/obe/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm

--Mahesh

[/font]

[font="Verdana"]Thanks Kiran, for your valuable comments.

--Mahesh[/font]

[font="Verdana"]

Go through the below articles to explore more on SSIS.

SQL Server Integration Services an Introduction - Part 1

http://www.sql-server-performance.com/articles/biz/SSIS_Introduction_Part1_p1.aspx

SQL Server Integration Services Features And Properties Part 1

http://www.sql-server-performance.com/articles/biz/SSIS_Features_And_Properties_Part1_p1.aspx

SSIS - An Inside View...

[font="Verdana"]Initially add Index to the existing table and try to execute the SLOW query and if still that query is taking much time then post query with table structure.

--Mahesh[/font]

[font="Verdana"]NULL is nothing but the placeholder.

--Mahesh[/font]

[font="Verdana"]more information u ll get here on waht Dixon has suggested.

http://msdn.microsoft.com/en-us/library/ms140117.aspx

--Mahesh

[/font]

[font="Verdana"]

try this

Selectid

,USD = (Case When Curre = 'usd' Then Rate Else 0 End)

,INR = (Case When Curre...

[font="Verdana"]Refer BOL for more information

Mahesh[/font]

[font="Verdana"]I am not sure how much this article will help you solving your problem. But it is kind of similar to your approch.

http://www.sqlservercentral.com/articles/SSIS/67871/

Let us know on this,

Mahesh[/font]

[font="Verdana"]

@@tblRules table remove the extra @. and let us know.

Mahesh[/font]

[font="Verdana"]Hi Greg,

I had implemented the solution, attached herewith. Now the big problem is we have Service Pack 1 for Windows 2003 Server and SQL Server 2000 on all the servers....