Heh... I'd like to know why a "user" is allowed to create anything in a database, especially views.   Improperly written views can bog...

Ummm... could you use a trigger in such a case?  Or would the trigger hang until the job was complete?  Asking 'cause I don't know much about 2k5... stuck in...

Duplicate post...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=383148

Ali,

When you say "flat file", do you mean all of the rows have a "fixed field length"? 

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