Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,751 through 48,765 (of 59,102 total)

RE: Recommendations on LinkedIn

I'm thinking it could help employers notice me if they see who I've had forum discussions with.
Heh... WHICH forum discussions would you be talking about? You have precisely 1...
--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)

August 17, 2008 at 4:20 pm

#859197
RE: Can't install sql server 2005:(

Which edition of SQL Server 2005 are you trying to install?
--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)

August 17, 2008 at 4:12 pm

#859196
RE: Need query in SQL server 2000

Venkatesan Prabu (8/17/2008)
create table FirstTable(Attrib1 varchar(10), Attrib2 varchar(10),Attrib3 varchar(10))
insert into FirstTable values('Doc1','Attrib1','val1')
insert into FirstTable values('Doc2','Attrib2','val2')
insert into FirstTable values('Doc3','Attrib3','val3')
insert into FirstTable values('Doc4','Attrib4','val4')
select * from FirstTable
create table SecondTable(Attrib2 varchar(10),Attrib22 varchar(10))
insert into SecondTable...
--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)

August 17, 2008 at 3:49 pm

#859195
RE: Need query in SQL server 2000

GilaMonster (8/17/2008)
SQL 2000-related questions should rather be posted in the SQL 2000 forums in future please.
FirstTable has 1 lakh record , Second table has 2 Lakh record and Third...
--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)

August 17, 2008 at 3:35 pm

#859194
RE: Difference between SQL Server Standard edition - OEM version , retail and Promo version

Please post the link where you found the pricing so we can figure out what you mean by the "OEM" version because, to the best of my knowledge, nothing 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)

August 17, 2008 at 3:33 pm

#859193
RE: update query append number in start of all rows

masood24 (8/17/2008)
hello dear 1st thank you very much for help but I have tried the query but it is not working message is successful with 1 row changed but actually...
--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)

August 17, 2008 at 3:27 pm

#859192
RE: Loading text file to SQL Server 2005 using bulk insert

Heh... that's known as a "Headerless Ragged Right" file and they're a bugger to import correctly. BCP and BULK insert require that all the rows have the same number...
--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)

August 16, 2008 at 8:47 pm

#859149
RE: setting the recovery model

No.
--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)

August 16, 2008 at 8:01 pm

#859144
RE: Query Question

Jeffrey Williams (8/16/2008)
Oops - forgot the temp table, thanks Jeff.
No problem... it's the beauty of a forum... world's biggest team. 😉
--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)

August 16, 2008 at 8:00 pm

#859143
RE: Copy and rename a file using stored procedure in SQL server 2005

You CAN have file names with spaces (although, I prefer not to). And, you can easily run commands on those file names by enclosing the filename in double quotes......
--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)

August 16, 2008 at 7:57 pm

#859142
RE: TXT file for each table

What the heck is the matter with using Replication?
--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)

August 16, 2008 at 3:53 pm

#859130
RE: Query Question

And, yes, it's easy to dump that into a temp table...
Yes, this can be done using an alias. Example:
SELECT t1.col1 AS t1_col1,
...
--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)

August 16, 2008 at 3:51 pm

#859129
RE: Telework Works

Considering that the drive to work is 112 miles round trip, I'd love to see my company implement that right the heck now! 😉
--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)

August 16, 2008 at 3:46 pm

#859128
RE: update query append number in start of all rows

bitbucket (8/16/2008)
Update Dbo.Table1 UPDATE dbo.location SET local_Phone = '91'+local_phone
Just to be sure, I'd add a check to make sure the numbers haven't already been updated...
UPDATE dbo.Table1
...
--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)

August 16, 2008 at 3:42 pm

#859127
RE: Urgent help required !!!!!

Joe Torre (8/16/2008)
It is often faster to create a temp table yourself to replace the sub-select
Being a bit of a skeptic, let's see the test you did that proves 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)

August 16, 2008 at 3:35 pm

#859126

Viewing 15 posts - 48,751 through 48,765 (of 59,102 total)