Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
8
Newest
 Editor
Impact
~427 people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Feb
2
comment Insert custom header row in BCP output
Weird I removed the header file and recreated it and now it works...
Feb
2
comment Insert custom header row in BCP output
I went to try this today and now im getting jibberish again! :(
Jan
29
comment Updating a view on multiple joined tables
Side question, couldnt you have wrapped this inside of a transaction and rollback if what happened didn't meet your needs?
Jan
29
comment Updating a view on multiple joined tables
Instead of linking to your blog, can you at least post the relevant snippets here. Blogs tend to disappear and reappear during ones lifetime.
Jan
23
comment How to hide rows in SSRS report?
@Lijo look at the bottom window that lists the row and column groups.
Jan
12
comment Insert custom header row in BCP output
Thanks for your hard work and dedication in helping me solve this problem.
Jan
12
accepted Insert custom header row in BCP output
Jan
11
revised Insert custom header row in BCP output
edited tags
Jan
11
comment Insert custom header row in BCP output
Let us continue this discussion in chat.
Jan
11
comment Insert custom header row in BCP output
Would it help to post all my queries or maybe we should take this to chat?
Jan
11
comment Insert custom header row in BCP output
No simply varchar fields. Again this exports fine if I go back to what I have.
Jan
11
comment Insert custom header row in BCP output
It runs but I get strange gibberish in the file (the filename file). Most is unreadable it appears chinese characters.
Jan
11
comment Insert custom header row in BCP output
So AddHeaderToExportFile.cmd can you clearly mark that one, which one of your code snippets become that? (Assuming first)?
Jan
11
comment Insert custom header row in BCP output
Ya maybe you can show how to call this because I'm a bit confused with this %Temp%\TempHeader.txt. The issue is I need the filename to match what I had posted previously. If you can show how that is done that may help me.
Jan
11
comment Insert custom header row in BCP output
Hmm...But what about my @FileName etc. Is it possible you can incorporate what I already have into this? Or should I not bother with that?
Jan
11
comment Insert custom header row in BCP output
This requires some sort of external process or job or batch to do this, I want to avoid that.
Jan
11
comment Insert custom header row in BCP output
That would be awesome thank you!
Jan
11
comment Insert custom header row in BCP output
@srutzky - static SELECT '100' AS [Transaction Type], --1 '0' AS [Error Threshold], --2 'SSO' AS [Password Generation], --3 'UPDATE' AS [Existing Record Handling], --4 'EN' AS [Language Code], --5 'N' AS [Validate Expense Group], --6 'N' AS [Validate Payment Group], --7
Jan
11
comment Insert custom header row in BCP output
@JohnM - I've edited the title - you are right that one does sound better.
Jan
11
revised Insert custom header row in BCP output
edited title