Viewing 15 posts - 54,946 through 54,960 (of 59,072 total)
Because the "pipe" character is not one of those "special" characters... \t doesn't mean "use [t] as the delimiter", for example... it means "use a tab as the delimiter". the [|]...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 8:06 am
Ok... thanks! I'll put my soapbox away ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 8:02 am
I'm pretty sure that OpenRowSet wants constants, not caclulations, as it's operands. You'll probably need to shift the whole thing to dynamic SQL.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 7:58 am
Guess we'll need to see the rest... no errors there except can't see where the starting and ending quotes are at the beginning and end of your snippet.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 7:56 am
Thanks...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 7:11 am
Lowell does do a great job, but lemme ask you Cees... have you calculated the header or are you going to manually change it in the code?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 7:06 am
That IS a good article... thanks, Ken.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 7:02 am
Heh... You beat me to it!
And, if you can't afford that kind of schooling for the company, at least read about change management and change control. Use Access or...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 6:57 am
Ummm.... wouldn't a CHECKSUM or BINARY_CHECKSUM at the row level be a little easier?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 6:50 am
And, if you want to make sure it's a table...
IF Object_ID('tempdb..#fred','U') IS NOT NULL
--Jeff Moden
Change is inevitable... Change for the better is not.
September 20, 2007 at 6:36 am
What? You got beer? ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 10:57 pm
Heh... yeah... I've run into this a couple of times my own self... most of the time, I pummeled the vendor until they provided correct data.
When all hope was lost,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 10:56 pm
And, people wonder why I didn't spend the money to go to PASS. S2D2 if you know what I mean ![]()
Sorry it worked out...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 10:51 pm
One of the easiest and fastest ways is to dump the query results into a temp table that has a "line ID" column that is an IDENTITY column... in ACCESS,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 9:28 pm
Or, the OP could post the offending code, sans password, so we can actually try to troubleshoot the command for him ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
September 19, 2007 at 9:17 pm
Viewing 15 posts - 54,946 through 54,960 (of 59,072 total)