Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,476 through 44,490 (of 59,101 total)

RE: Update column as an identity

pedro.ribeiro (3/23/2009)
Hi -
I have a table. This table (table1) as 3 columns (name,address and number).
The fields 1 and 2 (name and address) are already with data.
I need 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 23, 2009 at 5:08 pm

#964885
RE: Is it possible to simulate the cross apply function?

I don't believe any of that is necessary in either 2000 or 2005, but I can't tell without some sample data ... please see the link in my signature below...
--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 23, 2009 at 4:53 pm

#964876
RE: COUNT Question

I'd recommend learning some of the basics...
http://sqlcourse.com/
--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 23, 2009 at 4:50 pm

#964871
RE: MEAN()

Have you any sample data that you'd like to share along with the expected answer to make you thread perfectly clear? And, before you post any data, please take...
--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 23, 2009 at 4:40 pm

#964867
RE: Books OnLine?

Betim Drenica (3/23/2009)
Hi guys,
Thanks a lot for your posts!
First I am not SQL Server newbie, and 2nd I am asking in the kind of poll!
Thanks!
Heh... you should have stated 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 23, 2009 at 4:29 pm

#964862
RE: Which country is best for Outsourcing?

karthikeyan (3/23/2009)
All,
Which country is best for outsourcing? I believe i will get some interesting answers.
Why do you want to know?
--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 23, 2009 at 4:13 pm

#964855
RE: Are the posted questions getting worse?

RBarryYoung (3/23/2009)
Steve Jones - Editor (3/23/2009)
Thanks :blush:
good to meet you as well and glad you liked the presentation.
So what's Lynn really like in person? Can you actually see 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 23, 2009 at 2:37 pm

#964787
RE: How to import data from text file into SQL

halifaxdal (3/23/2009)
Jeff Moden (3/20/2009)
halifaxdal (3/20/2009)
Thank you all for the reply, like I mentioned earlier, the problem has almost been resolved except: how to ignore the last line in the source...
--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 23, 2009 at 2:29 pm

#964779
RE: Hex to Decmial Conversion

Grady Christie (3/20/2009)
That works perfectly!
Many Thanks, Grady Christie
Grady,
How did you manage to prepend the "0x" to your columns to get this to work correctly?
--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 23, 2009 at 2:12 pm

#964759
RE: Shrinking Database file

SUBRAHMANYA HEDGE (3/23/2009)
If your database is not configured for Replication or Logshipping you can use following command to shrink your databse log file to death:
backup log with truncate_only...
--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 23, 2009 at 6:11 am

#964341
RE: Just testing the new code window... please disregard

RBAR? How so?
--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 23, 2009 at 5:46 am

#964329
RE: T-Sql rant

Carlton Leach (3/22/2009)
"Cursors are only useful for people who don't know how to write SQL"
Heh... Amen Mr. Leach.
--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 23, 2009 at 5:31 am

#964325
RE: is possible thro a single query

Agh... the code above needed a tweek... sorry about the error... it failed one scenario so I fixed it.
--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 22, 2009 at 10:58 am

#964145
RE: T-Sql rant

Michael Valentine Jones (3/22/2009)
The thread on the link below is a good example of a way not to generate a Next ID. I had thought about this method myself,...
--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 22, 2009 at 10:47 am

#964141
RE: is possible thro a single query

S (3/22/2009)
Hi,
Kindly find attached the file for table structure and insert statement in txt files.
Thanks,
Sree 🙂
Heh... see? Someone already started working on your stuff since you made it easy...
--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 22, 2009 at 10:30 am

#964137

Viewing 15 posts - 44,476 through 44,490 (of 59,101 total)