I always try to start with Books Online... if you check the index for "cross-tab reports", you'll come up with a pretty decent explanation and some examples.

Oh bother... all of us missed it ... see anything out of place here, folks???

alter PROCEDURE INSERTTEST2 ( @FILEPATH NVARCHAR(50))

AS

DECLARE @cmd...

Oh no... wasn't referring to your post... I understood what you meant and I think the OP did, too.  I think the OP thought Remi might have been a little...

Ali,

What is the record format for the flat-file you are trying to import?

Apolgies for my buds... they're of the same ilk as I... we come here because it's usually a safe place to go without much advertising and virtually no spam.  And,...

Oh yeah... almost forgot... if the file extension is "CSV", you may be able to import the data directly using the methods shown without ever going through Excel provided that...

Ok... I've got the simple fix... you have to change the way you are exporting the data.  Because all of the data is in a single column and it contains...

Heh... I made a spreadsheet with all of the data in one column and exported it as a TEXT (OS/2 or MS-DOS) file, and lo-and-behold!  Guess what I got?

Ah... now I understand... lemme see what I can do...

By the way... what is the "extension" used on the filenames you are receiving???

Sure... I always start with Books Online and go from there... lookup "indexes, designing" in Books Online to start with...

You're welcome, but we sure would like to know what you want done if the entry contains all zeros

Just for giggles, I'd still like to know what the SN columns are for... what are they?

Crud, you're right, my bad...Thanks, Michaeal.   Except should be this because, as you said, Peter's algo returns +/- 5...

UPDATE ValueDetails

    SET AVM = AVMValue * (1+(ABS(CHECKSUM(NEWID()))%11-5)*.01)

I'm thinking that I'd follow Mark's suggestion about staying away from BCP and xp_CmdShell for a Web app... too many complications... too many security risks.

I'd be tempted to write something...

Thanks for the great feedback Georgio and Carlos.

Do look at Serqiy's post, again... as he says, these types of tables provide for some great flexibility, but at a potentially serious...