Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,246 through 43,260 (of 59,098 total)

RE: printing 1 to 100 in SQL Server as a batch....

Sinshith S Anand (6/26/2009)
Hi friends,
I am really happy to see Lots of ideas....You can visit my blog also
http://sinshith.wordpress.com/
And let me know your comments...I started writing blog recently
I'd recommend...
--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)

June 26, 2009 at 10:08 am

#1016163
RE: Are the posted questions getting worse?

Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Lynn Pettis (6/25/2009)
I only hope he reads the blog, but I doubt it.
I hope (s)he did. Next posts have been really okay.
Heh... I'm 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)

June 26, 2009 at 9:51 am

#1016144
RE: printing 1 to 100 in SQL Server as a batch....

Sinshith S Anand (6/25/2009)
Still many methods are there.....Please contribute your ideas
Ummmmm... WHY? You writing a book or what?
See ya...
--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)

June 26, 2009 at 6:24 am

#1015957
RE: Slack SQL Server

Heh... not to worry, Tom. We've all gotten versions and products confused at one time or another. Thanks for the feedback.
The underlying problem still remains though - cross...
--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)

June 26, 2009 at 6:17 am

#1015950
RE: Are the posted questions getting worse?

Florian Reischl (6/26/2009)
Lynn Pettis (6/25/2009)
I only hope he reads the blog, but I doubt it.
I hope (s)he did. Next posts have been really okay.
Heh... I'm not sure where the link...
--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)

June 26, 2009 at 6:11 am

#1015944
RE: User-defined function not recognized

Let's see if it actually made it from one server to another. What do you get when you run the following?
SELECT *
FROM sys.Objects
WHERE Name = 'fn_Split'
If the answer...
--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)

June 25, 2009 at 3:01 pm

#1015640
RE: Split string using XML

jo stovall (6/25/2009)
We are converting SS2000 DTS packages to SSIS 2005.
I need help using a User Defined Function within a query on a table.
The function performs correctly.
select * from...
--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)

June 25, 2009 at 1:17 pm

#1015568
RE: Split string using XML

Senthilnathan.Karunakaran (6/25/2009)
We did performance and scaling test to split the comma separated string value using XML query and SQL function.
The plan was better with XML split than SQL function; however...
--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)

June 25, 2009 at 12:37 pm

#1015545
RE: printing 1 to 100 in SQL Server as a batch....

Sinshith S Anand (6/23/2009)
Please contribute ur ideas...I have got only one correct answer....
Heh... the correct answer is "Anything that doesn't resort to RBAR or hidden RBAR."
--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)

June 24, 2009 at 8:25 am

#1014682
RE: Converting non-clustered index to clustered index

Eswin (6/23/2009)
Since there is already a non-clustered index for the primary key constraint on emp_id i need to convert this non-clustered index "PK__Employees__1D4655FB" to a clustered index.
CREATE UNIQUE CLUSTERED
...
--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)

June 24, 2009 at 5:59 am

#1014564
RE: Converting non-clustered index to clustered index

When you specify the PK for a table, unless you explicitly ask for a non-clustered PK, it will automatically create a clustered index on the PK.
--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)

June 24, 2009 at 1:12 am

#1014465
RE: Need help on set-based expression

You've already written it. Look at the SELECT statement you built for the cursor. Just put the display in the text mode and let just that SELECT do...
--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)

June 24, 2009 at 1:06 am

#1014461
RE: printing 1 to 100 in SQL Server as a batch....

Of course, there's my favorite...
[font="Courier New"] SELECT t.N
FROM dbo.Tally t
WHERE t.N <= 100[/font]
You should Google the term "Tally Table" or click on the following link.
http://www.sqlservercentral.com/articles/T-SQL/62867/
--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)

June 23, 2009 at 11:50 pm

#1014436
RE: printing 1 to 100 in SQL Server as a batch....

Of course, there's always the Itzik method...
[font="Courier New"] CREATE FUNCTION dbo.fnItzekNumsTest(@N AS BIGINT)
RETURNS TABLE
     AS
RETURN
   WITH
        L0   AS (SELECT 1 AS C UNION ALL SELECT 1),   --2 rows
        L1   AS (SELECT 1 AS C FROM L0 AS A, L0 AS B),--4 rows
        L2   AS (SELECT 1 AS C FROM L1 AS A, L1 AS B),--16 rows
        L3   AS (SELECT 1 AS C FROM L2 AS A, L2 AS B),--256 rows
        L4   AS (SELECT 1 AS C FROM L3 AS A, L3 AS B),--65536 rows
        L5   AS (SELECT 1 AS C FROM L4 AS A, L4 AS B),--4294967296 rows
        Nums AS (SELECT ROW_NUMBER() OVER (ORDER BY C) AS n FROM L5)
         SELECT N FROM Nums WHERE n <= 100[/font]
--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)

June 23, 2009 at 11:43 pm

#1014433
RE: printing 1 to 100 in SQL Server as a batch....

hi_abhay78 (6/23/2009)
try this my friend :
WITH Numbers(Number) AS (
SELECT 1
UNION ALL
SELECT Number + 1
FROM Numbers
WHERE Number <= 99
)
SELECT *...
--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)

June 23, 2009 at 11:36 pm

#1014432

Viewing 15 posts - 43,246 through 43,260 (of 59,098 total)