Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,006 through 49,020 (of 59,099 total)

RE: How to get Sequential ordering of data based on Ids Passed to IN Keyword

Chris Morris (8/1/2008)
Hi Meeraj, apologies for the delay in replying to you.
Here's a script for creating a Numbers or Tally table, which you will see often on this forum.
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)

August 1, 2008 at 9:55 pm

#852274
RE: EXEC() results to populate cursor

With the advent of VARCHAR(MAX), there's just no need for cursors anymore... for example...
DECLARE @sql VARCHAR(MAX)
SELECT @sql = COALESCE(@SQL+CHAR(10)+' UNION ALL --------------------'+CHAR(10),'')
+REPLACE(
' SELECT '' '' AS...
--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)

August 1, 2008 at 9:46 pm

#852273
RE: Cursor vs. Common Table Expression

KMM (8/1/2008)
I'm using Sql Server 2005
I got the idea of converting my cursor into a CTE from this website:
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/11/common-table-expressions-cte-s-how-it-works-how-recursion-works-using-with-adjacency-list.aspx
Nah... don't bother changing it if you're just going to use recurrsion....
--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)

August 1, 2008 at 9:15 pm

#852271
RE: Not like '%%'

As Ryan suggested, you should consider NOT storing delimited data in a single column...
If it's not something you can control, then Vaseem was on the right track. Even with...
--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)

August 1, 2008 at 9:07 pm

#852270
RE: A question about the Decimal data type

Simple test proves it...
SELECT 1, CAST(1.23 AS DECIMAL(5,2))
SELECT 2, CAST(12.34 AS DECIMAL(5,2))
SELECT 3, CAST(123.45 AS DECIMAL(5,2))
SELECT 4, CAST(1234.56 AS DECIMAL(5,2))
--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)

August 1, 2008 at 8:54 pm

#852268
RE: long running quries

Sure... but the methods are all worse than using profiler... why the profiler phobia?
--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)

August 1, 2008 at 8:40 pm

#852267
RE: DTS - How would I achieve this?

s_chilkury (8/1/2008)
I want this to be resolved using DTS only.
Why?
--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)

August 1, 2008 at 8:19 pm

#852266
RE: large database with millions of querys

gtobee (7/25/2008)
looking to see if anyone is running a 10T MS SQL database.
Why? What's the problem?
--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)

August 1, 2008 at 8:17 pm

#852265
RE: Beat this - comic relief for the day

Heh... c'mon now... {clutching sides in laughter... almost fell out of chair}, that developer is doing the best (s)he can...
Thanks for the Friday laugh...
Steve, you should start a...
--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)

August 1, 2008 at 8:14 pm

#852264
RE: Datatype in CTE

This is why we always ask for a description of what you're trying to do... are you trying to generate 12 otherwise identical rows for each employee or ???
--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)

August 1, 2008 at 8:09 pm

#852263
RE: Stored Procedures Reconsidered

Matt Miller (8/1/2008)
As long as you're not hung up on performance, then cursors must be fine, since they help with readability...hmm no, not really, since they add more useless code...
--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)

August 1, 2008 at 7:51 pm

#852258
RE: Can't debug CLR locally

MichaelC (8/1/2008)
Thanks Jeff! I'll play with these too. I think you also posted some suggestions when I was working with this function a while back, but we thought...
--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)

August 1, 2008 at 7:22 pm

#852257
RE: Can't debug CLR locally

Jonathan Kehayias (8/1/2008)
Hmm, I have to go play with your code now Jeff. I am not surprised that you once again replaced a loop with a Tally/Numbers 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)

August 1, 2008 at 7:19 pm

#852255
RE: Analytical Interview Questions

michael.agarwal (8/1/2008)
Here is another puzzle:
There are 10 stacks of coins. Each stack contains 10 coins. All coins look same. All coins weigh 0.1 lb in 9 stacks but in one...
--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)

August 1, 2008 at 6:28 pm

#852250
RE: Using PATINDEX to find all numeric values

Sean Peters (7/31/2008)
No IsNumeric('11,22,33') = 1
Ummm... nope... it isn't...
SELECT ISNUMERIC('11,22,33')
-----------
0
(1 row(s) affected)
I will agree, though, 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)

August 1, 2008 at 6:21 pm

#852249

Viewing 15 posts - 49,006 through 49,020 (of 59,099 total)