Please Provide me suitable solution

Question

Post reply

Please Provide me suitable solution

anand1310g

SSC Rookie

Points: 30
More actions
June 12, 2012 at 12:26 am

#262270

Clean the table from old values
- Get the new values in with format utf-8 from the .flat-files
- In case we have multiple loads
- Append the additional regions without cleaning the table

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Stupeo Hall of Fame Points: 3067 More actions · Answer 1

You need to give us more info than that - please post your table structure and some example data?

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 2

For these kinds of highly detailed specifications, my hourly rate is $300.00/hr (USD) open ended.

Converting oxygen into carbon dioxide, since 1955.

ACinAZ SSCommitted Points: 1849 More actions · Answer 3

ACinAZ

SSCommitted

Points: 1849

June 13, 2012 at 8:41 am

#1500414

This'll wind up on the "watercooler" thread...

Cadavre SSC-Forever Points: 41690 More actions · Answer 4

anand1310g (6/12/2012)
Clean the table from old values
- Get the new values in with format utf-8 from the .flat-files
- In case we have multiple loads
- Append the additional regions without cleaning the table

Please read this article to see where you went wrong.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

ganeshnarim SSC Eights! Points: 834 More actions · Answer 5

anand1310g (6/12/2012)
Clean the table from old values
- Get the new values in with format utf-8 from the .flat-files
- In case we have multiple loads
- Append the additional regions without cleaning the table

Clean the table from old values ----Use DELETE FROM 'Your table Name'

Get the new values in with format utf-8 from the .flat-files---- Use SELECT CAST (EX:SELECT CAST('000' AS NVARCHAR(10)) AS [record code].

In case you have multiple loads

Don't use----"DELETE FROM 'Your table Name".

Thanks

anand1310g SSC Rookie Points: 30 More actions · Answer 6

you just need to assure that everything you are currently doing manually via the import tool will be handled by a procedure which can be somehow executed. You can use those stpes for your design. Mainly it is:

- Clean the table from old values

- Get the new values in with format utf-8 from the .flat-files

- In case we have multiple loads (e.g. FR)

o Append the additional regions without cleaning the table (e.g. MC and AD)