Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,121 through 36,135 (of 59,067 total)

RE: Please help me....Though this might sound silly

UPDATE xyz
SET @b-2 = ''
You're updating a variable there... not a column. You also have no criteria in the UPDATE so you'll be updating the whole table. Lookup...
--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 3, 2010 at 4:14 pm

#1246324
RE: Need a Help in Importing CSV file into DB

Saravanan_tvr (11/3/2010)
Thanks Now working fine, But In CSV file format, if one field like Product
descriptions having Multiple Comma Inside, but our SQL splitting them in to multiple column,
but We...
--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 3, 2010 at 4:03 pm

#1246321
RE: Most efficient parsing of Juniper syslogs in SQL?

If you don't want to or can't go third party or .Net, a Tally Table splitter could be the way to go here with some pretty high efficiencies. Any...
--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 3, 2010 at 3:54 pm

#1246316
RE: Calculate number of moths between two days?

I believe everyone is missing the requirements a bit on this one. The op wants to know how many months are in each year of a multi-year range...
--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 3, 2010 at 3:31 pm

#1246310
RE: drop the all tables

raistlinx (11/3/2010)
The OP asked for a way to easily clear out the tables.
Nope. Go back and look. The OP asked how to drop all the tables.
--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 3, 2010 at 3:12 pm

#1246303
RE: Percentage value not appearing

akhlaq768 (11/3/2010)
Thanks, how do I CAST a column called [Student] so it will work?
Replace the "665" with the column 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)

November 3, 2010 at 11:52 am

#1246198
RE: Are the posted questions getting worse?

GilaMonster (11/3/2010)
Jeff Moden (11/3/2010)
GilaMonster (11/3/2010)
....since I won't be at PASS?
Crap. You're one of the folks I wanted to meet.
Sorry, I thought you knew. It's not exactly been a secret.
You're...
--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 3, 2010 at 7:47 am

#1245992
RE: Are the posted questions getting worse?

Roy Ernest (11/3/2010)
Just wanted to give an update. Things are much better now. It did not rain much. The sky is still totally covered with cloud. Still raining but not...
--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 3, 2010 at 7:45 am

#1245991
RE: Are the posted questions getting worse?

Grant Fritchey (11/3/2010)
BrainDonor (11/3/2010)
I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me...
--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 3, 2010 at 7:20 am

#1245974
RE: Are the posted questions getting worse?

GilaMonster (11/3/2010)
....since I won't be at PASS?
Crap. You're one of the folks I wanted to meet. You're on my bucket list.
--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 3, 2010 at 7:14 am

#1245968
RE: Are the posted questions getting worse?

GSquared (11/2/2010)
Of course, alcohol will sterilize water too,
Oh, be careful now. There are 3 basic types of alcohol... two can easily make you go blind or kill...
--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 2, 2010 at 4:12 pm

#1245805
RE: Are the posted questions getting worse?

Roy Ernest (11/2/2010)
Tail of Tropical Storm Tomas hit Curacao (My island) leaving 3 people dead, lots material damage, 280 mm of rain and lightning. We are expecting more rain tonight....
--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 2, 2010 at 12:29 pm

#1245636
RE: REAL Sample Data available for free - better than fake!

jpSQLDude (11/2/2010)
Data sets with addresses, etc:
http://aws.amazon.com/publicdatasets/
http://www.manifold.net/updates/product_downloads.shtml
http://www.gsd.harvard.edu/gis/manual/realestate/index.htm
http://www.ibm.com/developerworks/xml/library/x-geomap2/index.html
http://www.gearthblog.com/blog/archives/2006/06/huge_database_u.html
Free data set generator, including names, addresses, phone numbers, emails, etc. Not real-world data, but probably pretty close and much easier than creating your...
--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 2, 2010 at 12:27 pm

#1245632
RE: how to check maximum dates in the csv files and insert into the sql tables using ssis

andrew gothard (10/30/2010)
As a side bar, I never load data directly into the "final" table from an outside source (like a file). It's too risky for a multitude of...
--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 2, 2010 at 12:20 pm

#1245627
RE: PARSING a Concatenated string into columns

The conversion to Excel messes up a bunch of things. Can you just direct the ouput of the query in the text message window to a file and attach...
--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 2, 2010 at 11:07 am

#1245562

Viewing 15 posts - 36,121 through 36,135 (of 59,067 total)