Viewing 15 posts - 54,646 through 54,660 (of 59,089 total)
You don't? :blink: There's an example of what the input file looks like, what the table looks like, what the BCP format file looks like, and what the...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2007 at 5:48 pm
See attachment... 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2007 at 8:17 am
Yeah... that's it...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2007 at 8:00 am
Yeck!
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2007 at 7:47 am
No, no.... the overhead of a cursor is not required here. Take my previous suggestion and find out how to build a recursive CTE to resolve these types of...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2007 at 7:34 am
Jeff Moden (10/11/2007)
Looks like any decent HTML editor or a Word macro to change spaces to the literal " " (without the quotes) will do the trick.
Sorry folks... I didn't check...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2007 at 7:29 am
Heh... thanks, Marcus. Most folks keep that type of info in two separate columns...
So, are you all set or do you still need help?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2007 at 7:25 am
Looks like any decent HTML editor or a Word macro to change spaces to the literal " " (without the quotes) will do the trick.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 11, 2007 at 9:34 pm
Just a test... please ignore...
FIGURE 1: Tally Table Code
[font="Courier New"]
drop table tally
--===== Create and populate the Tally table on the fly
 SELECT TOP 11000 --equates to more than 30 years of dates
        IDENTITY(INT,1,1) AS N
   INTO dbo.Tally
   FROM Master.dbo.SysColumns sc1,
        Master.dbo.SysColumns sc2
--===== Add a Primary Key to maximize performance
  ALTER TABLE dbo.Tally
    ADD CONSTRAINT PK_Tally_N 
        PRIMARY KEY CLUSTERED (N) WITH FILLFACTOR = 100
--===== Allow the general public to use it
  GRANT SELECT ON dbo.Tally TO PUBLIC[/font]
Test complete... regard all further alarms 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
October 11, 2007 at 9:05 pm
Just doing some formatting tests... please ignore the following post...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 11, 2007 at 9:03 pm
Heh... what'cha gonna use it for? Forget about using it for batch programming... better be RBAR GUI code only (RBAR is pronounced "ree-bar" and is a "Modenism" for "Row...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 11, 2007 at 8:41 pm
I'd like to know why the hell you have letters in the NPA column. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 11, 2007 at 8:34 pm
Search for "hierarchy" on this forum... also lookup "expanding hierarchies" in Books Online. Because you're using 2k5, you may want to add "CTE" to your search criteria.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 11, 2007 at 8:26 pm
Title of this thread is "I just want to do my job!".
Have you figured out what "your job" is, yet? I think you would become bored if you just...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 11, 2007 at 8:10 pm
Jack Corbett (10/8/2007)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 11, 2007 at 7:49 pm
Viewing 15 posts - 54,646 through 54,660 (of 59,089 total)