Where Did Brett's Sticky Go?

Jan 13, 2006

I found that an incredibly helpful place to vague posters too? Must be the new sherrif.

View 3 Replies

What Happened To The Sticky?

Oct 11, 2005

Hey, who took the sticky down?

View 2 Replies View Related

Special Thancks To Brett, Blindman And All The Others !

Jun 18, 2004

Just a few words to thanck some of the people
who connect each days to help others solve their problems.

I've finished migrating my programs to SQL Server
and it's been quite easier and quicker than I first tought
mainly because there are some
competent-intelligent-helpful-(funny) members on this forum.

So thank you all, thank you BK and BM

Caroline from France

View 10 Replies View Related

Output To .txt - Linesize, Pagesize Qs (Brett?)

Apr 25, 2007

Last year user X002548 assisted output to txt file

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68461&SearchTerms=create,file

where he used a BCP shell script to pass outfile specs.

I'm using SQL query writer ODBCview and would like to view the data before loading it into a file, but I'm getting a ?crunch? error.

In other languages you can :

set linesize X (518, in my case)
set space 0
set newpage 0
set pagesize 0
set heading off etc for a clean flat file load.

I'm getting errors using the set command; I think it may be a SQL/Plus function, not native to SQL.

Are there similar functions for setting page specs? Thank you guys so
very much. I'm a noob (4 days old at this now!) and am in awe of the support you provide.

Lisa

View 5 Replies View Related

Comment Thread For This Forum's Hint Sticky

Sep 27, 2005

My God! What happens if I miss a step, or put it in a different order??? I know I can specify ORDER BY StepID, but what about a missing step? I do have "missing ranges" script, but posting questions filtered through the script process may become a full-time job in itself...What to do, what to do...

View 14 Replies View Related