Jeff Moden

Forum Replies Created

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

RE: Simple query help

Thank you for taking the time to post the test data the way you did... saves me a lot of time...
This will do it...
;
WITH
ctePreAgg AS
(
SELECT Name1,
...
--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 6, 2009 at 10:17 pm

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

*********************************************************
** Here you are setting the variable @SqlSelect and then padding it with 10 additional characters
*********************************************************
--===== Create the SELECT part of our dynamic SQL
SELECT @SqlSelect = 'SELECT d3.Tag,' + CHAR(10)
Good...
--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 6, 2009 at 10:02 pm

#1088359
RE: Joining troubles

Nuts (12/6/2009)
I want to display the records from table 1 of those patients where patient_id of table 1 matches with the patient_id of table 2
Based soley on the question, 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 6, 2009 at 8:12 pm

#1088335
RE: Script to Start the SQL Server Services

You said you need to do this for maintenance purposes... what are they and why do you think you must stop the SQL Server Services to accomplish them?
--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 6, 2009 at 8:09 pm

#1088334
RE: How can I use a database event

If you consider the way you'd do it in Ingres "elegant", then why not just do it that way? Write the 3 stored procedures.
--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 6, 2009 at 8:06 pm

#1088331
RE: Need help with conversion -- string conversion

Bad day, Barry?
--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 6, 2009 at 8:04 pm

#1088330
RE: Having a switch to disallow duplicate rows. Would it be a useful feature?

David Portas (12/6/2009)
I think Codd may have been the first to suggest that SQL ought to have a software setting that allowed the developer to turn off duplicate rows 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)

December 6, 2009 at 8:03 pm

#1088329
RE: help add column of repeating numbers 123412341234

Heh... look back folks... the OP has left the building. 😉
--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 6, 2009 at 8:00 pm

#1088328
RE: Data Types for Flat File import

zuma01 (12/6/2009)
I am trying to create an SSIS package for importing our mobile phone bill from a CSV file.
Why? Simple BULK INSERT will do much better especially for performance....
--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 6, 2009 at 7:59 pm

#1088327
RE: Today's Random Word!

"Stab'n'Grab"...
Op has logged in precisely once.
--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 6, 2009 at 7:55 pm

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

Ok, Sam... I'm tickled I could help. With that thought in mind, I have to ask, do you understand what my code did and how it works compared 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)

December 6, 2009 at 7:18 pm

#1088319
RE: REPLACE Multiple Spaces with One

I absolutely agree. It helps a lot if you can demo an "easily repeatable problem" as well. We all hate intermitent problems and the good folks at MS...
--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 6, 2009 at 7:12 pm

#1088318
RE: Adding duplicate rows to a resultset

Paul White (12/6/2009)
Thanks Jeff,
Yes one should be careful. I wouldn't advocate using the method for billions of rows 😉
I had much smaller maximum values for 'Quantity' in mind -...
--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 6, 2009 at 7:08 pm

#1088317
RE: dynamic SQL in a function

My recommendation would be to post the code and some sample data according to the first link in my signature below. Someone may be able to help you avoid...
--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 6, 2009 at 9:47 am

#1088272
RE: Paging

Wow! I agree... just imagine if only 5 people open the same screen at once... the server will have to transmit a half million rows which will totally clog...
--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 6, 2009 at 9:39 am

#1088270

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