Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,226 through 54,240 (of 59,089 total)

RE: Recursive query for a Bill of Materials table

I don't know what is wrong, but I can neither open or save the attachement.
However, my recommendation was to look at "Expanding Hierarchies" in Books Online... that recommendation still stands......
--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)

November 9, 2007 at 8:05 am

#749861
RE: Import

I guess that means they're on the same server... so...
1) where can i have a predefined table with DBName,EMail as fields in it. either in each 5 DB's or just...
--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)

November 9, 2007 at 7:54 am

#749854
RE: Adding a column to a table

John Mitchell (11/5/2007)
Mark
My suggestion would be not to bother with an extra column, but instead to store that single extra value in a variable.
John
That would be my suggestion, as well.
--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)

November 9, 2007 at 7:47 am

#749848
RE: Query Performance in 2 Server

There's a thousand different reasons for things like this...
Do the tables have the same number of rows?
Do the tables have the same indexes?
Are the indexes up to date?
Are the statistics...
--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)

November 9, 2007 at 7:44 am

#749845
RE: Bulk Insert Error

Both...
The DBA's need to verify that the SQL Server instance is logged in either as a Super User that can see everything or must be logged in as a user...
--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)

November 9, 2007 at 7:38 am

#749841
RE: is there any difference between != and <>

Vincent Chute (11/9/2007)
The exact opposite for me.
I learnt != in maths so seeing <> has always been a wtf moment for me.
Just different notation dialects.
"!" being a shorthand for 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)

November 9, 2007 at 7:12 am

#749832
RE: is there any difference between != and <>

Shaun McGuile (11/9/2007)
!= is th inequality in C# get used to it as CLR programming takes off!:hehe:
Heh... good point. But have had this argument with many other folks... there's...
--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)

November 9, 2007 at 7:00 am

#749830
RE: Tale of <> Operator

Although the "OR" in your example allows each value to be matched and displayed, it does not form a Cartesian product...
DECLARE @TableA TABLE (SNo CHAR(1),ENo INT)
INSERT INTO @TableA (SNo,ENo)
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)

November 9, 2007 at 6:56 am

#749828
RE: Best practice for applying set based updates

Sure... how many rows in the temp table?
--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)

November 9, 2007 at 12:18 am

#749736
RE: Querying remote database

I don't know for sure... but I think it's highly unlikely that MySQL will have the same nameing structure convention... never mind a user called "dbo".
--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)

November 9, 2007 at 12:12 am

#749735
RE: Loop Query of Data

SO... what does all of that mean? Did you use Ramesh's solution or not? If not, would you post your solution, please?
--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)

November 8, 2007 at 10:51 pm

#749717
RE: Aggregate Function

Perfect, John...
--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)

November 8, 2007 at 10:40 pm

#749715
RE: Add 3 columns into another column

You give up too soon 😉
[font="Courier New"]DECLARE @CrLf char(2)
SET @CrLf = Char(13) + Char(10)
SELECT COALESCE(NULLIF(Add1,' ') + @CrLf, '') + COALESCE(NULLIF(Add2,' ') + @CrLf, '') + COALESCE(NULLIF(Add3,' ') + @CrLf,...
--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)

November 8, 2007 at 10:37 pm

#749713
RE: Case expression problem

Jason Selburg (11/8/2007)
Thanks Jeff! I've never worked with Oracle so that info was very informative ... :hehe:
You bet, Jason... thanks for the feedback...
ps. I hate Oracle 😛
--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)

November 8, 2007 at 10:33 pm

#749711
RE: Having problem deleting through a cursor - newbie

Heh... thanks for the feedback... I actually wrote a cursor once or twice... it was to show how slow they were... 😉
--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)

November 8, 2007 at 10:30 pm

#749710

Viewing 15 posts - 54,226 through 54,240 (of 59,089 total)