Click here to Skip to main content
15,032,063 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to Insert Data in my Transaction but the Condition is that
1)There are dealers whose data is insteted for the particular month by TSI(Territory Sale Incharge)in Transaction table(SaleEntry Table) i am providing one Sale Entry Form (In Grid View(Dev Expres Grid)) now i entered the data for Aprial To November month

2)IF TSI Want to entered the data for past month like in the december entered data for May Or June for that i have to inserted 0(Zero) for all product to all past month if the dealer is not availabe in Transaction Table

3) The are 85000 dealer For them i want to inserted data Dealer Tabele is different(MDealer) and Transction Table is(MTmpSale)

4)If Dealer created in May Then Its not available for April Entry and so on i am checking this creation on dealer created coloumn in Mdealer Table(Dealer Master)

Can any body help me for this, This is one time Inseration in Transaction table From Apr To Nov When i find on net many say for this purpose use DTS Package of SQL SERVER 2005

i don't have idea how o create it any body help meplz. its urgent
Posted
Comments
fjdiewornncalwe 8-Jan-11 13:17pm
   
Please don't bother mentioning that "it's urgent". That has no relevance to us, only you. In fact, many of the people who will provide you with the best answers will simply ignore your questions if they include a statement like that. Cheers.

1 solution

If it is a one time process, just write a sql script and execute that. Anything you can do in a DTS you can do in a standalone script. The only purpose of the DTS package at that point is that it can be scheduled for multiple runs, which in the case makes it redundant.
   
Comments
Espen Harlinn 16-Jan-11 9:22am
   
5+ To the point - keep it simple :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900