Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Wed Dec 2 13:19:29 CST 2009
John -- Have you tried to use MS SQL database filegroups and partitioned tables & views? http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx With them I suppose only initial import/insert of data have to be parameterized with table name, and the rest can be done without any dynamic T-SQL. Please correct me if I'm wrong. Please note I'm not trying to "force" you to change your current working solution - just wondering is there a legal way to solve your task without dynamic T-SQL... -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, December 02, 2009 9:35 PM To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] C# - Direct data manipulation Shamil, I receive lists of names in CSV or fixed width files. I import those into SQL Server, creating a PKID in the process. I then have to export the PKID plus the name / address monthly for address validation. Once validated, I have to import the data back in. This is the monthly process. Approximately 1% of all the people on any given list move each month. So I have to go back in to the original list and update 1% of the addresses, or simply swap out the new list (table) for the old. There is never any manual processing of individual names inside of these lists, IOW people never look at them, modify them, add new ones, delete address or anything like that. The list is "stable" in that regard. These lists become the source for orders of names. Orders are a whole 'nother process, but also use SPs to do their thing. John W. Colby www.ColbyConsulting.com Shamil Salakhetdinov wrote: > Hi John -- > > Thank you for your reply. > > Do you use your different databases for data input, or you also have to > update those different databases' tables? > > -- > Shamil _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4655 (20091202) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru __________ Information from ESET NOD32 Antivirus, version of virus signature database 4655 (20091202) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru