Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,456 through 40,470 (of 59,072 total)

RE: Counter Table (table of numbers) Setter-Upper for SQL Server 2005

I guess I just don't understand why you needed While Loops to do this.
--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)

December 26, 2009 at 11:29 am

#1096533
RE: Running total , missing date , NULL in amount, exception handling

karthikeyan-444867 (12/26/2009)
Any inputs?
Not a one, Karthik... at least not the kind you're expecting. You've simply asked people to do too much of your work, your requirements are quite unclear...
--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)

December 26, 2009 at 9:40 am

#1096531
RE: Convert String to a Table using CTE

Yeah... but confirmation of those things is always a good thing. 😛
--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)

December 26, 2009 at 1:09 am

#1096512
RE: March 13, 2010: PSSUG SQL Camp, pre-Call For Speakers

Matt Miller (#4) (12/25/2009)
Jeff - try this one....
PSSUG call for speakers for march 2010
Thanks, Matt... guess I was being a bit lazy there.
--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)

December 25, 2009 at 9:22 pm

#1096507
RE: split function in SSRS

satishthota (4/22/2008)
Give me the solution
I don't know... maybe it's just me or maybe it's just a language barrier thing but that seems awfully rude in any language.
--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)

December 25, 2009 at 9:18 pm

#1096506
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

Solomon Rutzky (12/25/2009)
Hey Jeff, actually, the RegEx delimiter is needed (as far as I can tell) in order to do true CSV / TSV parsing.
That's what I'm talking about... You...
--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)

December 25, 2009 at 9:16 pm

#1096505
RE: Convert String to a Table using CTE

Ulises Telcontar (12/25/2009)
MAXRECURSION cannot be used on UDFs.
I beg to differ...
CREATE FUNCTION dbo.MaxRecursionTest ()
RETURNS INT
AS
BEGIN
DECLARE @Return INT
SELECT TOP 1...
--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)

December 25, 2009 at 9:08 pm

#1096504
RE: How to suspend replication ?

With the understanding that it will suspend all jobs, you could simply turn of the SQL Server Agent until you're done.
--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)

December 25, 2009 at 12:27 pm

#1096488
RE: Question of the Day for 21 Dec 2009

CirquedeSQLeil (12/22/2009)
I knew somebody would do this.
Thanks Jeff
Heh... you just had to know it was going to be me. 🙂 Thanks for the fun, Jason. Good QoD.
--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)

December 25, 2009 at 12:26 pm

#1096487
RE: Comparing Dates

BSavoie (12/24/2009)
What is the optimal method to filter dates in a where clause if you want to ignore the time portion?
This works fine:
WHERE DateAdd(day, SomeDateColumn, SomeTestDate) >...
--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)

December 25, 2009 at 11:41 am

#1096486
RE: Need query

Prakash,
Did that do it for you or what?
--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)

December 25, 2009 at 11:29 am

#1096484
RE: Need query

cthariharan (12/24/2009)
Please share the table structure & some of the datas stored in it. So that others can help u.
cthariharan,
Good tip there but a lot of people just don't 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)

December 25, 2009 at 11:27 am

#1096483
RE: Need query

Dugi (12/24/2009)
ss-457805 (12/24/2009)
Jeff,
This is awesome. You are a Genius.:-)
I agree with you ... if you SELECT NAME FROM T-SQL_MASTERS WHERE NAME LIKE 'J%' you will retrieve the only result Jeff...
--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)

December 25, 2009 at 11:22 am

#1096482
RE: Display the record in column wise

Ok... here's a demonstrable solution based on the data given. As a side bar, please see the following URL for how to do such a thing and why the...
--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)

December 25, 2009 at 11:15 am

#1096481
RE: Display the record in column wise

rameshduraikannu,
Since you're a newbie, take a look at the first link in my signature line below... you will get MUCH better answers MUCH more quickly if you post both the...
--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)

December 25, 2009 at 10:55 am

#1096480

Viewing 15 posts - 40,456 through 40,470 (of 59,072 total)