Viewing 15 posts - 54,631 through 54,645 (of 59,078 total)
That nice little cross-join you included as a derived table sure did the trick.
October 12, 2007 at 6:51 pm
Now, that's what I'm talking about! Nice job, Kirk!! And, thanks for posting your solution! 😀
October 12, 2007 at 6:03 pm
No, no... Unless I'm totally misreading this, a good ol' fashioned partitioned view will do all of that without the overhead of triggers and the extra table. It'll be...
October 12, 2007 at 5:51 pm
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...
October 12, 2007 at 5:48 pm
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...
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...
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?
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.
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 😀
October 11, 2007 at 9:05 pm
Just doing some formatting tests... please ignore the following post...
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...
October 11, 2007 at 8:41 pm
Viewing 15 posts - 54,631 through 54,645 (of 59,078 total)