Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,486 through 40,500 (of 59,098 total)

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
RE: March 13, 2010: PSSUG SQL Camp, pre-Call For Speakers

RBarryYoung (12/25/2009)
OK, here it is...
To register for the Philadelphia SQL Saturday Event go HERE.
To apply as a Speaker and enter a Proposed Session go HERE.
And to 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)

December 25, 2009 at 10:52 am

#1096478
RE: Compare documents in folder to items in a table

TheSQLGuru (12/25/2009)
Jeff Moden (12/24/2009)
TheSQLGuru (12/24/2009)
Hmm - just thought that perhaps it could be dumped into a table with an identity and then rely on that for ordering.
Exactly. And, if...
--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:41 am

#1096474
RE: Incrementing Values

RBarryYoung (12/25/2009)
Heh, I was wondering if your were going to mention that way around cross-joins. ... I used methods like this for months when I was learning SQL, before...
--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:32 am

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

Solomon Rutzky (12/25/2009)
Hey Jeff. As I mentioned in a reply to one of Matt's posts, I basically solved this problem, in a general sense, using a CLR Stored Proc...
--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:31 am

#1096467

Viewing 15 posts - 40,486 through 40,500 (of 59,098 total)