Running the T-SQL you gave, I got 2 columns entitled ST and SR_RID

under ST there seems to be a mix of cities combined with the standard 2 letter postal abbrev...

Thanks Praveen,

let me ask you....

Can you give me a little direction on the restore. Typically, we first have a database created/defined before we can 'restore' to it, right?

Do I...

Thanks Ed,

I will dig into this bright and early tomorrow am, and I mean BRIGHT and EARLY,

thanks agin,

Spatio

Ahhhh McGoo! You've done it again!

I had tried 'View/Refresh'. Obviously that's not the same,

thx agin

f

Yes, there's a deeper issue that further shows my ignorance....

I have a method being performed on text-rows, and one of the rows has some sort of curruption in the text-format,...

Thanks for all the tips gang!

Atleast I have a clue now,

Frank

My problem is that the flat file doesn't appear to have any "standard format", for example: see below.

I want the output table to be 4 columns: X,Y, Record #, Point...

got it finally,

Pulled Up Tablet View (Management Studio displays), right-clicked and clicked option 'open in folder', then I was able to see the program in a folder (which was...

oh wait again,

Management Studio icon still not on the Desktop,

I thought I had it but only have configuration shortcut,

???

ok gee,

i checked out the 'Config Tools' folder on my desktop, and that displayed the relevant shortcuts for the desktop:-)

thanks for pointing out that folder!

f

thx Durai,

unfortunately I am on Win 8, and I don't have a Start button and the Desktop Explorer shows Sql Server was installed in a Folder 'Microsoft SQL Server'...

thx everyone:-)

f

Thanks Jeffrey!

f

thx!