Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,766 through 42,780 (of 59,067 total)

RE: bridge table

That's just soooooo freakin' rude, dudes.
--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)

July 23, 2009 at 7:16 pm

#1029405
RE: how to write a function that executes Sub- Store procedure

. (7/23/2009)
Also, just in case you are tempted to explain why it HAS to be a function and not a stored proc. Please, don't bother. I have had...
--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)

July 23, 2009 at 7:08 pm

#1029403
RE: Null value in table

Duplicate post also answered at the following...
http://www.sqlservercentral.com/Forums/Topic758447-9-1.aspx#bm758462
--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)

July 23, 2009 at 7:03 pm

#1029401
RE: if qty_requested =8 then display the information 8 times.

Lamprey has the right idea with the Tally table.
--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)

July 23, 2009 at 6:41 pm

#1029396
RE: Existance Check - Performance

It sounds like you have the data to do a test... why not just test it and see?
"A Developer must not guess... a Developer must KNOW." 😉
--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)

July 23, 2009 at 6:27 pm

#1029394
RE: Index Fragmentation...

sqlbuddy123 (7/23/2009)
Hi,
For your information only
Microsoft discourages the use of DBCC SHOWCONTIG . This is the official statement from the Microsoft in BOL 2008
"This feature will be removed in the next...
--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)

July 23, 2009 at 5:40 pm

#1029383
RE: differiniate quotes as data vs quotes as column identifier

Ah crud... ya just gotta love stuff like this. The error message you posted indicates that you're running a 64 bit machine... and JET isn't supported on 64 bit...
--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)

July 23, 2009 at 5:30 pm

#1029382
RE: DBA's and Developers

doug.williams (7/23/2009)
While I understand (first hand) the practice of blaming others.
If we as Professionals do not assume the Responsibility of and Accountability for our actions, then we should not...
--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)

July 23, 2009 at 4:59 pm

#1029366
RE: Problem with Query

Short and sweet... just gotta love ROW_NUMBER(). 😛
DECLARE @PartNoToFind INT
SET @PartNoToFind = 1

;WITH
cteGroup AS
(
SELECT ROW_NUMBER() OVER (ORDER BY Sno)
...
--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)

July 23, 2009 at 3:17 pm

#1029309
RE: Are the posted questions getting worse?

Heh... if you're really interested in books on zombies, pick up a couple of books on project management. 😛
--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)

July 23, 2009 at 1:43 pm

#1029252
RE: sql query

TAman (7/23/2009)
Can anyone send me code that would get me my expected result above based on the data below?
Heh... oh yeah... someone will post code that will solve 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)

July 23, 2009 at 1:41 pm

#1029249
RE: Are the posted questions getting worse?

Grant Fritchey (7/23/2009)
Another completely off-topic post.
My 11 year old is starting to discover books (YAY! Finally). He just tore through Zelazny's "Damnation Alley." I need more in this vein. Any...
--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)

July 23, 2009 at 1:27 pm

#1029237
RE: Are the posted questions getting worse?

RBarryYoung (7/23/2009)
You could 1) drink too much
Heh... NOT possible... 😛
--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)

July 23, 2009 at 1:23 pm

#1029234
RE: Are the posted questions getting worse?

GilaMonster (7/23/2009)
They believe that free houses, electricity and water are their right.
Heh... future project managers? 😛
--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)

July 23, 2009 at 1:19 pm

#1029232
RE: Problem with Query

This is a fairly complex problem for those that don't know how to solve it and I wouldn't be surprised if no one on Chandra's side of the house tried...
--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)

July 23, 2009 at 1:10 pm

#1029226

Viewing 15 posts - 42,766 through 42,780 (of 59,067 total)