Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,201 through 43,215 (of 59,102 total)

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

Lynn Pettis (6/29/2009)
And that will work until the SQL Server 2000 system table "views", like sys.syscolumns, go away in a future version od SQL Server. They have been depreciated.
I'm...
--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 29, 2009 at 8:41 am

#1016868
RE: converting lowercase to uppercase

Peso (6/29/2009)
Or use COLLATION
CONSTRAINT ss CHECK (adp IN ('T', 'F') COLLATE SQL_Latin1_General_Cp437_BIN)
That's a good check but I'd have to introduce someone to a serious volley of high speed pork chops...
--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 29, 2009 at 6:41 am

#1016785
RE: 911 - Cursor killing my trigger

As a side bar, I'm still waiting for the OP to post code where the things he wants to use aren't actually commented out so I can be sure of...
--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 29, 2009 at 6:37 am

#1016782
RE: 911 - Cursor killing my trigger

Scott Coleman (6/29/2009)
It is a triangular join, but without knowing more about the data I'm just guessing that there are a relatively small number of notes for each bug. ...
--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 29, 2009 at 6:33 am

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

Paul White (6/29/2009)
Peso (6/29/2009)
I only have 92 column in my master.sys.columns.
This is because I have an edited very slim version of MASTER database.
This is not something common, but you should...
--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 29, 2009 at 6:14 am

#1016765
RE: Retrieve comma-separated list within group by

In order to do the concatenation to create the CSV list, some form of sub-query either in the form of an actual sub-query or in the form of a UDF...
--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 29, 2009 at 5:58 am

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

Sinshith S Anand (6/28/2009)
Actually i was expecting different methods for counting 1 to 100.Methods using CTE,While loop,Go to,Cursor......I was expecting some different methods than this...Gail posted a different method...Thats 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)

June 29, 2009 at 5:53 am

#1016746
RE: Split string using XML

Chandra Sekhar Manchukonda (6/29/2009)
We are having only five characters ( , ', ", & ) that need escape character in XML.
We can use replace function for handling them.
DECLARE @test-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)

June 29, 2009 at 5:42 am

#1016740
RE: Split string using XML

sam.walker (6/29/2009)
Ignore that last post.
I've just simply compared on my server.
Rows 4096 based on huge repitition of AAAA,BB,CCCCCCCCC,D
Inline function
126 ms
123 ms
130 ms
Partial CLR plus tally table
3 ms
3 ms
3 ms
I used...
--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 29, 2009 at 5:39 am

#1016734
RE: How to chage IDENTITY Column seed

You're welcome. Thanks for the response.
--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 29, 2009 at 5:20 am

#1016719
RE: Split string using XML

The article is well written and my hat is off to the author for that. I have to agree with the others, though... using XML to split delimited data...
--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 28, 2009 at 7:47 pm

#1016576
RE: How to transpose from Row to Columns with out using Pivot

lmu92 (6/28/2009)
Paul White (6/28/2009)
lmu92 (6/28/2009)
Paul White (6/27/2009)
Clearly, in this case, and with this data distribution, there is nothing to choose between the three methods. ...
Paul
But how about the method I...
--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 28, 2009 at 8:40 am

#1016533
RE: How to transpose from Row to Columns with out using Pivot

Paul White (6/28/2009)
Jeff, could you let me have the number of your handrail-installation team please? 😀
PIVOT can be used with dynamic SQL, just the same as the CASE...SUM idea.
Heh......
--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 28, 2009 at 8:31 am

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

Paul White (6/28/2009)
Guys,
Does it really matter that much what was meant by the word 'correct'?
Taking the poor guy to task over semantics seems unfair.
Paul
Nah... not the word "correct"... I want...
--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 28, 2009 at 8:18 am

#1016528
RE: get real!

At least the correct answer wasn't "close" to all the other answers because none of the answers are correct in 2k.
1.2345679E+9
Before you start beating the "latest version" drum on 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)

June 27, 2009 at 9:47 pm

#1016473

Viewing 15 posts - 43,201 through 43,215 (of 59,102 total)