Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,661 through 54,675 (of 59,098 total)

RE: problem with query...

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 12, 2007 at 7:25 am

#741541
RE: complex select problem w history tables, date ranges

Looks like any decent HTML editor or a Word macro to change spaces to the literal "&nbsp" (without the quotes) will do the trick.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 9:34 pm

#741435
RE: complex select problem w history tables, date ranges

Just a test... please ignore...
FIGURE 1: Tally Table Code
[font="Courier New"]
drop&nbsptable&nbsptally
--=====&nbspCreate&nbspand&nbsppopulate&nbspthe&nbspTally&nbsptable&nbspon&nbspthe&nbspfly
&nbspSELECT&nbspTOP&nbsp11000&nbsp--equates&nbspto&nbspmore&nbspthan&nbsp30&nbspyears&nbspof&nbspdates
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspIDENTITY(INT,1,1)&nbspAS&nbspN
&nbsp&nbsp&nbspINTO&nbspdbo.Tally
&nbsp&nbsp&nbspFROM&nbspMaster.dbo.SysColumns&nbspsc1,
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspMaster.dbo.SysColumns&nbspsc2
--=====&nbspAdd&nbspa&nbspPrimary&nbspKey&nbspto&nbspmaximize&nbspperformance
&nbsp&nbspALTER&nbspTABLE&nbspdbo.Tally
&nbsp&nbsp&nbsp&nbspADD&nbspCONSTRAINT&nbspPK_Tally_N&nbsp
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbspPRIMARY&nbspKEY&nbspCLUSTERED&nbsp(N)&nbspWITH&nbspFILLFACTOR&nbsp=&nbsp100
--=====&nbspAllow&nbspthe&nbspgeneral&nbsppublic&nbspto&nbspuse&nbspit
&nbsp&nbspGRANT&nbspSELECT&nbspON&nbspdbo.Tally&nbspTO&nbspPUBLIC[/font]
Test complete... regard all further alarms 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 9:05 pm

#741434
RE: complex select problem w history tables, date ranges

Just doing some formatting tests... please ignore the following post...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 9:03 pm

#741433
RE: Dates Stored Procedure

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 8:41 pm

#741430
RE: problem with query...

I'd like to know why the hell you have letters in the NPA column. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 8:34 pm

#741429
RE: Converting a FoxPro Procedure to SQL

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 8:26 pm

#741428
RE: I just want to do my job !

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 8:10 pm

#741426
RE: is this a good trigger?

Jack Corbett (10/8/2007)
It looks good to me also. I'm surprised we haven't seen a post in this thread about how no trigger is a good trigger:D. Not that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 7:49 pm

#741424
RE: TSQL query run very slower

luissantos (10/11/2007)
Hello again Matt
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 7:47 pm

#741423
RE: BCP Utility for Data Copy

Please see the following for how to resolve this problem...
http://www.sqlservercentral.com/Forums/Topic296166-8-1.aspx#BM296961
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 7:41 pm

#741422
RE: How can I make this faster?

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,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 7:29 pm

#741421
RE: Filling in numbers

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 6:09 pm

#741411
RE: The USE command

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!
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 6:16 am

#741151
RE: Remove Decimals Without Rounding

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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

October 11, 2007 at 6:02 am

#741145

Viewing 15 posts - 54,661 through 54,675 (of 59,098 total)