Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,781 through 36,795 (of 59,072 total)

RE: Missing sequence number

Hey folks. Wayne S. found the occurance of a bug in the code that I previously posted on this thread. I've repaired that code on this thread. ...
--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 15, 2010 at 8:52 pm

#1221849
RE: Patients who come in within 14 days

All these bloody "medical database" problems seem like homework to me. I know they can sometimes get a little screwy but there is just no way that the health...
--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 15, 2010 at 7:56 pm

#1221837
RE: simple SELECT query takes ten seconds to return 5000 rows - can I optimize?

I know this might seem stupid to even try but it made the code run twice as fast on my machine...
SELECT
X.*
FROM X
INNER JOIN (
SELECT
...
--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 15, 2010 at 7:48 pm

#1221836
RE: D: drive is full and transaction log is full

Carl Federl (9/15/2010)
The simpliest solution is to add a additional log file on another drive, backup the log, shrink the first log file and then remove the additional log file....
--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 15, 2010 at 7:39 pm

#1221834
RE: Advice on importing multiple txt files with different file structures

Heh. I built a whole import system for unpredictable inputs (basically, spreadsheet CSV files) (can't reveal the source... NDA hasn't expired yet) using methods very basically similar to yours...
--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 15, 2010 at 7:28 pm

#1221832
RE: Need help in this query

LutzM (9/15/2010)
The requested output is not really something you should expect from a SQL statement:
a) It seems like you want to have "flexible column names" for each row 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)

September 15, 2010 at 7:16 pm

#1221828
RE: Need help in this query

sql.abhishek (9/15/2010)
hi
i have my input table as follows
ID----total_amt-----total_month--------start_date
1-----1200000--------6-------------- 9/4/2009
2----300000---------3---------------- 1/1/2006
3----300000---------10--------------- 9/6/2006
4
5 ...so on
and i want a way to get the output as
ID
-----sept'09----oct'09----nov'09-----dec'09-----total for 2009---jan'10-----feb10----Tot
1---200000---200000---200000---200000----- ...
--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 15, 2010 at 7:14 pm

#1221827
RE: Can Windows variables Be Used Within T-SQL

JC-3113 (9/15/2010)
HI Drew
that will work
but how do i concantenate it to the string in @subject=
if my @@SERVERNAME is NSAB-SS73-ORA-N
then
I want it to look like this:
NSAB-SS73-ORA-N Test - DBCC...
--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 15, 2010 at 7:08 pm

#1221826
RE: Patients who come in within 14 days

Hmmm... not homework? How do you explain the remarkable similarity here...
http://www.sqlservercentral.com/Forums/Topic986540-391-1.aspx
--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 15, 2010 at 7:03 pm

#1221825
RE: create db dynamically

Ghanta (9/15/2010)
Is there a way through sql proc to script the table and db from original database and use that dynamically to create a database for the company using 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 15, 2010 at 6:39 pm

#1221822
RE: Concatenate Results in Row

I agree... great thread! The only thing that may be wrong in this whole thread is the original requirement. 😉 Why does someone want to denormalize 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)

September 15, 2010 at 6:35 pm

#1221818
RE: How to do the load testing sqlserver 2008R2

kommagoni (9/15/2010)
Hi All, how to perform the load testing in sql server 2008R2, when 2 r 3 users connecting to server its performing good but cpu utilization is high after...
--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 15, 2010 at 6:25 pm

#1221816
RE: Winzip use in SSIS

The command line version of Winzip is actually the PRO version of Winzip and it hasn't been free for a long time.
--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 15, 2010 at 6:22 pm

#1221815
RE: Last Year to Date report parameter

WayneS (9/15/2010)
1. Change "Today" to "GetDate()".
2. In your example, you want the date range to end on 9/14/2010. I assume this is a typo, and should be 9/14/2009?
I've got 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 15, 2010 at 6:20 pm

#1221813
RE: Last Year to Date report parameter

Dung Dinh (9/15/2010)
You should use
select dateadd(yy,-1,dateadd(d,-1,getdate()))
Agreed... now all you need to do is to provide the other needed date. 😉
--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 15, 2010 at 6:17 pm

#1221811

Viewing 15 posts - 36,781 through 36,795 (of 59,072 total)