Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,801 through 40,815 (of 59,070 total)

RE: Adding duplicate rows to a resultset

Paul White (12/4/2009)
For larger values, a dynamic Numbers Table could be used (generated using TOP (n) and the ROW_NUMBER() function over some system table CROSS JOINed to itself a number...
--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 5, 2009 at 9:54 am

#1088171
RE: All-in-one

I like the all-in-one aspects of SSMS... what I don't like is all the functionality that is no longer available. Things like easily being able to do a multiple...
--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 5, 2009 at 9:47 am

#1088168
RE: correlated subquery

ezhil-649633 (12/3/2009)
But, i want to know whether the same can be achieved through corelated subqueries. If, yes how to achieve that?
For a finite number of levels, probably. For an...
--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 5, 2009 at 9:39 am

#1088165
RE: DTS dropping chars at 255

How do you know the field is being cut off at 255 characters? By looking at it in Query Analyzer? If so, the default for Query Analyzer is...
--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 5, 2009 at 9:21 am

#1088163
RE: REPLACE Multiple Spaces with One

Heh... it's not a fault... it's a feature! Makes it real easy to look good by doing a "performance improvement". 😛
Actually, I'm tickled at the response, Paul. I've...
--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 5, 2009 at 9:00 am

#1088159
RE: Converting varchar to int

james.hp123 (12/5/2009)
hi
Char is a fixed-length data type, the storage size of the char value is equal to the maximum size for the column.
varchar is a variable-length 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)

December 5, 2009 at 8:53 am

#1088158
RE: Crosstab query - Please help. it has been a few days without sleep

RandMan-585256 (12/4/2009)
Jeff Moden (12/3/2009)
RandMan-585256 (12/3/2009)
Since this is Access VBA why don't you use the cross-tab query type in Access?
Hmmm.... not a bad idea. Do you believe that it would...
--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 5, 2009 at 12:12 am

#1088124
RE: Crosstab query - Please help. it has been a few days without sleep

So! What say yea, Sam!?
--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 5, 2009 at 12:03 am

#1088123
RE: Are the posted questions getting worse?

CirquedeSQLeil (12/4/2009)
You mean I can't run SQL Server on Knoppix and fail replication over to the subscriber on an as-needed basis?:-P:-D
Damn! I was hoping to run it on 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)

December 4, 2009 at 11:46 pm

#1088122
RE: SCREW MICROSOFT !!!

Robert Davis (12/4/2009)
The SQL Server team doesn't write the providers to connect to SQL Server. Unfortunately, whoever does the JET provider has yet to write a 64 bit version 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)

December 4, 2009 at 11:43 pm

#1088121
RE: Exporting to Excel Using a CLR Stored Procedure

Rob Fisk (12/2/2009)
alex-743051 (12/2/2009)
I just can use VBA in the Excel worksheet to perform same task:
I've used similar in the past but it does not cover the fact that 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)

December 4, 2009 at 1:30 pm

#1088028
RE: Converting varchar to int

nigel. (12/4/2009)
izhar-azati (12/4/2009)
Try:
SELECT * FROM #product
WHERE ','+catid+',' like '%,1,%'
Yes, that would do it too. But proper normalization would be better, as Jeff recommends (if possible).
I guess my attempt at...
--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 4, 2009 at 8:13 am

#1087769
RE: Are the posted questions getting worse?

GSquared (12/4/2009)
I found out late yesterday that the CEO, the President, the Chairman, and the CFO, of the company I work for, all resigned late Wednesday, without prior notice, and...
--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 4, 2009 at 7:47 am

#1087730
RE: The Sixty-Second Guide to becoming a SQL Server DBA

Grant Fritchey (12/4/2009)
Great primer Barry. It covers the basics of what's needed very well. Since so many questions come through on the board around the concept of "How do 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)

December 4, 2009 at 7:31 am

#1087714
RE: The Sixty-Second Guide to becoming a SQL Server DBA

Man, do I ever agree with that! Books are great but having an experienced Mentor to teach and guide you, even if it's just an hour a day, is...
--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 4, 2009 at 7:26 am

#1087708

Viewing 15 posts - 40,801 through 40,815 (of 59,070 total)