Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,181 through 48,195 (of 59,095 total)

RE: Using While Loop with UNION clause

With the info given, there's no need for a loop.
SELECT RANK() OVER(PARTITION BY ID ORDER BY BudPerc DESC) AS Rank, *
FROM Table1
WHERE ID BETWEEN 1 AND 10
The...
--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)

September 21, 2008 at 10:01 am

#874702
RE: copy data from table by column and insert into single column in other table

bitbucket (9/20/2008)
To help those who can help you.... please follow the posting protocol as covered by the article in my signature block.. Thanks
BitBucket... you can turn that link into 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)

September 21, 2008 at 9:56 am

#874700
RE: copy data from table by column and insert into single column in other table

tksmith (9/20/2008)
Hi i'm looking for the best way to migrate data from an old table with column1,column2,column3 and insert the data from those columns into column1 in my new table.
the...
--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)

September 21, 2008 at 9:54 am

#874698
RE: Identifying gaps between intervals

thusi (9/21/2008)
Thanks a lot for your help Jeff. A slight problem is that this doesn't include patientId in the join and I need to know which patients had the lapse..but...
--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)

September 21, 2008 at 8:34 am

#874691
RE: Controling result pane from TSQL

Maybe a registry entry...
--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)

September 20, 2008 at 11:07 pm

#874667
RE: Controling result pane from TSQL

About the only way I can think of to do this is to use PRINT to create the output if it needs to be in a Text results pain. ...
--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)

September 20, 2008 at 10:18 pm

#874665
RE: Controling result pane from TSQL

Good idea about the "sendkey"... but not sure how you would do it because the "scope" of QA changes when you hit the run button. All output is directed...
--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)

September 20, 2008 at 10:03 pm

#874663
RE: Identifying gaps between intervals

Hello and welcome aboard! Please take the time to look at the article connected to the link below my signature. It'll help folks like me help you faster...
--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)

September 20, 2008 at 9:42 pm

#874662
RE: How to Select max Value for a DataType

Not that I know of... closest you might come is...
sp_Help BIGINT
... where BIGINT is the datatype.
--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)

September 20, 2008 at 8:44 pm

#874660
RE: Using value in a specific cell within an specific table as query criteria

Sure... what's the name of the table, the PK that identifies the row, and the column name of that certain cell?
--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)

September 20, 2008 at 8:15 pm

#874658
RE: Killing users

rbarryyoung (9/19/2008)
Seriously though, try this:
ALTER Database MyDB set single_user with rollback immediate
I knew this was going to be a fun one when I saw the title. And, heh, 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)

September 20, 2008 at 8:03 pm

#874657
RE: Face to Face

I value F2F communications for many reasons... EMail, despite the presence of those bloody emoticons, don't tell you the emotion of the person... can't really tell if their mad, upset,...
--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)

September 20, 2008 at 7:50 pm

#874655
RE: monthly stored procedure to export table to text file

Heh... Dude! I thought you said your buddy had it whipped.... 😉
--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)

September 20, 2008 at 7:38 pm

#874653
RE: Controling result pane from TSQL

I could be wrong, but I'm pretty sure there's no way to do it via T-SQL.
--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)

September 20, 2008 at 7:34 pm

#874652
RE: Invalid views

Gotcha... good idea! Me... I use cocktail napkins. 😀
--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)

September 20, 2008 at 7:25 pm

#874651

Viewing 15 posts - 48,181 through 48,195 (of 59,095 total)