Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,466 through 39,480 (of 59,098 total)

RE: Too Tipsy To Work

Gary Varga (3/8/2010)
All fair comments as far as regulators go, however, before the Royal College of Surgeons demanded certain qualifications, mere barbers would drill into peoples heads. This barbaric period...
--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)

March 8, 2010 at 5:24 pm

#1130357
RE: Are the posted questions getting worse?

Paul White (3/8/2010)
Greg Edwards-268690 (3/8/2010)
Reminds me of why I always want everyone to expand on the business requirements as it will save us both time.Greg E
So true. They (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)

March 8, 2010 at 7:38 am

#1130008
RE: Calculating Moving Averages with T-SQL

sven.purbe (3/8/2010)
Well Jeff, if you look at the problem in a real world situation with thousands of stocks and thousands of datapoints and thousands of accesses to those I would...
--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)

March 8, 2010 at 7:11 am

#1129986
RE: Calculating Moving Averages with T-SQL

sven.purbe (3/8/2010)
select
B. IntNumber as [DayNumber],
sum(A. close_price) as [20_day_sum],
COUNT_BIG(*) as [#Days]
from
test. google_stock_2 a
join Aux. Integers B on b. IntNumber >= a. DayCount
and b. IntNumber < a. DayCount + 20
group by
B. IntNumber
That...
--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)

March 8, 2010 at 6:32 am

#1129956
RE: XP_CMDSHELL

sheik (3/7/2010)
Thans for your input...
The problem was, I worte the query like this
SELECT@QRY_IN= 'select
Employee_code from db1..table1_tmp'
If I change the query in the below format then it is working,
SELECT@QRY_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)

March 8, 2010 at 6:19 am

#1129950
RE: Too Tipsy To Work

Gary Varga (3/8/2010)
From a truly serious viewpoint (sorry to spoil the party - hic), I believe that IT practitioners should be regulated like the legal and medical professions.
I 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)

March 8, 2010 at 6:16 am

#1129949
RE: Are the posted questions getting worse?

Heh... OMG! Under the category of "Are the posted ANSWERS getting worse?"
http://www.sqlservercentral.com/Forums/Topic877218-1292-1.aspx#bm878332
--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)

March 7, 2010 at 10:10 am

#1129775
RE: Concatenate column rows into one row with a group by

skpanuganti (3/7/2010)
select grp,sum([amount]) [amount],case when [grp]=1 then 'A01,A02,A03'
when [grp]=2 then 'A22'
else 'A33,A36' end [ledger]
from dbo.sqlcentral
group by grp
-- replace 'dbo.sqlcentral' with...
--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)

March 7, 2010 at 10:06 am

#1129774
RE: SSIS Slower for Data Imports??

T-SQL_NewBie (3/4/2010)
I have been told by my manager that SSIS 2008 is slower than Hibernate for data migration, apparently because of cache problems..how do I reason that SSIS is better....
--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)

March 7, 2010 at 9:42 am

#1129768
RE: SQL Random selection with NewID()

It would probably help folks help you a lot if you could post some table info and some readily consumable data. See the following link for an article on...
--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)

March 7, 2010 at 9:40 am

#1129766
RE: Alternate of Row_Number() in SQL 2000

Ah... see? That's what I meant... not enough coffee on my part. 🙂
The code that Lowell posted will do the trick and it's one of the reasons why 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)

March 7, 2010 at 9:32 am

#1129765
RE: XP_CMDSHELL

As a side bar, I would encapsulate the server name in double quotes in case you ever need to run the code against a named instance which will have 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)

March 7, 2010 at 8:56 am

#1129759
RE: XP_CMDSHELL

sheik (3/7/2010)
Hi,
I am using XP_CMDSHELL in SQL 2005. If Run the below query then it creates the file in the specified folder
EXEC MASTER..XP_CMDSHELL 'BCP "select Employee_Code from...
--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)

March 7, 2010 at 8:54 am

#1129758
RE: Alternate of Row_Number() in SQL 2000

Heh... probably not enough coffee on my part, yet, but I'm missing it, Chris. How can you use the code you posted to produce the ID_Line_No column content that...
--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)

March 7, 2010 at 8:40 am

#1129756
RE: Concatenate column rows into one row with a group by

Thank you for the feedback. I'd have only repeated myself if I posted a solution for you on this thread and appreciate the time you took to peruse 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)

March 6, 2010 at 6:47 pm

#1129704

Viewing 15 posts - 39,466 through 39,480 (of 59,098 total)