Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,206 through 32,220 (of 59,099 total)

RE: How to generate all Possible Alphabit pattern in a sequence?

CELKO (10/22/2011)
Let's assume that you have the usual Series table with the integers 1 to (n).
SELECT SUBSTRING ('ABCDEFGHIJKLMNOPQRSTUVWXYZ',
...
--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)

October 22, 2011 at 10:02 am

#1398334
RE: CreateTempTable function?

I agree with what most of the folks have said about Temp Tables on this thread. I do, however, do a conditional drop of Temp Tables at the beginning...
--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)

October 22, 2011 at 9:30 am

#1398332
RE: Need to pivot with a customer table and a phoneContact table

dndaughtery (10/21/2011)
If I have a customer table with 2 columns: Cust_ID, CustomerName
And a PhoneContact table with the following columns: PhoneID,Cust_ID (FK), Phone_Number
how wold I pivot to recieve the following record...
--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)

October 22, 2011 at 9:15 am

#1398331
RE: create check constraint to reference non key values in foreign table

Although using a UDF as a CONSTRAINT is very clever, beware of "Hidden RBAR" folks. The addition of such a constraint that uses a Scalar UDF with an external...
--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)

October 21, 2011 at 10:05 pm

#1398296
RE: Query

Mvs2k11 (10/19/2011)
I want generate a report of week user activites on a server.
Please provide me the scripts.
I know it's probably just a problem with the language barrier, but you really...
--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)

October 21, 2011 at 5:28 pm

#1398282
RE: Level 2: History of Structured Query Language (SQL)

jberg-604007 (10/21/2011)
Especially now that Sql Server 2008 is more like Oracle 10/11 than ever, which is actually a good thing.
Since I have a primordial hatred for Oracle, I'll have to...
--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)

October 21, 2011 at 5:21 pm

#1398279
RE: Which Versions of SQL Server Do You Have?

CE (GAK!), a handful of Express, 1 2k, 2 (1 Dev, 1 Prod) 2k5 because of 3rd parties (it's a HUGE instance), and everything else has just recently been upgraded...
--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)

October 21, 2011 at 5:17 pm

#1398278
RE: A recursive function for the sum of "n" number of a series

champions (10/21/2011)
.Una funcion recursiva para la suma de los "n" primeros numeros de la serie
A=1+2+3+4+...+n
Tell your instructor to read the following article for why this should be taught ONLY 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)

October 21, 2011 at 5:13 pm

#1398276
RE: General question on views vs stored procedures

I dislike views but not because of views... it's because many folks use them as if they were tables. If you join to a calculated column, especially an aggregated...
--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)

October 21, 2011 at 4:57 pm

#1398274
RE: Doubled the size of my SQL Server and now getting bad performance

This might not be the problem but we recently ran into just such a problem. It was a bugger to figure out but the fix was simple... we had...
--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)

October 21, 2011 at 4:49 pm

#1398273
RE: Exporting a column that contains CSV data

Thanks for the feedback on the speech, Martin. Thank you for being there. Very much appreciated.
--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)

October 21, 2011 at 12:59 pm

#1398185
RE: Exporting a column that contains CSV data

Martin Schoombee (10/21/2011)
jasonkellington (10/20/2011)
Any ideas of how to approach this?
First off, I'm not sure how to translate the original gaurdians column into separate columns in the csv, which 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)

October 21, 2011 at 11:18 am

#1398140
RE: Selecting particular rows

ByronOne (10/21/2011)
Cheers Geoff - always great to see different ways of doing things...
You're welcome but my name is "Jeff". It's hard enough of me to keep track of myself...
--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)

October 21, 2011 at 6:50 am

#1397937
RE: Managment Studio. Different PC's give different result for same query.

Scott Levy (10/20/2011)
Andre, both PC's are connecting to the same database on the server and as far as I know they are both running the same version of Management Studio.
Are...
--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)

October 20, 2011 at 9:00 pm

#1397729
RE: Exporting a column that contains CSV data

jasonkellington (10/20/2011)
Any ideas of how to approach this?
Yep... first, you need a splitter. See the following article for that... the actual functions are listed as files in...
--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)

October 20, 2011 at 8:56 pm

#1397728

Viewing 15 posts - 32,206 through 32,220 (of 59,099 total)