Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,811 through 36,825 (of 59,098 total)

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
RE: Replacing substring with a substring

rabisco (9/15/2010)
I have resolved this with the following statement
update bodyTextTable
set bodyText = cast(replace(cast(bodyText as nvarchar(max)),'/themes/old/', '/themes/new/') as ntext)
I had to cast ntext to nvarchar and cast it back to ntext...
--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:15 pm

#1221809
RE: Dynamic Quer in UDF

Heh... yeah... I know all the "reasons" people and MS give. I still think it's a little bit odd that I can execute dynamic SQL in a stored procedure...
--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:06 pm

#1221805
RE: Finding the two highest values for a criteria

Jeff Moden (9/15/2010)
FelixG (9/15/2010)
Let's assume that I have the following table tables:
Orders (orderdate, ordernumber, productcode)
- ordernumber is an identity column
I need to get the two highest values...
--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 5:49 pm

#1221797
RE: OK This is a weird one

jeff.mason (9/15/2010)
Yeah, I know, I feel stupid too. What can I say, it was 11:30 PM, we are tired, and stuck in a rut for troubleshooting. We attacked...
--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 5:46 pm

#1221796

Viewing 15 posts - 36,811 through 36,825 (of 59,098 total)