Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: 8 Ways to Export SQL Results To a Text File

    Thanks very much for a great article. Some of the methods I knew, but others were an education for me. Appreciate your time and efforts!

  • RE: Can I do this?

    Sergiy,

    I did read Luis' post and incorporated it in an even more graceful and shorter solution that best suited my need.

    In the future, maybe you ought to question what you...

  • RE: Can I do this?

    Well said, and understood - all good point. And yes, the solution I found actually came from a number of members, yourself included.

    Thanks for that!

  • RE: Can I do this?

    Point taken, and most of the time, good advice. Thanks for offering it!

  • RE: Can I do this?

    Jeff - Look at the fourth and sixth small paragraph of my original post. I did exactly what you are suggesting I did not do. I asked to...

  • RE: Can I do this?

    Alex,

    Here is the basic code I used. This produces a nice temp table of information and of course, you can edit the query if you don't want all the...

  • RE: Can I do this?

    Hanshi,

    Thanks for your reply, but unfortunately its way over-complex. I found a way to do this that is simple and elegant.

    1. Run SP_COLUMNS and direct output to a Temp...

  • RE: Can I do this?

    Luis,

    No - it was not a problem - I saw what you were doing but it wasn't quite what I was after (my fault, not yours).

  • RE: Can I do this?

    I Brandie,

    Let me try to provide you some answers...

    We use SSIS when its truly needed, but sometimes we actually use old DTS, or even just an ASCII dump directly into...

  • RE: Can I do this?

    My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very simple...

  • RE: Can I do this?

    My thanks to all who responded, but please, in the future, read the question - I DID NOT say "Users are entering data", what I said was "We get tables"...

  • RE: Summarizing COUNTs - Flumoxed by getting my SQL right...

    Thanks Drew... That worked swimmingly!!!

Viewing 12 posts - 1 through 12 (of 12 total)