Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,436 through 39,450 (of 59,072 total)

RE: Unable to find table in the database

dohomebiz (3/8/2010)
I figured it out. thanks for your time.
So what was the problem? Might be helpful to other folks if we knew.
--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:55 pm

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

MelissaLevitt (3/8/2010)
Jeff,
Your suggestion with the function almost worked except that I have to work with a temporary table and so I can't use the function.
I have been trying to 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)

March 8, 2010 at 6:06 pm

#1130364
RE: SSIS Slower for Data Imports??

T-SQL_NewBie (3/8/2010)
Jeff Moden (3/7/2010)
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...
--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:47 pm

#1130362
RE: XP_CMDSHELL

cfradenburg (3/8/2010)
Check what @@servername returns. If the server got renamed that may not be the actual name of the server. The following will get the current name 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 5:27 pm

#1130359
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

Viewing 15 posts - 39,436 through 39,450 (of 59,072 total)