Viewing 15 posts - 54,631 through 54,645 (of 59,067 total)
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
I'd like to know why the hell you have letters in the NPA column. 😉
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.
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...
October 11, 2007 at 8:10 pm
Jack Corbett (10/8/2007)
October 11, 2007 at 7:49 pm
luissantos (10/11/2007)
Sorry, if i send you this post , but i send to you a private message and i know if you will receive them, so i attache...
October 11, 2007 at 7:47 pm
Please see the following for how to resolve this problem...
http://www.sqlservercentral.com/Forums/Topic296166-8-1.aspx#BM296961
October 11, 2007 at 7:41 pm
You've managed, quite nicely, to build a partially exclusive Cartesian Join known as a "double triangle" join. Please see the following post...
http://www.sqlservercentral.com/Forums/Topic359124-338-1.aspx#bm360151
You need some other criteria, hopefully and equi-join,...
October 11, 2007 at 7:29 pm
Hi Greg,
I don't know if Belution is kaput or not... I've seen them go down for several weeks only to rise again. Looks pretty bad this time, though... haven't seen...
October 11, 2007 at 6:09 pm
Well sure it does, Ken... how else are you going to "step through the databases"? sp_ForEachDB??? That's got dynamic SQL and cursors, too!
October 11, 2007 at 6:16 am
Heh... yeah... several solutions similar to that were posted.
The remaining question I have is, what will this be used for? Without knowing were the decimal point WAS... the information...
October 11, 2007 at 6:02 am
... and that was my point... not all Dynamic SQL is bad nor even indesireable.
October 11, 2007 at 5:56 am
Viewing 15 posts - 54,631 through 54,645 (of 59,067 total)