Ok... this is even easier than BCP...

Initial setup...

--===== Create a linked server to the drive and path you desire.

EXEC dbo.sp_AddLinkedServer TxtSvr,

...

If he cut us off, it's because he's already an "adult"... not sure I'd waste time on a PM... remember what I said...

most adults have already lost theirs so not...

My apologies... I just tried ALTER COLUMN on a computed column and it doesn't work. You'll get an "Incorrect syntax near the keyword 'AS'." You will need to...

... not sure it's a good idea to put hardcoded dates in a computed column, either. Not 100% sure what to replace it with but this might be a...

I haven't tried it on a computed column, but I think you should be able to do an ALTER TABLE/ALTER COLUMN...

kaiitong (3/18/2008)

---

Did this topic ask for another of my perspective? No

Do I look like want your concern? NOPE

Did you come to answer my question? No

Why this topic's still active since...

I absolutely agree...

LOL... Sorry, Matt... I just had this thought of you hanging another bag of coffee... I'm on my third one... 5 gallon bags, mind you... 😛

Andrew_Webster (3/18/2008)

---

Top tip for working with the INFORMATION_SCHEMA views: use Excel to view them.

In Excel, go to Data, Import External Data..., then either Import Data or New Database...

Yep... I gotta agree with that.

Thanks, Sergei.

I already did suggest a solution... lookup Crosstab in BOL and convert it to dynamic SQL.

Hi Tony... still not 100% clear on what the data file actually looks like... can it have more than on person in it and, if it does, will it look...

You bet... thank you for the feedback. If you want to learn more, take a look at Todd's code. It's a good example of what the...

Heh... you must be having a bad day... No? I guarantee you...