Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,521 through 44,535 (of 59,101 total)

RE: updating CLR UDFs / Procedures strategy: contributions needed.

I'd have to ask what you're doing with CLR's that you think you can't do in T-SQL.
--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)

March 20, 2009 at 8:43 pm

#963902
RE: How to write codes that display sub-colum names under main column header name

josephptran2002 (3/20/2009)
Please please please email me at josephptran2002@hotmail.com So I can explain to you on the regular mail.
Nah... keep it all here so we might all learn something, please.
--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)

March 20, 2009 at 8:40 pm

#963900
RE: is possible thro a single query

ramu.valleti (3/20/2009)
what do you mean by "single query".?
You can use sub queries to achieve this.
Regards,
Ramu
Cool... let's see it, Ramu.
--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)

March 20, 2009 at 8:36 pm

#963899
RE: how to break phone and exension data

Ok... again... here's the test data...
drop table #OriginalTable
go
SELECT '913.135.9000 x:6390' AS FullPhoneNumber
INTO #OriginalTable UNION ALL
SELECT '(305)529-6911x2101' UNION ALL
SELECT '(206)965-2626' UNION ALL
SELECT '109.391.3261' UNION...
--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)

March 20, 2009 at 8:33 pm

#963898
RE: how to break phone and exension data

Nope... bad move on my part... it's going to have to be a function because there's no guarantee that you won't have duplicate phone numbers after the split and 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)

March 20, 2009 at 7:55 pm

#963895
RE: how to break phone and exension data

Ok Shamshad... you've got almost 400 points to your name. That means you've been around long enough to know how to post data for sample data to make it...
--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)

March 20, 2009 at 7:47 pm

#963893
RE: how to break phone and exension data

Lowell (3/20/2009)
ok i think i'm wrong about area codes between 100 and 199(starting with 1), so you might want to remove the logic i put in place to assume starting...
--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)

March 20, 2009 at 7:30 pm

#963890
RE: Hanged on some of the querries do help......

""Sameer"" (3/20/2009)
Hi,
How to querry a table that will give output like
1.Atleast one from this and atleast one from other.....
eg.1.Find the name of each student who has taken...
--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)

March 20, 2009 at 6:06 pm

#963872
RE: serial no

SELECT ROW_NUMBER() OVER (ORDER BY CustomerID) AS SerialNo,
CustomerId,
CustomerName
FROM dbo.CustMaster
But,...
--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)

March 20, 2009 at 5:59 pm

#963870
RE: Numbers table and a join

Also, there is no need for the highlighted section of the following line of code...
ON id BETWEEN 0 AND [highlight]ISNULL([/highlight]@Counter[highlight],0)[/highlight]
--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)

March 20, 2009 at 5:54 pm

#963868
RE: Hex to Decmial Conversion

So, how did you manage to prepend the '0x' to the character data to get it to work correctly?
--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)

March 20, 2009 at 5:41 pm

#963864
RE: Combining result sets into a single one.

Any chance of listing the code for EXEC usp_Cash_Trans_pct? I wanna see what's in it that requires the RBAR associated with processing just one sales date at a time.
--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)

March 20, 2009 at 5:39 pm

#963863
RE: T-Sql rant

Lynn Pettis (3/20/2009)
Jeff Moden (3/20/2009)
Lynn Pettis (3/20/2009)
Jeff Moden (3/20/2009)
Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like 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)

March 20, 2009 at 5:28 pm

#963861
RE: T-Sql rant

Michael Valentine Jones (3/20/2009)
Not that I would ever recommend using this to get the next ID for anything I was designing, but when someone has already put something like 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)

March 20, 2009 at 5:27 pm

#963860
RE: Are the posted questions getting worse?

Lynn Pettis (3/20/2009)
Jeff Moden (3/20/2009)
Derek Dongray (3/20/2009)
It looks like The Rant has run its course.
And from his description of his setup (sync software + 3 application tools + 5 databases),...
--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)

March 20, 2009 at 4:10 pm

#963840

Viewing 15 posts - 44,521 through 44,535 (of 59,101 total)