Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,066 through 22,080 (of 59,098 total)

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
RE: Date format conversion

cheryljanicedsouza (1/3/2015)
My whole column needs to be converted into that format, not the specific field
Careful, now. It's pretty easy to return formatted data but you should never store dates...
--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:15 am

#1767559
RE: stored procedure taking long time

mpradeep23 (1/2/2015)
hi team
my stored procedure was running fine
now it is taking long time what are the steps i need to follow to check what is the problem
thanks,
pradeep
Step 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)

January 2, 2015 at 9:38 pm

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

I could be wrong but that looks like it presupposes what the identities will be.
--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 2, 2015 at 8:04 pm

#1767516
RE: Best approach to download variably named CSV file from FTP and insert into existing table?

Oddly enough, I've never used SSIS for such a thing. Here are the steps I've taken in the past.
1. Today's date is turned into the expected file name......
--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 2, 2015 at 7:40 pm

#1767514

Viewing 15 posts - 22,066 through 22,080 (of 59,098 total)