Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,036 through 22,050 (of 59,072 total)

RE: how to rewrite query to avoid duplicate records (across columns)

asita (1/3/2015)
Nolock is ignore the locks (please ignore it)
Trust me Dhani, we know what it does and folks in-the-know can't just ignore it. It's normally a bad thing 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)

January 4, 2015 at 10:01 am

#1767616
RE: how to rewrite query to avoid duplicate records (across columns)

Eirikur Eiriksson (1/4/2015)
asita (1/3/2015)
Nolock is ignore the locks (please ignore it)
To me it appears as the nolock hint is used here as a blanket solution, without understanding the potential effects...
--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)

January 4, 2015 at 9:57 am

#1767612
RE: How to Import Data from Excel sheet to Sql server 2008

@Navin,
Quick question, please. Do you just want to import the spreadsheet as it is (Flat table that resembles the spreadsheet in structure) or do you want the data 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)

January 4, 2015 at 9:53 am

#1767611
RE: insert data into two tables

<Head-Desk> Thanks, sqlvogel. I keep forgetting about MERGE because I'm still stuck in a 2005 world (working on upgrades to 2012). And, I agree... I'd still probably use...
--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)

January 3, 2015 at 9:18 pm

#1767591
RE: How to Import Data from Excel sheet to Sql server 2008

navbingo20 (1/3/2015)
Hi,
the excel sheet one you attached is correct..
sql server 2008 r2 i guess it should be 64bit
Thanks
Navin
Perfect. I'm working on it.
Shifting gears, I'd love to see how...
--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)

January 3, 2015 at 6:56 pm

#1767587
RE: How to Import Data from Excel sheet to Sql server 2008

BTW... I've attached a sample spreadsheet that I'm going to use for this. If your spreadsheet is radically different, then make up a small example like I did and...
--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)

January 3, 2015 at 3:07 pm

#1767579
RE: insert data into two tables

shashianireddy (1/3/2015)
i give example only..
how to insert two tables in single quarie ...like above
As the others have said, two tables, two queries. It can't be done in a single...
--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)

January 3, 2015 at 3:03 pm

#1767578
RE: insert data into two tables

shashianireddy (1/3/2015)
i have excel file like below
sno name fname ...
--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)

January 3, 2015 at 11:40 am

#1767571
RE: Renaming multiple file names inside a folder

Michael L John (1/3/2015)
REN *_09162014.txt *.txt
+1000. I love the "old ways". So simple.
--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)

January 3, 2015 at 10:25 am

#1767568
RE: Are the posted questions getting worse?

It's only the 3rd of the year and I believe we already have a candidate for the year's most vague question.
http://www.sqlservercentral.com/Forums/Topic1648047-2799-1.aspx
Anyone have even a clue as to what...
--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)

January 3, 2015 at 10:21 am

#1767567
RE: how to create master table in sql

shashianireddy (1/3/2015)
how to create master table
plz give one example ...
I agree with Lynn. There's just not enough information here. What is this "master table" supposed to do...
--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)

January 3, 2015 at 10:17 am

#1767566
RE: How to Import Data from Excel sheet to Sql server 2008

p.s. It might take me a bit to get to this one. If someone wants to give this a shot in SSIS (which I'm not going to use...
--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)

January 3, 2015 at 10:11 am

#1767565
RE: How to Import Data from Excel sheet to Sql server 2008

navbingo20 (1/3/2015)
Hi ,
i have an Excel sheet , that i need to import directly to sql server 2008. how can i do that.
please help me to resolve this...
--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)

January 3, 2015 at 9:37 am

#1767563
RE: Insert Data set into two tables and grabbing identity from one, for the other

Eirikur Eiriksson (1/3/2015)
Jeff Moden (1/2/2015)
I could be wrong but that looks like it presupposes what the identities will be.
It doesn't as the output clause retrieves the identity values generated 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)

January 3, 2015 at 9:30 am

#1767562
RE: Clustered Index and Non-Clustered Index

These look like interview, homework, or test questions. I strongly recommend that you open "Books Online" (the help system for SQL Server) and start reading all you can about...
--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)

January 3, 2015 at 9:19 am

#1767560

Viewing 15 posts - 22,036 through 22,050 (of 59,072 total)